SUMMARY:

• 8+ Years of Professional experience in the IT industry as a MS SQL Server Developer using Microsoft SQL server 2014/ 2012/2008R2/2005/2000 in various domains including Health care, Real estate and insurance.
• Ability to deliver comprehensive Business Intelligence through integration of BI suite of products (SSIS, SSAS, SSRS) including MS solutions like MS EXCEL 2007/2010, Microsoft Office.
• Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation.
• Expert in RDBMS concepts, Data warehousing concepts, OLTP & OLAP.
• Strong Experience in various Extracting, Transforming and Loading ETL/SSIS data flow ETL/SSIS using SSIS.
• Expert in Creating ETL Package to Export / Import the data using REST/SOAP API by creating global Libraries.
• Excellent in writing T - SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration, also created Indexed Views, complex Stored Procedures, Triggers, effective functions to facilitate efficient data manipulation and data consistency.
• Highly Proficient in T-SQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts.
• Skilled in creating virtualization reports using Power BI
• Good SQL Server Administration skills including, Backups, Restore, database maintenance, user authorizations and Database creation.
• Experience in using tools like Database engine tuning advisor, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Advanced extensible reporting skills using SQL Server reporting services (SSRS). Created & formatted Cross-Tab, Conditional, Drill-down, Top N, Summary, Form OLAP, Sub reports, ad-hoc reports, parameterized reports, interactive reports & custom reports.
• Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environments.
• Good experience in using tools such as SQL Profiler, Index tuning, Windows Performance for monitoring and tuning MS SQL Server performance.
• Experience in deploying reports on SharePoint Server using SharePoint Integrated Mode.
• Responsible for maintaining the efficiency of all the software and applications that run on the UNIX system.
• Intensively working for graphic design Database backend programming in C# for dynamically generating components in the front Database. Working knowledge with HTML.
• Having experience implementation and execution of Software methodologies, such as Waterfall and Agile and in Agile both Kanban production support and Scrum Development.
• Worked with GitHub, TFS for source code management.
• Having excellent communication skills, analytical skills, understanding of business requirements in various domains.

TECHNICAL SKILLS:

• MS SQL Server 2005/2008/2012/2014/2016
• MS SQL Reporting Services 2005/08/12/13
• MS SQL Server Analysis Services 2005/08/12/13
• MS SQL Server Integration Services 2008/12/13/15
• Informatica Power Center
• Teradata Erwin Designer
• .NET Framework 2.0
• Visual Studio
• Windows NT
• Windows 2000 Server
• Windows XP
• Unix
• Shell script
• UNIX
• HTML
• DHTML
• MS-Access
• Developer 2000
• TFS
• GitHub
• MS-Office
• VBA.

PROFESSIONAL EXPERIENCE

Confidential, Irvine, CA

Sr. ETL MSBI / SQL Server Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Provided information and assistance to the Database Architects on physical models, and the setup and maintenance of metadata.
• Wrote user requirement documents based on functional specification.
• Designed and developed SSIS packages using stored procedures, configuration files, tables, views, and functions and implemented best practices to maintain optimal performance.
• Involved to work with building a new platform with the use of SSIS.
• Responsible for creating the reports based on the requirements using SSRS 2015.
• Involved in writing Query for generating drill down reports, identified and worked with the parameters to generate parameterized reports along with that extensively used global variables, expressions and functions.
• Analyze, design, construct and implement the ETL Process using Dell Boomi.
• Integrate different systems like salesforce, RealPage, pivotal etc. using Dell Boomi connection with OAuth2, regular connect types.
• Implement of custom logging information with the using execute SQL task for SSIS packages.
• Worked on Change Data capture for capturing different events like insert, update and delete activities for SQL Server tables.
• Working with .NET framework and C# with the using Visual Studio.
• Troubleshooting and resolving production issues by replicating them into lower environments.
• Collaborating with both the technical and business team members to identify and prioritize the user stories and tasks.
• Gather requirements and Creating and maintaining accurate and complete documentation for functional, technical and test cases etc. for all data analysis and data flow processes.

Project Environment: MS SQL Server 2012, MS SSRS/SSIS 2015/2013/2012, T-SQL, Teradata Visual studio 2015/2013, C#, Dell Boomi, .NET Framework, CDC.

Confidential, Redlands, CA

Sr. ETL MSBI / SQL Server Developer

Responsibilities:

• Involved and hands on development in every phase of the project right from Requirements Analysis, Scoping, Designing, developing (SSIS, SSRS) Debugging, Testing and Documentation, deployment and UAT.
• Developed SSIS Packages to transfer data between servers, load data into database, archive data files from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2012/2014. environment and deploy the data. Used Event Handlers for Exception Handling in SSIS packages.
• 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 Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimensions.
• Developed C# Libraries to get the data from external sources using REST/SOAP API and developed a Complex Script task to load into the database by using global libraries.
• Based on business requirements, developed the Complex SQL queries with Joins and T-SQL, Cursors, User Defined Functions, Stored procedure, Views, Trigger to implement the business rules and transformations.
• Implemented several reports such as drill down reports, parameterized reports, linked reports, sub reports, Matrix Reports and Chart reports using SQL Server, Teradata Reporting Services sourcing from the Data Warehouse and OLAP Cubes.
• Provide Dynamic Parameter reports for different business criteria. Generated periodic reports based on the statistical analysis of the data from various time frames and divisions using SQL Server Reporting Services (SSRS).
• Responsible for implementation of Data viewers, SSIS Logging, Error configurations for Error handling, Try Catch Blocks in the packages.
• Responsible for cleaning the data and maintaining the accuracy and quality of the data load from the different Source into the database objects, And Created linked servers for data retrieval using OLEDB data source and providers.
• Experienced in creating jobs Alerts, Alerts, SQL Mail Agent, and Scheduling SSIS Packages using SQL Server Agent job and JAMS Scheduler.
• Scheduled Jobs for executing the stored SSIS/SSRS packages which were developed to update the database on Daily basis and generating reports using SQL Server Agent and JAMS Scheduler.
• Troubleshooting successful production issues by replicating them in the UAT environment and working on different kinds of data like timecard, Customer Support, Professional Services etc.
• Involved in creating technical documentations, deployment documentations, and approving test cases.

Project Environment: MS SQL Server 2016/2014/2012, MS SSRS/SSIS 2015/2013/2012, T-SQL, Visual studio 2015/2013, C#, TFS 2013, GitHub, Erwin 8.0, JAMS 6.5

Confidential, Minneapolis, MN

Sr. ETL MSBI / SQL Server Developer

Responsibilities:

• Involved in gathering requirements, worked closely with business users and implemented logical and physical modeling using Erwin.
• Developed various T-SQL stored procedures, views, and adding/changing tables for data load and transformation, and data extraction.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, and UDFs.
• Created complex queries involving CTE’s, Subqueries and Joins.
• Created Indexes for fast retrieval of the data. Involved in Performance tuning and Query Optimization using execution plan.
• Created a new database/tables to put in the extracted data and rebuild the relationship.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2014 from different environments for the SSAS cubes.
• Created the SSIS /DTS packages and scheduled them using Sql Server agent.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Utilized event handling effectively to generate audits and logs for the generated SSIS packages.
• Performed archiving and achieved automated processing of the raw data through the ETL process in SSIS.
• Deployed SSIS Packages from Dev/Staging/Production using Package Configurations.
• Created reports as per user requirement using SQL Server reporting services (SSRS) which delivers enterprise and Web-enabled reports.
• Developed drill-through and drill-down reports using SSRS. Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Created snapshots of reports to reduce the load on the server using SSRS 2012.
• Created Dashboards and other virtualization reports using Power BI.
• Performed Identification, analysis and resolved report defects within time scope and established development guidelines.

Project Environment: MS SQL Server 2014/2012, Power Pivot, Teradata Power BI, TFS 2013, MS SSRS/SSIS 2012, T-SQL, Visual studio 2013, Erwin 8.0

Confidential, Kansas City, MO

Sr. ETL MSBI / SQL Server Developer

Responsibilities:

• Responsible for managing BI environment, which includes Business model, Data Model, Data sources, ETL/SSIS tools, target data warehouse, Data marts, and Reporting tools.
• Design and tune ETL process. Working closely with the Guidewire team on business aspects.
• Creating a large number of stored procedures and creating parameterized SSIS Packages to move data from different sources to target. Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Configured files to deploy the SSIS packages across all environments.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Implemented Functions, views, triggers, stored procedures and enforced business rules via checks and constraints. Performed Replication, Backup compression for individual tables and indexes and reducing the disk usage and I/O resources.
• Used SSRS to create reports, customized Reports, on-demand reports, and involved in analyzing multi-dimensional reports in SSRS.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS. Configured and maintained Report Manager and Report Server for SSRS.
• Creating ad hoc queries according to business need and tuning existing queries to meet business standards.

Project Environment: MS SQL Server 2008/2012, Red Gate tools, PowerPivot, TFS 2013, MS SSRS/SSIS 2012, T-SQL, Visual studio 2013, Teradata, MS Visio

Confidential, Portland, OR

MS SQL BI Developer / ETL Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Worked on Kimball methodology for integration of data marts to build an EDW.
• Involved in designing the process flow for extracting the data across various source systems.
• Designing, developing, implementing, maintaining SQL components - stored procedures, ETL packages, SQL scripts, Teradata, etc.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Developed SSAS Cubes in multidimensional servers.
• Created Running SQL script to verify/validate data by using C#.
• Used various SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Used ETL to implement the slowly Changing Transformation, to maintain Historical Data in the Data warehouse.
• Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.
• Created SSAS Cube MDX calculations utilizing functions optimized for block-mode computations
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created Views to reduce database complexities for the end users.
• Used SQL Profiler for creating traces by which a suggestion for the query is analyzed by SQL query analyzer.
• Migrated data between databases using SSIS.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2008R2.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Performed Documentation for all kinds of stored procedures and SSIS packages.
• Involved in database performance and maintenance duties such as Tuning.

Environment: MS SQL Server 2012, SQL Server 2008R2, SQL Profiler, Data Analyzer, Visual Studio 2012/2008, MS SSIS, SSAS, SSRS 2012/2008, DTS, Erwin Designer 2000, ASP.NET, C#, DB2 SQL syntax, MS-Access 2000.

Confidential, Des Plaines, IL

MS SQL BI Developer/SSAS/ SSIS/SSRS Developer

Responsibilities:

• Collaborating with both the technical and business team members to identify and prioritize application database requirements.
• Analysis of the database structure, schema, tables and various data load and data transfer processes as part of a database re-architecture project.
• Creating SQL Scripts to extract required data from various tables for the purpose of data analysis of various data sources.
• Creating complex data flow diagrams to demonstrate and record various process flows involved in the system. These data flow diagrams were used as reference for data migration.
• Designing, developing, implementing, maintaining SQL components - stored procedures, ETL packages, SQL scripts, etc.
• Designed and developed SSAS databases with multiple cubes, corresponding to each subject area.
• Creating complex Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Designed, created and deployed parameterized and ad-hoc reports into the production server using Report builder, for the brokers and clients.
• Optimized SSAS databases for fast data processing and querying.
• Generating ad-hoc reports, Sub reports, tabular reports using MS-Access and SSRS.
• Assisting in defining the interaction between application packages, databases, and middleware systems in terms of functional coverage.
• Conduct code walkthroughs and review peer code and documentation.
• Created a system for capturing, reporting, and correcting error data.
• Provide on-call support to the production system to resolve any issues.
• Gather requirements and design of data warehouse and data mart entities.
• Creating and maintaining accurate and complete documentation for all data analysis and data flow processes.
• Conduct and assist in design and code reviews.
• Conduct and assist in unit and integration testing.

Environment: Oracle PL/SQL Developer 10.0.1, MS SQL Server2008R2, SQL Server 2012, Query Analyzer, SQL Profiler, Report Builder, Data Analyzer, Visual Studio 2005/2008, MS SSRS and SSIS 2005/2008, DTS, Erwin Designer 2000, DB2 SQL syntax.