Worked on SQL BI solution integration with Microsoft SharePoint Server (MOSS). Expertise in Ad-hoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects. Involved in Security Administration, Managing schemas (2005), creating Credentials, creation of users, configuring permissions and assigning roles to users. Experience in developing web applications using ASP.Net, ADO.Net and Web Services Involved in 24/7 production support and also experienced in testing environment. Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
MS SQL Server 2012/2008/2007/2005
MS Visio 7
HTML and XML
Expert in MATLAB
ASP.NET , C#
SQL Server Architect/TSQL/SSIS11/2012 to Current RBSCitizen Bank – Providence, RI
Experience in SQL Server DTS and SSIS (Integration Services) package design, development, and deployment using SQL 2008 advanced features in Control flow, data flow, Error Handling and event handling.
Expert in IBM Web Sphere Data Stage 8x/7x/6x ETL tools & Documentation.
Experience in SSIS package scripting, scheduling, monitoring, deployment and production support.
Real time Experience in Modify SSIS Package & Create SSIS Package by using different sources like XML, SSAS cube, Web-service.
Development & maintain Tools like C#, C++ related work tool.
Strong knowledge in Performance Point Server 2005/2007/2010 to designing dashboards and scorecards in highly complex scenarios with multiple KPIs, OLAP Charts and SSRS Reports.
Established standards for SQL installations, maintenance, tuning and coding Leader in the development of our OLAP Data Warehouse Reporting Initiative Provided training, mentoring, and feedback to team members to enhance communication and performance.
Developing reports on SSAS.
Database Architect/TSQL/SSIS/SSAS08/2011 to 11/2012 M&TBank / Wilmington Trust
M&T Bank has trade name in NYSE
ETL Developer01/2011 to 08/2011 Helzberg Diamond – Kansas City, MO
SQL Server/SSIS /SSAS/Data Stage Company Helzberg Diamonds Established since 1915, Helzberg Diamonds is Big name for Diamonds & Jewelry Retail Business in United States, Company have more than 300 Retail Stores in USA.
Hardware/Software MS SQL Server 2008, .NET, Data Stage 8.0/7.5.1(Ascential, IBM Web Sphere), Management Studio, SSIS, SQL Profiler, MS Excel (Documentation), Erwin Tool ,Windows XP Professional.
MS SQL Server Developer/SSAS/SSIS09/2009 to 12/2010 Ceridian Health Insurance – Minneapolis, MN
Ceridian is global company Provides big services in Health Insurance services with Ceridian health coaches can then help to make positive lifestyle changes for the long term, improving health and well-being.
We all need positive reinforcement, especially when it comes to change, and our incentive programs can provide with the motivation people need to get and stay healthy with any position company always with require support to people, During Project my goal to create SSIS package, Reporting Services, Maintain Performance by SQL Profiler.
SQL Architect/ SSIS/SSRS/Data Stage07/2008 to 09/2009 Avion Systems – Atlanta, GA
Avion Systems mission is to provide the highest quality and best value in services, solutions and innovations to its clients.
Company vision is to achieve the mission by strict adherence to a set of core values like, instilling trust by always taking responsibility for actions and being accountable for all that company provide services like RF measurement and RF testing.
MS SQL Server Developer/ SSRS Lead02/2007 to 07/2008 Morgan Stanley – New York, NY
Morgan Stanley is the true way to get financial services.
The firm has continually broken new ground in advising Company clients on strategic transactions, in pioneering the global expansion of finance and Credit check, Private Equity and in providing new opportunities for individual and institutional investors.
MS SQL Server Developer/SSAS01/2006 to 02/2007 Lehman Brothers – New York, NY
Lehman Brothers Provides Services on financial, Private Equity ,Investment Banking, Investment Management as well as providing new opportunities for individual and institutional investors.
Company has Branches in major cities in USA.
Database Developer11/2004 to 12/2005 SLK Software Vision of Company – Bangalore
To be the most inspiring business group in India, Admired globally for creating sustained prosperity.
Company Provide Services like Integrity, Application Reengineering and Application Development.
Company has branches in major cities in India.
Master of Science: Electrical Engineering2010University of Bridgeport-
Bachelor of Engineering (Computer Science)2004MS University-
Over 8+ years of experience in Data Modeling, Dimension Database Design, Programming, Development and Implementation of Client-Server Applications & Database systems using MSSQL 2012/2008/2007/2005 for both OLTP (Batch Processing, Online Processing) & Kimball Methodology.
Experience in various business domains like financial services, Insurance & healthcare, in high transactional and multi-server production environments.
Strong T-SQL experience in creating database objects like tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes.
Involved in relational data modeling (normalization, Relations) and multi-dimensional modeling using De-normalization, Fact tables, Dimension tables, Star schema for OLTP/OLAP systems.
Involved in heavy data migration/ETL activities using BCP, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2000/2005/2008).
Microsoft Certification in Database Developer
Microsoft Certification in BI Solution & BI Architect