SUMMARY

• Over 7 years of IT experience as a MS SQL Server Developer in various Industry verticals like Finance, Banking and Health Care.
• Extensive experience in MS SQL Server 2014/2012/2008/2005, Business Intelligence in MS SQL Server Integration Services(SSIS), MS SQL Server Reporting Services(SSRS), and MS SQL Server Analysis Services(SSAS).
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL)/DTS packages to perform data transfer from different server locations and heterogeneous sources like Oracle, Excel, CSV, XML, MS Word and Text Format Data.
• Expert in Creating, Configuring and Fine - tuning MS SQL Server Integration Services (SSIS).
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Extensive experience 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.
• Experience in designing and building database schema for various industries including finance and retailing industries.
• Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models, SQL joins and Query Writing.
• Highly experienced in using SSIS Import / Export Wizard, SSIS designer and other package execution utilities for performing the ETL operations.
• Highly experienced in strategically implementing the indexes such as clustered index, non-clustered index, covering index appropriately on data structures to achieve faster data retrieval.
• Extensively worked in Migration for MS SQL and MS SQL 2000 to MS SQL 2008.
• Experience in creating Packages, Jobs, sending alerts using SQL Mail and custom extended procedures.
• Expert writing SSIS Configuration, Logging, Procedural Error Handling and Data Error Handling, Master Child Load methods using Control tables.
• Good Hand on Resolving complex issues and Error Handling in SSIS.
• Developed cubes, partition aggregation and optimization using SSAS.
• Experienced in using multiple transformations provided by SSIS such as script component,Lookup, Data Conversion, Conditional Split, Bulk Insert, Merge, Merge Join, Union All, and Slowly Changing Dimension.
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.
• Strong experience in Database Installation, Capacity Planning, Implementing Backup and Recovery Strategy for application and database.
• Extremely dedicated, hardworking, strong team player with an ability to take new roles, excellent communication and strong analytical skills.

TECHNICAL SKILLS

Database: MS SQL Server 2000/2005/2008/2008 R2/2012/2014, Oracle 10g/11

Programming Languages: SQL, T-SQL, PL/SQL, MDX, MS-Access, .NET, C#, C, C++

SQL server Tools: SQL Server Integration services(SSIS), SQL Server Report Services(SSRS), SQL Server Analysis Services(SSAS), SQL Server Management Studio(SSMS), Tableau, Business Intelligence Development Studio (BIDS), SQL Server Profiler, SQL Query Analyzer, SQL Server Enterprise Manager, SQL Query Visual Source Safe 6.0, DTS, Data modeling, Import & Export Wizard, SQL Server Agent.

Tools: MS Visio, Erwin 4.0, MS Word, MS Excel, MS PowerPoint, Microsoft Visual Studio 2005/2008/2010

Web Technologies: XML, CSS, HTML

Operating System: Windows XP/NT/2000

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. MS SQL Server/BI Developer

Responsibilities:

• As a member of BI/Database team, involved in Requirement gathering, Technical Design, Development, Testing and Implementation of BI Analytics needs.
• As a scrum master, responsible for conducting daily scrums and followed agile Processes of sprint planning and backlog grooming.
• Actively involved in writing T-SQL Programming for implementing Stored Procedures and Functions and cursors, views for different tasks.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• Extensive understanding of managing and automating Control flow, Data flow, Events and Logging for SSIS packages using Microsoft .NET framework.
• Performing Data transfers between different homogeneous/heterogeneous systems (Excel, MS Access, Oracle and DB2, Teradata) and SQL Server as a part of Data Migration, Data Maintenance.
• Performed tuning of SQL queries and rewriting queries to improve the performance of database.
• Have migrated data from complex databases into power pivot add on in Microsoft excel and generated reports from them.
• Define best practices for Tableau report development.
• Experience in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Involved in package migration from DTS to SSIS, running upgrade advisor against DTS Packages before migration, troubleshooting issues and conversion into SSIS through wizard or manually.
• Configuredpackage logging, error loggingandevent handlingto redirect error rows and fix the errors in SSIS.
• Generated reports using SSRS, Power Pivot, and Power BI that could be used to send information to diverse group of users, clients, and managers.
• Developed several detail summary reports including line and pie charts, trend analysis reports and pivot tables according to business requirements using Power BI, Excel and SQL Server 2014.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.
• Experienced in creating and maintaining SSAS databases in both Multidimensional model and Tabular models in SSAS.
• Used third party tools like Pyramid to create Dashboards and ad hoc reports built on data from Cubes
• Migrated and resolved conversion errors for Performance Point Server reports to SharePoint 2010 Business Intelligence platform.
• Created statistical charts using Qlikview business intelligence software.
• Created Package Configurations to deploy the packages through DEV, TEST and PROD Environments.
• Developed the New columns & Measures using Power Query.
• Developed the dashboards with different charts and view objects using Power View.
• Published the Reports in the Power Bi.
• Refreshed Dashboards and reports in Power Bi using Power BI Pro gateway.

ENVIRONMENT: MS SQL Server 2005/2008 R2/2012, MS SQL Integration Services 2008 R2/2012, MS Access, MS SQL Reporting Services 2008 R2/2012, SSAS Cubes, MS Excel Power Bi, IBM DB2, SQL Server Agent, SharePoint 2007/2010, Visual Studio, TFS

Confidential, Dublin, Ohio

Sr. SQL/ETL Developer

Responsibilities:

• Involved in all phases of System Development Life Cycle (SDLC).
• Scheduled the jobs to streamline and automate cumbersome repeated tasks using SSIS.
• Extensively wrote and edited existing Stored Procedures, metadata, entity-relationship diagrams, User Defined Functions, database schema and Triggers using T-SQL.
• Created the Best Coding Practices Document for stored procedures & functions for the Developers.
• Created new database files and database file groups in SQL Server 2005 using SSMS and T-SQL.
• Good working experience in Visual Studio.Net 2005, ASP and SQL Server 2005. Developed reports using Crystal Reports and MS SQL reporting.
• Created Sub Reports and Drill down Reports as per the client requirements using SSRS.
• Worked on parameters to generate cascaded parameterized reports along with that extensively used global variables, expressions and functions.
• Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
• Log Shipping with Transactional Replication Database Mirroring, Database Replication.
• Responsible for deploying reports to Report Manager Cognos Analysis and Report extract and transfer, Troubleshooting for any error occurs in execution.
• Generated reports that can handle dynamic grouping and dynamic sorting for the purpose of efficient and clear viewing the reports.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2005.
• Designed and developed SSIS packages, MDX Scripting stored procedures, configuration files, tables, views, functions and implemented best practices to maintain optimal performance.
• Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using SQL Server integration services (SSIS).
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, sequence Container and conditional split, data conversion, derived column and multi casting.
• Created and rebuilt multi-dimensional cubes using SSAS to support business reporting and forecasting process, Optimized queries by getting insight from Execution Plan for better performance of the DB.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.

Environment: Windows, MS SQL Server 2012, MS SQL Server Reporting Services, MS SQL Server Integration Services, Server Analysis Services, Visual Studio 2010, .Net, Excel, Acrobat Reader

Confidential, Orange, CA

SQL BI Developer

Responsibilities:

• 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 Created in creating complex SSIS packages using control and data flow elements.
• Created to generate more than 60 reports for various user groups and developer groups.
• 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 2012, Query Analyzer, Enterprise Manager, DTS, SSIS, SSRS, T-SQL, Windows 2000/XP, SQL, MS Visio 2007, XP professional

Confidential, Houston, TX

SQL BI Developer

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.
• Up gradations of SQL server versions and applying patches and hot fixes.
• Build database queries and test cases for the testing team to test the reports.
• Deployment of databases, jobs, cubes from pre-production to production.
• 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

Confidential, Boston MA

SQL Server Developer

Responsibilities:

• Designed Dashboards with all kinds of charts (Gauges, Bar/Line charts, Maps, heat maps, Area charts). Designed ad-hoc reports, grouping and sorting using SSRS.
• Involved in designing sub reports and linked reports depending on the user requirement and to limit the number of Data Sources.
• SSRS reports to SharePoint Server for the end users to look at them.
• Created SSIS packages to transfer data from various sources like Oracle 10g, Excel, flat files into SQL server using different SSIS components and used dynamic configuration files and variables for production deployment.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Worked on creating calculated measures that fits business logic, using MDX queries.
• Handling Initial and Delta loads and processing Cubes (Star Schema) across all environments.
• Worked on Key Performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS). Involved in designing Data Marts.
• Wrote stored procedures for all the Database Interfaces, created user defined functions, constructed triggers, tables, views, indexes and user profiles.
• Developed Windows User Controls using Win forms controls and custom controls using c#.
• Configured application settings using the Configuration files.
• Consumed and created XML Web Services.

Environment: SQL Server 2000/2005/2008/2012, SSRS 2008/2012, SSIS/DTS, SSAS, Visual SourceSafe, Enterprise Manager, Query Analyzer, SQL Profiler, Active Directory and Windows XP platform, Web services, Visual Studios 2005