Professional Summary

• Over 7 years of experience as BI SQL Server Developer in the Design, Analysis, Development, Implementation, Testing, and Maintenance of application systems
• Experience in developing stored procedures, functions, triggers, views/materialized views, optimizing queries, table normalization denormalization
• Experience in data modeling design using Star schema identification of facts, measures and dimensions and Snowflake schema, Data Warehouse design using tools like Erwin and E-R Studio
• Experience in design development of ETL - DTS Packages SSIS Packages using heterogeneous sources and used multiple transformations such as Data Conversion, Conditional Split, Bulk Insert, merge, Union All etc.
• Designed and developed different types of SSRS reports such as, Cross-Tab, Cascading, Conditional, Drill-down, Drill through, Top N, Summary, Form, OLAP, Sub reports, adhoc, parameterized, interactive custom reports, also scheduled reports using SQL Server Agent
• Worked with security accessibility at server and item level in SSRS multi-user environment
• Developed cubes, partition aggregation and optimization using SSAS
• Worked with query optimization and performance tuning using SQL profiler, Index tuning wizard, Performance Monitor and Execution plan
• Documented the process and implementation of design development in twiki confluence
• Worked in multiple phases of SDLC also in different methodologies such as waterfall, iterative Agile, involved in release planning and scrum meetings
• Involved and supported production environments, helped identify resolved performance issues
• Mentored team members with process and design workflow
• Extremely dedicated, hardworking, strong team player with an ability to take new roles, excellent communication and strong analytical skills.

Technical Summary

Project Summary:

BI SSIS/SSRS/SQL Developer

Confidential

Responsibilities:

• Designed and developed reports for new medical products released for CVS
• Involved in data migration tasks to support updates to legacy reports
• Updated many of the legacy reports with new data source and the new attributes
• Worked with FACETS and NASCO databases to build different types of SSRS reports such as tabular, matrix, drill down etc.
• Created procedures, functions and packages to support new products released for CVS
• Worked closely with BA team for report requirements and documented them for implementation
• Involved in release planning, scrum meetings, review meetings and demo meetings
• Created a POC for Atomization project that involved legacy report delivery mechanism and automated it in using SSIS and SSRS with heterogeneous data sources
• Updated user interface guidelines with the changes from BA team to support new reports
• Created onboarding document with current facets/nasco database details, design and implementation
• Supported multiple production issues in reports, ETL packages and performance tuning queries
• Configured SQL email agent for DTS process failure or success notifications
• Developed triggers, functions, procedure, views and other database objects to support ETL or legacy system to new CVS product database

Environment: SSDT Data Tools 2012, Query Analyzer, Enterprise Manager, DTS, SSIS, SSRS, SSAS, T-SQL , SQL, MS Excel, MS Visual Studio, MS Visio

SSRS/SSIS/SSAS Developer

Confidential

Responsibilities:

• Designed and developed data migration process for migrating data from EDW to PWD using SSIS and SSRS services.
• Migrated crystal reports of EWD system to SSRS reports using reporting services, created sub-reports, multi-dimension reports and other tabular reports.
• Created migration process document for ETL and reports as part of on-boarding process.
• Created report layout guidelines document for report migration that enables QA to identity layout issues.
• Created multi-dimension reports involving cascading parameters in SSRS using SSAS cubes, dimension and measures.
• Worked on data mapping reporting issues involving EWD to PWD migration validating with data mapping and data mart sheet.
• Responsible for report deployment to both Dev and QA environments, also for reports fixed by off-shore development team.
• Created procedures packages to migrate data from into staging tables
• Create packages including procedures functions to enable support for Dev ops team
• Involved in discussions with BA users and team leads for requirements gathering and analysis
• Used PVCS tracker for bug tracking, also involved in bug triage with QA lead team.
• Used Team Foundation Server for code, report and project management
• Created ER entity relationship diagrams using MS Visio tool

Environment: SSIS, SSRS, SSAS, T-SQL, SQL, MS Excel, MS Visual Studio, BITS, SQL Query Analyzer

BI SSIS/SSRS/SSAS /SQL

Confidential

Responsibilities

• Created in creating complex SSIS packages using control and data flow elements.
• Created ETL packages with different data sources SQL Server, Flat Files, Excel source files, XML files etc and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages
• Created data loads and Upgrade scripts for data migrations and validations
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS, used error handling using TRY and CATCH blocks and performance tuning using counters in SSIS
• Worked on SSRS to generate more than 60 reports for various user groups and developer groups.
• Created Tabular reports, Matrix reports, List Chart reports, Parameterized reports, Sub reports, Cascaded parameterized reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Generate various ad hoc reports using MS Reporting services.
• Created various Weekly and Monthly reports showing detailed information.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Responsible to create dimensions with the cube wizard, refreshing cube to get the latest date updates, deployment of cubes to the production server.
• Used VISIO for database modeling.
• Prepared documentation related to database design, objects security and rules.
• Developed stored procedures to transform the data from enterprise data warehouse to data mart to build dimensions and load data to fact tables.
• Performed backup/restore of database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.
• Worked on T-SQL programming such as, stored procedures, user-defined functions, cursors, views and management of linked servers to Non-SQL-Server databases.
• Created functional and technical documents, report templates and reporting standards for the rest of team

Environment: SQL Server 2008R2, Query Analyzer, Enterprise Manager, DTS, SSIS, SSRS, T-SQL, Windows 2000/XP, SQL, MS Visio, XP professional

BI SSIS/SSAS / SQL

Confidential

Responsibilities

• Worked on mission-critical parts including ETL process using SQL Server Integration Services SSIS
• Developed the SQL Server Integration Services SSIS packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Scheduled the DTS package for migration data from old system to MS SQL 2008. Reconciled data for transformation from SQL 2005 to SQL 2008 using SSIS.
• Extracting the data from the different sources CSV files, oracle, and MS SQL 2000 and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Worked in migrating code from VSS to TFS.
• Extensively worked with Policy-Based Management i.e. Target, Facet ,Condition and Policy
• Extensive experience working with Transactional and snapshot replications.
• Involved in SSAS Cubes design by creating measure groups, dimensions, aggregations, Actions, Partitions and Perspective from huge dataset using SQL Server 2008 Analysis Services SSAS .
• Created Dimensions with the cube wizard and also individually.
• Refreshing the cube to get the latest information updated.
• Deployment of Cubes to the production server.
• Designed Star schema identification of facts, measures and dimensions and Snowflake schema.
• Created partition function, schema and file groups for fact tables.
• Involved in Normalization to 3F for OLTP system and some De Normalization for OLAP system.
• Performed maintenance of Stored Procedures to improve Performance of different front end Applications.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Build database queries and test cases for the testing team to test the reports
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.

Environment: MS SQL Server 2008R2,Windows Server 2008, DTS, T-SQL, SSIS, SSRS, SSAS, , PPS, Erwin 4.0, ETL, Erwin, XML, Excel, Visual Studio 2010.

MS SQL Developer BI SSIS/SSRS

Confidential

Responsibilities

• Designed new dynamic DTS Packages to transfer data between servers, load data into database and tuned the existing packages.
• Involved in designing the physical databases model on SQL Server 2000 RDBMS using different Data Definition and Manipulation languages DML/DDL implementing constraints and triggers for data integrity in development database for personal banking system.
• Migrated SQL server 2000 DTS packages to SQL Server 2005 SSIS packages using SQL Server 2005 Upgrade Advisor.
• Created new SSRS Reports in Visual Studio 2008 with enhanced layout and modifications. The new SSRS reports can be exported to CSV, text, Excel and PDF format depending upon the requirements.
• Developed Sub Reports, Matrix Reports and Tabular, Charts, Drill down, Drill through and Parameterized reports using SQL Server Reporting Services SSRS .
• Successfully deployed the reports on the Report Manager. Created SSIS packages for effective data migration.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Implemented Disaster Recovery plan using Log Shipping method.
• Created and maintained Database Maintenance plans and also created logins and assigned roles and granted permissions to users and groups.
• Performed optimization of query, triggers, and stored procedures, their testing focusing on stability and execution plan which has resulted up to 45 increase in performance of numerous modules.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Ensured developers coordinated their efforts in managing and maintaining different application databases.

Environment: DB2, SQL Server 2000/2005 Enterprise, Windows Enterprise Server 2003, BizTalk Server2004, IIS 6.0, Erwin, Microsoft Visio 2003, SFTP, Microsoft Reporting Service

MS SQL Developer

Confidential

Responsibilities

• Involved in requirement gathering, analysis, design, development, and deployment.
• Involved in designing ER diagrams and mapping the data into database objects.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages and wrote DTS scripts for data transfer.
• Configured SQL mail agent for sending automatic emails when a DTS process fails or succeeds.
• Creating and managing schema objects such as tables, views, cursors, indexes, procedures dynamically for any tables, triggers and maintained Referential Integrity
• Database and log backups and restoration, backup scheduling the backups. Backing up master and system databases and restoring them.
• Used Performance Monitor and SQL Profiler to optimize queries and enhanced the performance of database servers.
• Used various tools to improve SQL Server performance like windows performance monitor and index tuning wizard.
• Involved in testing, bug fixing and documentation for the project.
• Used Crystal Reports and MS Access to write complex formulas and to query the database to generate different types of ad-hoc reports.
• Migration of schema and data from Development and Production server.

Environment: MS SQL Server, DTS, Crystal reports, VSS, IIS 6.0, Windows XP

MS SQL Server Developer

Confidential

Responsibilities:

• Created tables and define their relations by using foreign key and primary key concept.
• Involved in creating databases and developing stored procedures, Triggers, Functions, Views and SQL Joins using TSQL. Created reports using Excel for better understanding of database.
• Performed normalization of data base to reduce redundancy and achieve maximum system performance. Used query analyzer to optimize queries and developed database and even configured based on the present need.
• Provided effective work independently from specifications and with a diverse group of developers and end users to analyze business needs and translated that need into deliverables.
• Performed backup, restore and replication using import/export wizard for the physical database.
• Solved the problems by re-configuring parameters and did performance tuning to improve system performance.

Environment: MSQL Server, DTS, Windows, SQL Server Management Studio, SQL Server Query Analyzer, SSAS, ETL, Erwin, MS Visual Source Safe , FTP Communication, MS-Visual Studio