SUMMARY

• MS SQL Server Developer with Over 8+ years of strong experience in Information and Telecommunication, Insurance, Retail, Finance and Market Research domains.
• Highly proficient in operating MS SQL Server 2012/2008 R 2/2008/2005/2000 suite of products like SSIS, SSRS and SSAS.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Extensive experience in Business Intelligence in MS SQL Server Integration Services, MS SQL Server Reporting Services, and MS SQL Server Analysis Services.
• Hands on experience in Logical and Physical Database design & development, Normalization and Data modeling using Erwin data model.
• Proficient in using T - SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing.
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.
• Conversant in working with BCP, SSIS packages, creating jobs and linked servers for MS SQL Server/Oracle/ Sybase databases.
• Proficient in Creating, Configuring and Fine-tuning MS SQL Server Integration Services.
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Highly experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2008/2005.
• Expert in Design and optimization of OLTP, OLAP tools, creating SSAS based OLAP Cubes.
• Hands on experience in writing MDX queries to work with cube data.
• Proficient in using tools like MS SQL Profiler, Database Engine Tuning Advisor, Windows performance for monitoring and tuning SQL Server performance.
• Conversant in Database Installation, Capacity Planning, Implementing Backup and Recovery Strategy for application and database.
• Efficient in up gradation and migration from MS SQL Server 2000 to MS SQL Server 2008/2005.
• Strong leadership, communication, problem-solving and multi-tasking abilities. Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment, and working well under pressure.

TECHNICAL SKILLS:

• MS SQL Server 2012/2008 R 2/2008/2005/2000/7.0
• Analysis Services (SSAS)
• MS SQL Server Integration Service (SSIS)
• MS SQL Reporting Services (SSRS)
• Microsoft Access 2007/2003/8.0
• Microsoft Excel
• Outlook
• MS SQL Profiler
• SQL Query Analyzer
• MS SQL Server Index Tuning Wizard
• Erwin Data Modeler 4.2/4.1/4.0
• VB6
• Microsoft Products MS Word
• MS Excel
• VSS
• MS Access
• MS Power Point
• T-SQL
• PL-SQL
• HTML
• XML
• C++
• Crystal Reports 8.5
• MS Visio 2003
• Windows 2003/2000 Advanced Server/Professional
• Windows NT 4.0 Server/Workstation.

PROFESSIONAL EXPERIENCE:

Confidential, McLean, VA

BI/MS SQL Server Developer

Responsibilities:

• mposed low level design documents of ETL from source (Oracle, DB2, flat file) to target (Oracle 11g).
• Analyzed requirement documents and queried the source systems for ETL design
• Create Informatica mappings using MS Visio 2010and write SQL override inDB2 Version 9.5
• Presented the design documents in review meeting to the whole data movement team
• Communicated with testing and coding team to assist their building and testing works.
• Studied and Analyzed the Business requirement and prepared scope document, ETL specification documents according to the business requirements.
• Design of ETL mappings for the CDC (change data capture)
• Source and Target databases resided on Oracle.
• Conducted design review meetings with the architect for any new requirement to get the approval and designed the mappings according to the company standards.
• Used MS Visio 2010to populate the Informatica design flows.
• Assisted in Informatica Administration using Repository manager.
• Developed Complex mappings to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Sequence Generator, Joiner, Union, Filter, Update Strategy, Rank and Router transformations.
• Worked with Informatica Labels in labeling the designed components for deployment of code to TEST and PROD.
• Well versed with Informatica Team based development (Versioning).
• Used Informatica versioning to check in and check out the objects in designer and workflow manager.
• Troubleshoot problems by checking sessions and error logs. Also used debugger for complex problem troubleshooting.
• Write complex SQL queries to test the data generated by ETL process against target data base.
• Used Toad to access the Oracle tables execute SQL queries.
• Designed complex mappings involving target load order and constraint based loading.
• Performance tuning, bug fixing and error handling.
• Create parameter files for the all the designed mappings and used parameter files for defining all the connection values( Source, Target, Lookup) and mapping parameters used in the Informatica sessions.
• Design Technical documents, ETL Unit test plan document, Migration Check list document.

Confidential, Richardson, TX

MS SQL Server SSIS/SSRS Developer

Responsibilities:

• Worked with business stakeholders, application developers, productionteams and across functional units to identify business needs and discuss solution options.
• Agile methodology was used throughout the project, Performed pivotal role in planning and developing as well as aligning with the assigned sprints.
• Developed and deployed SSIS packages for ETL fromOLTP and various sources to staging and staging toData warehouseusing For Each Loop Container, Execute Package task, Execute SQL Task, Sent Mail task,Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimensionand more. Performed ETL mappings using MS SQL Server IntegrationServices.
• Supported Production Environment with schedule the packages and make the package dynamic with SQL Server Package Configuration.
• Built data marts and cubes with SSAS for fast target data retrieval.
• Designed and Deployed Cubes in SSAS 2012. Created Fact and Dimension tables.Used MDX (Multi-dimensional Expressions) for the calculated members and the KPI (Key Performance Indicators).
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Created/Updated database objects like tables, views, stored procedures,function, packages.
• Designed Change data capture to capture insert, update, and delete activity applied to SQL Server tables, and to make the details of the changes available in an easily consumed relational format.
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity ofthe data after the insert, update or delete.
• Deployed reports on Report Server and SharePoint Server also scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Developed and delivered dynamic reporting solutions using MS SQL Server 2008 Reporting Services (SSRS).
• Involved in monitoring and tuning report performance by analyzing the execution plan of the report.
• Generated Drill down, Drill through, Matrix Reports, parameterized reports, cascading parameterized Reports using SSRS.
• Designed and developed monthly, quarterly and yearly reports at branch and company level.
• Created complex dashboard report based on statistical data provided by the users.
• Involved in table and indexpartitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensuredatabase optimization.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimizeperformance.
• Used SQL Server Profiler to trace the slow running queries and the server activity.

Confidential, Denver, CO

MS SQL Server/ SSIS Developer

Responsibilities:

• Performed Data transfers between different homogeneous/heterogeneous systems (Excel, MS Access)
• Working experience in BI Solutions (ETL & Reporting) using SSIS and T-SQL Programming using DDL, DML commands for various business applications.
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
• Effectively used Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints and Indexes.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and fine tune the same to improve performance.
• Wrote C# script in Script task of control flow.
• Experienced in Error handling and debugging coding issues and troubleshoot production problems.
• Experienced in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor.
• Well-versed in usage of SSIS Control Flow items(for Loop, Execute package/SQL tasks, script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping).
• Developed SSIS package for implementing Slowly Changing Dimension. Fact Load and Dimension Load. Incremental Load.
• Used incremental approach in the Work Flows and Data Flows to integrate source data into warehouse tables using required transformations.
• Involved in configuring and creating SSIS solutions for ETL and Business Intelligence Process for data integration and migration services.
• Experienced in creating configuration files to deploy the SSIS packages across all environments.
• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.

Confidential, CT

MS SQL /SSIS/SSRS/SSAS Server developer

Responsibilities:

• Transformed data from different data sources like Oracle, Flat files, SQL data bases to SQL Server 2008 using OLEDB connection providers by creating various SSIS packages. Data is transformed from hub (ODS) to data warehouse.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data from ODS to related destination databases for residential, business, large business users.
• Created SQL server Analysis Projects andcreated multi-dimensional databases and OLAP cubesand dimensions for the analysis of capacity planning task in specific areas for departmental manager using SSAS.
• Built data marts and cubes with SSAS for fast target data retrieval.
• Designed and Deployed Cubes in SSAS 2012. Created Fact and Dimension tables.Used MDX (Multi-dimensional Expressions) for the calculated members and the KPI (Key Performance Indicators).
• Migrated the data from the appropriate databases to end database and maintained batch log files. Involved in the usage of variables to make the packages dynamic and scheduling the package in SSIS (sequential scheduling).
• Implemented AD HOC reporting with the report builder for the end users. Involved in scheduling reports to run weekly, quarterly, monthly based on the data to be reviewed by the manager.
• Generating Drill- through, Drill down, Matrix, Snapshot reports using the data from the Data warehouse using SSRS with Microsoft Share Point Integration 2007.
• Involved in identifying and creating data sources and data source views in SSAS. Involved in Creating Dimensions and Cubes and deployed it on to the server for the managers to analyze the ongoing production support for the application as required.
• Implemented the elements of T-SQL like dynamic stored procedure to store and update the information regarding residential, business and large business customers into one centralized SQL database called hub.
• Enhanced the business logic using User Defined Functions to retrieve information on the services like Retailers Debit, Credit etc.
• Created indexes on the database tables and generated trace events to improve the query performance and optimize data access.

Confidential, Dallas, TX

MS SQL Server SSIS/SSRS Developer

Responsibilities:

• Involved in planning, defining and designing data based on business requirement and provided documentation for further . Involved in installation and configuration of MS SQL Server 2005/2008.
• Involved in designing database and perform forward engineering, from conceptual data model to Logical and physical data model using Erwin 7.2 data modeler tool.
• Developed various T-SQL stored procedures triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Wrote complex Stored Procedure, Queries, Triggers, User-defined functions as per the business requirements.
• Extensive experience with optimizing existing stored procedures and various T-SQL queries.
• Involved in migrating data from MS SQL server 2000/2005 database to MS SQL server 2005/2008 database.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages. Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional split, Derived column etc.
• Developed packages to handle data cleansing, loading multiple files and executing tasks multiple times (using For Each Loop )
• Developed Master Child Package by using Execute Package Task and Parent Package Variable Configuration.
• Modified the Existing SSIS Packages and added more audits and alerts in case of package failure
• Developed unit test plans for SSIS packages. Modified the existing SSIS packages to meet the changes specified by the users. Scheduled jobs for executing the stored SSIS packages which were developed to update the database on Daily/Weekly/Monthly basis.
• Designed, developed and deployed reports in MS SQL server environment using SSRS 2005/2008. Generated Sub-reports, Drill down, Drill through and Parameterized reports using SSRS 20005/2008. Created reports to retrieve data using stored procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the dashboard. Responsible for monitoring and tuning SSRS Report Performance.
• Involved in the development and designing of XML, HTML using cascading style sheets for displaying the reports on the report server. Configured the report viewing security for various users at various levels using report manager.
• Fine-tuned SQL queries for maximum efficiency and performance. Provided documentation for all kinds of reports and SSIS packages. Designed and implemented stored procedures and triggers for automating tasks.

Confidential, Groton, CT

MS SQL Server Developer

Responsibilities:

• Used the SSIS to migrate databases such as Oracle and Access database, flat files to centralized SQL server destination. Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
• Installed and configured MS SQL Server 2005 along with Visual Studio on a network domain system.
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users.
• Implemented slowly changing dimension on 500,000 records that took 11minutes to complete. Improved the performance by replacing it with checksum to 8 minutes.
• Designed DTS/SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2000/2005 environment, and deploy the data.
• Used Event Handlers for Exception Handling in SSIS packages.
• Generated reports on wealth information, account information, research reports using ad hoc reporting to be used by the clients and advisors.
• Created Queries, Stored Procedures, and Views to store the data of clients, advisors.
• Created User Defined Functions, Triggers to store data into appropriate tables as and wData arrives and created indexes to the tables to improve the query performance.
• Conducted performance tuning by using SQL Profiler and index tuning wizard.
• Created many complex Stored Procedures/Functions and used them in Reports.
• Designed, developed and deployed reports in MS SQL server environment using SSRS 2005/2008. Generated Sub-reports, Drill down, Drill through and Parameterized reports using SSRS 20005/2008. Created reports to retrieve data using stored procedures that accept parameters

Confidential, Louisville, KY

MS SQL Server Developer

Responsibilities:

• Involved in data transfer from source to target specifications.
• Created complex stored procedures, functions, views, triggers and indexes.
• Involved in assisting QA team in deploying and testing the applications which uses SQL server as database
• Experienced in performance tuning and optimizing for SQL server application by using performance monitor
• Extensive experience in creating Sub-reports, drill-down reports, summary reports and parameterized reports in SSRS.
• Generated reports using SSRS that could be used to send information to different primary vendors, clients and managers
• Created DTS package to schedule the jobs for batch processing.
• Performance tuning to optimize SQL queries using query analyzer.
• Created indexes, constraints and rules on database objects