SUMMARY

• Over eight plus years of extensive experience and hands on working knowledge in various domains of IT industry like Health care, financial and insurance as SQL/MSBI Programmer.
• Hands on experience in MS SQL Server 2014, 2012, 2008 R 2/2008/2005/2000 with Business Intelligence in SQL Server Integration Services, SQL Server Analysis Services and SQL Server Reporting Services.
• Experience in Handling Heterogeneous data sources, databases Oracle, IBM DB2 and XML files using SSIS.
• Experience in RDBMS database design, performance tuning, optimization, client requirement Analysis, Logical design, development, Testing, Deployment and Support.
• Expertise in Transact - SQL (DDL, DML) and in Design and Normalization.
• Involved in dimensional data model design, ETL frameworks and processing, metadata management, operational data integration, master data management and data quality, data auditing and profiling, and business intelligence reporting solutions.
• Experience in testing and validating data repositories, including data accuracy, data quality, and performance.
• Strong Knowledge on Data Cleansing, Matching, Referencing, Profiling and monitoring using Data Quality Services (DQS).
• Worked on system performance and data quality issues.
• Good proficiency in SSAS cubes development and processing including Dimensions and measures design, MDX queries.
• Good experience in developing reports using SQL Server (SSRS).
• 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.
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Proficient in Performance Tuning of SQL query, troubleshooting the performance problems, fine-tuning of databases and Index Analysis.
• Involved in performance tuning and query optimization using tools like SQL Server Profiler, Database Tuning Advisor and Index Tuning Wizard.
• Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Involved in working with databases in C# and Microsoft Visual Studio .Net environment.
• Involved in writing C#.net code for SSIS 2008/2005 packages.
• Experience in co-coordinating with off shore team.
• Knowledge on SCRUM/AGILE development methodologies.
• Ability to work independently and in a team, capable of handling time-sensitive issues in distributed environments.

TECHNICAL SKILLS

RDBMS/DBMS: MS-SQL Server 2014/2012/2008 R 2/2008/2005/2000 , Oracle 11g/10g/9i/8i, MySQL and MS Access 2003/2000/97

Database Technologies/Tools: SQL Server Enterprise Manager, Microsoft Management Console, SQL, T-SQL, Data Transformation Services (DTS), Windows Azure, OLTP, BCP, SSIS, MDS, MDM, DQS, OLAP, Microsoft Visio, ER Studio

Reporting Tools: Microsoft SQL Server Reporting Services, Crystal Reports.

Operating Systems: Windows XP, 2000, NT, 98, 95, Windows 2003, Windows Vista, Windows 8

Programming Languages: T-SQL, PL/SQL, HTML, VBA, C#.Net, VB.Net, C++, Java, Java script, Perl, Python, CSS, Windows Scripts, Unix Scripts

Design Technologies/Tools: Erwin, MS Visio, Rational Rose

Data Warehouse/BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio 2013/2010/2008 , SSAS, Business Intelligence Development Studio (BIDS) 2008, MS Data Tools 2012/2014, Visual Studio Shell 2013

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

SQL Server Data ware house Developer

Responsibilities:

• Design and develop SSIS packages, store procedures, configuration files, tables, views and functions, implement best practices to maintain optimal performance.
• Conduct code walkthroughs and review peer code and documentation.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
• Created system for capturing, reporting, and correcting error data.
• Work with DBAs, and systems support personnel in elevating and automating successful code to production and provided on call production support.
• Creating Star schema cubes usingSSAS.
• Deployed and processed SSAS cubes daily/Weekly to update information using SQL Server Agent.
• Created MDX queries to extract data from the Data Mart.
• Involved in updating slowly changing dimensions strategies.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Designed and built OLAP cubes to meet reporting needs.
• Responsible for identifying and defining Data Source and Data Source views.
• Created cubes and defined the dimensions.
• Responsible for defining calculated members.
• Developed Multi-dimensional Objects (Cubes, Dimensions) using MS Analysis Services (SSAS)
• Gather requirements and design of data warehouse and data mart entities.
• Wrote complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Configured SSIS packages and Stored Procedures in Automate 9 Scripts for automating the process of data loads.

Environment: MS SQL Server 2014/2012, BIDS DATA TOOLS, T-SQL, SQL Server Agent, SSIS, SSRS, SSAS, VB.net, C#, Visual Studio 2013, Windows Server 2012, Automate 9, VBA, MS Access, Windows Azure, XML, MS Office and MS Excel

Confidential, Pleasanton, CA

SQL Server ETL and Report Lead Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process and understanding the functional work flow of information from source systems to destination systems.
• Involved in daily batch loads into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2014.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS.
• Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.
• Defined Key Performance Indicator metrics to create scorecards.
• Involved in creating report models and applying row level security filters for report model.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Created E-commerce daily, weekly, monthly and Yearly ad-hoc reports for finance department.
• Perform data analysis and develop data mapping and functional solution design documents.
• Implemented data driven subscription using SSIS and C# script in the script component.
• Developed on complex T-SQL scripts and worked on Windows Azure machine.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise.

Environment: MS SQL Server 2014/2012, BIDS DATA TOOLS, T-SQL, SQL Server Agent, SSIS, SSRS, SSAS, VB.net, C#, Visual Studio 2013, Windows Server 2012, Windows Azure,TERADATA, XML, MS Office and MS Excel.

Confidential, San Mateo, CA

Lead SSIS/SQL Server DBA/Developer

Responsibilities:

• Extensively worked on data analysis and cleansing.
• Worked closely with end-user clients to understand their reporting needs and provided necessary solution.
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application on Windows Azure machine.
• Worked on index tuning to improve the performance.
• Coded windows scripts and created batch files for file transfers and integrated with SSIS.
• Developed C# scripts to validate the columns of the flat files and created temporary tables using dynamic SQL queries to load data from multiple data files into single table.
• Co-ordinated with Qlikview reporting team to provide the required data for building dashboards.
• Troubleshooting DB performance issue and implementing necessary DB changes and implemented processes to ensure Optimal Query Performance.
• Co-ordinated between the business team and off shore team.

Environment: MS SQL Server 2014/2012, DATA TOOLS, T-SQL, SQL Server Agent, VB.net, C#, Visual Studio 2013/2010, XML, MS Office, MS Visual source safe, TFS, MS Excel and MS Visio. Windows Azure and PowerShell, Microsoft Visual Studio Tools for Applications 3.0, SQL Server Integration Services, QlikView 11.20 and Qlik Sense 2.0.2, Applications: NetSuite

Confidential, Foster City, CA

Senior SQL Server/MS BI Developer

Responsibilities:

• Developed modular ETL applications which enable the flow of data between data sources using SSIS.
• Worked on migration of the databases from SQL Server 2000 to SQL server 2012.
• Loaded new and changed records from source systems into staging and implemented Data cleansing.
• Delivered the ETL high level functional and technical design document for program.
• Coded VB.net and C# scripts using script task transformation to meet complex functionality requirements.
• Worked with database administrators and developed high performing ETL and maintain consistent development functions.
• Worked on Performance tuning the SQL scripts and SSIS packages and solutions to improve the overall execution time.
• Created and modified the indexes on the tables and views for the improvement in the performance of SQL Stored procedures.
• Created proxy accounts, Jobs and scheduled for SSIS packages on the UAT and production server.
• Developed ETL solutions and SQL Scripts with ERROR HANDLING and ERROR LOGGING
• Involved in ETL architecture enhancements to increase the performance using query optimizer
• Developed T-SQL Queries and stored procedures, Cursors, triggers, views and adding/changing tables for data load and transformation and data extraction.

Environment: MS SQL Server 2012, 2008 R2/2000, DTS, Master Data Services, MDM, DATA TOOLS, T-SQL, VB.net, C#, Visual Studio 2013/2010/2008 , XML, XSLT, MS Office and Visual source safe, Requisite Pro, TFS, MS Excel, and MS Visio. Microsoft Visual Studio Tools for Applications 3.0, SSAS, SSIS, SSRS, SharePoint 2013, SQL Server Reporting ServicesApplications: Workforce Timekeeper Kronos 4.3/6.3 and Concur.

Confidential, Richmond, VA/Newbury park, CA

SQL Serve DBA/MS BI Developer

Responsibilities:

• Worked on the project using specifically Agile and Scrum methodology with the short term releases.
• Worked on the complex stored procedures and scripts supporting HIPAA transactions.
• Built Complex Stored Procedures for writing SSIS Package Logs into Physical Database.
• Worked with SSIS packages involved FTP tasks, Merge, and Merge joining, Sort, Pivot and Unpivot Control Flow Transformations.
• Created and maintained Data Warehouse data model following set standards, utilizing both Relational and Dimensional Modeling techniques.
• Responsible for regression testing ETL jobs before test to production migration.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Executed Transact-SQL batches, system procedures, and script files at the command prompt using SQL cmd Utility.
• Improved the performance of the application by rewriting the SQL queries.
• Involved in designing and developing enterprise reports (SSRS/Business Objects) using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Experience in writing MDX queries and in developing OLAP cubes using SSAS for data mining and created reports from the OLAP cubes using SSRS and Report Builder 3.0.
• Developed the database application using agile methodology along with Java development.
• Developed unit test plans for SSIS packages and created a technical documentation.

Environment: MS SQL Server 2012, 2008 R2/2008, SQL Server Integration Services (SSIS), BIDS, T-SQL, SSAS, SQL Server Agent, QNXT 5.0 including EDI Manager, Java, C#, IBM Mainframes, DB2, Visual Studio 2008/2005, XML, XSLT, MS Office and Visual source safe, Requisite Pro, TFS, MS Excel, and MS Visio

Confidential, Philadelphia, PA

SQL Server/SSIS Developer

Responsibilities:

• Created complicated reports like parameter based reports, graphical reports, well-formatted reports, drill-down reports, matrix reports, Sub reports, chart and tabular using SSRS.
• Used agile methods for development and implementation and maintained the back tracking.
• Configured Integration on Share Point Server 2010 and Proxy settings for activating reporting services.
• Create a Report Server Database and deployed the generated reports using SharePoint 2010.
• Worked with various SSIS packages which involve Transactions and roll back techniques.
• Involved in setup and configuration of CDC to extract rows that have been inserted, updated, or deleted via T-SQL queries.
• Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
• Responsible for rebuilding the indexes and tables as part of performance tuning.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Optimized queries using SQL Profiler and Database engine tuning advisor.
• Involved in UML Modeling and Context diagrams, Data Flow (DFD) diagrams, including Entity-Relationship Diagrams (ERD) and Sequence Diagrams.

Environment: SQL Server 2012, 2008 R 2/2008/2005/2000 , SSRS 2008 R2/2008, SSIS 2008, Netezza, C#, ASP.NET, DB2, Oracle 9i/10g, Visual Studio 2005, XML, XSLT, Share Point 2010, MS Office and Visual source safe

Confidential, Santa Clara, CA

SQL Server/MS BI Developer

Responsibilities:

• Designed new dynamic SSIS Packages and loaded data into Teradata and tuned the existing packages.
• Deployed SSIS package involving complex Transformations like Slowly Changing Dimension, Merge, Merge joining, Pivot, Unpivot.
• Worked on SSAS, developed Cubes, deployed Cubes on the server, pulled data from various Data sources and thus developed Cubes.
• Designed STAR, SNOW FLAKE Schemas. Worked on database modeling, logical and physical database design using Erwin.
• Involved in Analyzing, designing, building & testing of OLAP cubes with SSAS 2008 using MDX.
• Created various Dimensional Hierarchies, KPI’s, Measures and calculations as part of cube design.
• Designed aggregations using aggregation wizard.
• Part of Relational Data Warehouse Designs and effectively identified and created Facts and Dimensions tables.
• Created Time Dimensions on OLAP Cubes using SSAS.
• Worked with Managers and Management to design customised Reports to view OLAP cube Data.
• Configured the analysis server and reporting server for SharePoint Integrated Mode.
• Built Complex Stored Procedures for writing SSIS Package Logs into Physical Database.
• Took part in the normalization and de-normalization of database.
• Worked with team in developing interfaces using C#, ASP.NET.

Environment: SQL Server 2000/2005/2008 , Analysis Services(SSAS), Reporting Services (SSRS), Integration Services (SSIS), DTS, Oracle 9i/8i, C#, Erwin, SharePoint 2007, Visual Studio 2005, Windows NT, MS Office, Team Foundation Server

Confidential

SQL DBA/SSIS Developer

Responsibilities:

• Merged Data from Heterogeneous Data sources (Oracle, Access and Excel) to SQL Server 2005 using SSIS packages.
• Participated in to Design ETL architecture and processes insurance and policies related record from different locations.
• Implemented the Indexing making the Transaction in SQL 2005 faster nearly three times as compared to the SQL Server 2000.
• Experienced into Tested, Cleaned and Standardized Data meeting the business standards using exact lookups and imported XML data file and put into the desired database.

Environment: SQL Server 2000/2005, SSIS, SSRS, DB2, ASP, ODBC, VBScript, Windows 2000/XP, IIS 5.

Confidential

MS SQL DBA/Developer

Responsibilities:

• Developed stored procedures, triggers, views and adding/changing tables for data load, transformation and data extraction.
• Actively involved in analyzing the old database system and mapping tables, relationships, columns to SQL Server 2005 and Wrote complex stored procedures and balanced the processing load between front end and back end.

Environment: SQL Server 2005, IIS 5.0, UML, ODBC, RDO