SUMMARY

• Around 8 years of IT Experience in Database Design, Development, Implementation and Support of Microsoft SQL Server 2012/2008/2005 /2000 and SQL BI Suite(SSIS,SSRS,SSAS) in Development, Testing and Production Environments with various business domain. Experience working on Data warehousing design and development.
• Solid noledge of Relational Database Management System (RDMS), Data Warehouse Concepts, OLTP & OLAP and experience with MS SQL Server in writing T - SQL, Working on SSIS, SSAS, SSRS, Data Analysis, Data Cleansing/Data Scrubbing and Data Migration.
• Experience in SQL Server Suite of products (SSRS/SSIS/SSAS) and involved in all phases of Software Development Life Cycle from gathering requirement, development, implementation, testing and support.
• Experience working on Data Warehousing, Enterprise Data Warehousing (EDW) star schema (Kimball and Inmon), snow flake schema, Dimensional Modeling and relational database experience including MS SQL Server, MS Access and Oracle.
• Proficient in creating ETL packages using SQL Server 2008/2005 Integration Services (SSIS).
• Experience in incremental data migration from various data sources (Flat Files, Excel, MS Access, oracle) using ETL.
• Worked on SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Experience in configuring SSIS configurations, custom logging and custom components.
• Proficient in designing, developing and maintenance of enterprise reports using SQL Server Reporting Services (SSRS).
• Experience with the Share point 2007/2010 to upload the SSRS reports to Web portal.
• Specialized in creating several reports such as drill down reports, drill through reports, parameterized reports, linked reports, sub reports, Matrix Reports, Charts using SQL Server Reporting Services.
• Extensive Knowledge in email subscriptions for data driven reports by using Report Manager.
• Created SSAS cubes with multiple Fact tables and Cube calculations and cube localization, KPI’s, Cube partitions.
• SSAS Cube security using NT authentication, created cube roles and membership.
• Good understanding of master data management (MDM), Operational data source (ODS) and also concepts behind development, build and support of EDW (Enterprise Datawarehouse).
• Expertise in designing/creating several reporting services reports dat has been formatted specifically for dashboard displays, i.e. with charts, KPIS, tables.
• Experience in creating indexed views, Complex Queries, complex stored procedures, TEMPeffective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Has hands on experience in Performance Tuning and Query Optimization using tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Create and maintain documentation for projects according to the business standards and naming conventions.

TECHNICAL SKILLS

RDBMS: SQL Server 2012/2008/2005, 7.0, MS-Access, Oracle Database 11g/10g/9i, DB2, MySQL, and Teradata V2RX.

Front End: MS Visual Basics 6.0.

Web Technologies: HTML, XML, JavaScript, PHP, Shell Scripting.

Version Controlling Tools: Visual Source Safe, Clear Case.

SQL Server Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, Business Intelligence Development Studio, SSIS, SSAS, SSRS, Data Transformation Services, EDI.

Web Server Technologies: IIS 5.1/6.0.

Data Modeling Tool: Erwin r7.3/7x/4.0, MS Office Visio 2003/2007

Operating System: Windows 2000, Windows Server 2003, Windows NT, Windows 95/98/2000 XP/Vista/7, Unix.

Methodologies: Logical and Physical Database Design, Star Schema, Snow Flake Model, UML, Database Design and Normalization.

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr. BI Project Engineer/Sr.SQL BI Developer

Responsibilities:

• Involved in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Worked on couple of POC's (Proof of Concepts) to demonstrate BI capabilities.
• Good experience in Data Modeling (Physical and Logical) with expertise in creating Star & Snow-Flake Schemas, FACT and Dimensions Tables using Erwin.
• Involved in the Finance Enterprise Management Data warehouse (EPM) design and development.
• Responsible for the data and metadata management and Business Intelligence (BI) solutions using Microsoft SQL Server 2005 Integration Services (SSIS), SQL Server Reporting Service (SSRS) including MDX Development, and SQL Server Analysis Service (SSAS).
• Involve in entire cycle of BI process right from requirement gathering, design stage, ETL (SSIS), Building cubes(SSAS), Reporting (SSRS).
• Involved inUnit testing, System testingto check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Experience in Performance Tuning and Query Optimization using tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor (DTA).
• Develop SSIS packages to move data from various sources to SQL server data warehouse.
• Hands on experience on advanced topics of SSIS configurations, logging, custom components.
• Upgrade ETL packages from 2008 to 2012 and fix the compatibility issues.
• Involved in complete life cycle of ETL architecture right from requirements gathering from users, design, staging, development, deployment and support.
• Created SSAS cubes with multiple Fact tables and Cube calculations and cube localization, KPI’s, Cube partitions.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Deployed reports in to Report Manager and created Ad-Hoc reports using Report Builder.
• Extensively generated and deployed parameterized reports, Drill-down reports, sub reports, dashboards using SSRS.
• Create dashboards, scorecards, cross tab and other complex reports and publish using SharePoint.
• Created a tree view application to view the recent reports generated and Used SSRS to schedule reports to be generated on predetermined time.

Environment: Microsoft SQL Server 2012/2008/2008 R2/2005, SSIS, SSRS, SSAS, PeopleSoft, MS IIS, VB.net, VBA Script, C#, SQL source Control, SharePoint 2013, Performance Point, Power Pivot, T-SQL, PL/SQL, Oracle 10g/9i

Confidential, Parsippany, NJ

Sr. SQL BI Developer/DBA

Responsibilities:

• Involved in requirement gathering, Data warehouse schema design (star schema and snowflake schema) and breaking down EDW (Enterprise Datawarehouse) to data marts.
• Performed design/code reviews to make sure dat the design/code adheres to customers’ standards and meets industry’s best practices.
• Designed dynamic SSIS with VB.Net to transfer data crossing different platforms, validate data and data clearing during transferring, and archived data files for different DBMS.
• Layout design plan for ETL process to populate dimensions and fact tables.
• Experience in development of Entity Relationship Diagrams (ERD).
• Used SSIS 2008 created various packages to bring data into the staging area from various sources like text files, Excel and SQL Server databases, worked on large data sets and ETL Data Conversion.
• Experience in usingChange Data Capture (CDC)functionality of SQL Server along with SSIS to populate the destination tables with inserted, updated and deleted data.
• Experience with SSIS performance tuning using counters, error handling (Package level and Data level), event handling, checkpoints and scripting with VB.NET and C# in SSIS.
• Worked on SSIS logging and on SSIS configurations using XML, SQL run tables and various dynamic expressions.
• Deploy and maintain SSIS packages both by using SQL and File system deployment.
• Strong experience in ETL design and development in Transact SQL.
• Experience with the SharePoint to upload the SSRS reports to Web portal and maintain report refresh schedules and dashboards.
• Identified the requirements for generating dynamic and ad-hoc reports (Cross-Tab, Drill-down and Sub-Report) using SSRS
• Created automated jobs using SQL server agent and scheduled subscriptions for reports on server to the targeted users daily, weekly, monthly.
• Developed complex stored procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Create dashboards, scorecards, charts using SSRS for display screens and maintain caching, snapshots for reports, use data driven subscriptions to users.
• Developed SSAS Cubes and build KPI’s, create translations, cube calculations, cube partitions in SSAS cubes and cube localization concepts.
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS), querying the data with MDX script and generated SSRS reports out of cube.
• Contribute and write technical, functional requirements as a part of SRS (software requirement specifications).

Environment: Microsoft SQL Server 2012/2008/2008 R2/2005, SSIS, SSRS, SSAS, SAP, MS Access, Informatica, MS IIS, VB.net, VBA Script, C#, SQL source Control, SharePoint 2013, Performance Point, Power Pivot.

Confidential, Virginia

SQL Developer

Responsibilities:

• Documented and delivered functional specification document to the project team. Assisted the Project Manager to develop both high-level and detailed application architecture to meet user requests and business needs.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS.
• Worked on migrating daily shipment data from Oracle database (Enterprise Data Warehouse) to Teradata database (Operational Data Source).
• Configure, create and maintain packages for data extraction from Flat Files, Excel Files OLEDB and Access etc. using SQL Server Integration Services (SSIS).
• Created ETL packages with different data sources (SQL Server, Sybase, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Experience with the Share point 2007 to upload the SSIS packages in to Web portal.
• Developed reports using Cognos and experience working with report studio, query studio and framework manager.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Deployed reports in to Report Manager and created Ad-Hoc reports using Report Builder.
• Create dashboards, scorecards, drill down, sub reports, cross tab and other complex reports and publish using SharePoint.
• Created a tree view application to view the recent reports generated and Used SSRS to schedule reports to be generated on predetermined time.
• Implemented SQL Server OLAP services (SSAS) for building the multidimensional cubes to slice and dice the data and create prototype SQL Server 2005 Analysis Services cubes using the Unified Dimensional Model (UDM).
• Designed OLAP Star and Snow-flake schemas and then Dimension and Fact Tables.
• Generated testcases to meet the functionalities deliverables in the project documentation and specifications.
• Ensure database integrity, indexing, segmentation and recovery and update database design over time
• Performed DBA functions, installing, configuring and supporting SQL Server based database systems
• Generated Reports using Global Variables, Expressions and Functions
• Running DBCC consistency checks and fixing data corruption in databases.
• Created the star schema for OLAPreporting, data archiving and data marts and defined MDX/DAX scripts for querying the data from cubes (SSAS) and build dashboard reports on top of cubes.
• Responsible for database design, including optimizing the database schema and coding database procedures/queries.

Environment: Microsoft SQL Server 2008/2005,SSIS, SSRS, SSAS, Linux, Red gate Tools, Teradata, Cognos, ERWIN, ASP.NET 2.0,VB.net, C#,TFS,MS IIS, SQL source Control, Oracle 10g/11g, SharePoint. policies of the customers.

Confidential, CT

ETL/ BI Developer

Responsibilities:

• Created detailed design and requirements documents with logic to help team members understand the requirements and design
• Performed design/code reviews to make sure dat the design/code adheres to customers’ standards and meets industry’s best practices.
• Responsible for the data and metadata management and Business Intelligence (BI) solutions using Microsoft SQL Server 2005 Integration Services (SSIS), SQL Server Reporting Service (SSRS) including MDX Development, and SQL Server Analysis Service (SSAS).
• Designed dynamic SSIS with VB.Net to transfer data crossing different platforms, validate data and data clearing during transferring, and archived data files for different DBMS.
• Deployed SSIS packages and Scheduled Jobs.
• Enabled stuctured data transmission between two systems using EDI.
• Wrote various queries and store procedure, and Troubleshoot database related issues
• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Extensively worked on Performance Tuning ofTeradataSQLusing explain plan and understanding Joins and Data distribution
• Designed OLAP Star and Snow-flake schemas and then Dimension and Fact Tables.
• Generated testcases to meet the functionalities deliverables in the project documentation and specifications.
• Ensure database integrity, indexing, segmentation and recovery and update database design over time
• Performed DBA functions, installing, configuring and supporting SQL Server based database systems

Environment: SQL Server 2005,2008, T-SQL,MS Visual Studio 2005,2008 (SSIS,SSAS,SSRS),EDI, Dashboards, Windows 2003, MS Access 2007, C#, ASP.Net, Oracle Database 11g, ERwin r7.3.

Confidential, Minneapolis, MN

Sr.SQL Server Developer

Responsibilities:

• Gather and define reporting requirements, document reporting specifications and complete analysis and design on new reports.
• Knowledge of capital markets including fixed income, OTC derivatives, MBS (Mortgage Bank Securities).
• Extensive noledge of GAAP, financial accounting, investment banking, fixed income products and financial statements.
• Generated finance data marts with the data from wealth management domain, very good understanding of wealth management domain to write ETL using SSIS.
• Analyze, design, develop and document reports using Microsoft SQL Server 2008 and SSRS against proprietary and packaged application databases
• Create operational reports, parameterized, dashboards, drill down, sub reports, cross tab and other complex reports and publish using SharePoint.
• Write complex SQL queries and stored procedures to meet business requirements
• Unit test reports to identify defects, data issues and troubleshoot to resolve bugs and to ensure an accurate, high quality end product for delivery to reporting users
• Test and manage the SSIS packages and schedule SSIS, SQL jobs using SQL server job agent.
• Build several multi dimension cubes using SQL Server Analysis Services (SSAS).

Confidential

SQL Developer

Responsibilities:

• Interfaced with the client as part of the Requirements engineering team to finalize the project scope.
• Designed the migration plan in accordance with the business standards and practices and addressing the incompatibility and inconsistencies of the existing application.
• Worked closely with Database Architects in designing Data marts and Data warehouse.
• Created cubes using SSAS as per business requirement.
• Involved in extracting the data from transaction system to staging area from various sources like MS Excel, MS Access, and Oracle using ETL (SSIS).
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Used SQL Server Agent to automate the SSIS package execution
• Configured and maintained Report Manager and Report Server for SSRS
• Identified the requirements for generating dynamic and ad-hoc reports (Cross-Tab, Drill-down and Sub-Report) using SSRS
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Work with various SAS products SAS/BASE, SAS/GRID, SAS/STAT, SAS/GRAPH, and SAS MACROS to develop required solutions.
• Generated Reports using Global Variables, Expressions and Functions
• Created Crystal Reports as per business requirements.
• Wrote Complex Stored Procedures, Triggers, Views and Queries
• Used SQL Server Profiler and Performance Monitor, stored procedures, triggers, and functions to monitor and improve the performance of the database servers.

Environment: MS SQL Server 2008, SSRS, SSIS, SSAS, T- SQL, MDX, Erwin, SAS, MS Excel 2003, Visual Studio 2005