SUMMARY

• 10 + years of experience on the design, construction and implementation of Business Intelligence tools, ETL Process (Data Extraction, Transformation layer) with DTS/SSIS, Data Validation, MSSQL Databases.
• Proficient in using Confidential - SQL, writing Stored Procedures, Triggers, Functions, and Cursors inSQL Server.
• Good experience using various transforms inSSISas an ETL tool while transferring the data from various sources into the destination files.
• Extensive experience in creating complexSSISpackages for ETL purposes using various transformations inSSIS2005,SSIS2008R2, 2012 and 2014.
• Transformed data from various data sources toSQL Serverusing DTS, SSIS and Pentaho Kettle.
• Clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Proven ability in defining query for generating drill down reports, matrix reports, chart reports and handling parameterized reports, creating on demand and scheduled reports inSSRS2005,SSRS2008 and SSRS 2012.
• Worked with BIML to automatically generate SSIS packages.
• Experience in performance tuning, error handling and optimization of queries and stored procedures.
• Experience in all phases of project life cycle, starting from business requirement gathering and analysis to testing and deployment.
• Proficient in using SQL Profiler, Execution Plan and Performance Monitor.
• Skilled in performing Backups and Recovery, Replication, Security management, Jobs and working with Linked Servers.
• Mastered creating the OLAP cubes using various dimensions and creating SSAS projects usingSSAS2008R2.
• Adept in defining referenced relationships and calculated members inSSASand used MDX queries, creating OLAP structures from OLTP databases.
• Experience in designing, maintaining & tuning various RDBMS like Confidential -SQL &SQL Server 2014/ /2005/2000 .
• Hands-on experience with Erwin and strong knowledge of relational database modeling and dimensional database modeling concepts, fact tables, dimensions and star/snowflake schemas implementation.
• Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Involved in DBA activities such as backups, restores, replication etc.
• Excellent communication skills, analytical skills, understand business requirements in various domains.

TECHNICAL SKILLS

Database: SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000, Oracle 9i/10g, IBM DB2 V9.7, Teradata.

Operating Systems: Windows 2008/2007/XP/2000/2003.

Programming Languages: SQL, Confidential -SQL, VB.Net, C#

BI Suite: SSAS, SSRSETL TOOLS DTS, SSIS, Pentaho Data Integration

Data modeler: Erwin 4.0/4.1/4.2/7.2

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

SQL Server Developer

Responsibilities:

• Working with FICO Debt Manager for maximizing returns, controlling costs, and delivering strong consumers.
• Extracting the data using SSIS. Wrote data validation stored procedures and executed them in SSIS packages.
• Working on a SSIS framework that will maintain the logs, error handling, notifications, and restart ability.
• Working with BIML to automatically generate SSIS packages. Effectively applied code reuse, templates and patterns in ETL solutions.
• Working with ZappySys web API integration task to send Ad-hoc web requests to DM and save response in SSIS variable.
• Created script tasks to make rest API calls to the DM application using C#.
• Have created a data scramble framework to hide sensitive data in DEV and QA databases by replacing it with valid and relevant false data.
• Working on an enterprise product DDM (Dynamic Data Mapper) to reuse the same mapping logic for different data sources, develop a dynamic mapping that can run against different sources and write the mapping output to different targets. The DDM supports Excel, CSV and fixed length flat files.
• Working on migrating ETL packages from Pentaho Data Integration to SSIS.
• Built quality checks orchestration for business data to meet the requirements and load into database.
• Wrote SSIS package to load data into XML and Excel.

Environment: SQL Server 2016/2014, FICO DM9, FICO DM10, Confidential -SQL, SSIS, Windows Server 2010, Visual Studio 2012, Pentaho Data Integration, ZappySys, C#, QlikView 12.10, GIT, VSTS, BIML.

Confidential, Frisco, TX

SQL Server Developer

Responsibilities:

• Responsible for modifying existing ETL process.
• Participated in implementing automated system to receive data feeds from Accordant Care Management System into Specialty.
• Providing technical support for Specialty and Accordant programs.
• Gathering requirements, estimate and work on large initiatives.
• Involving in create and review the project designs.
• Creating stored procedures to generate the client reports.
• Identify the database objects for the migration of existing application.
• Implemented different methods to retrieve the object dependencies.
• Applied best practices on stored procedures to achieve consistent implementation of business logic and improve performance.
• Implemented best practices for SSIS packages including taking advantage of configuration capabilities, validation setting and etc...
• Generated Tablix and chart reports based on the user requirements.

Environment: SQL Server 2008R2 Enterprise Edition, Confidential -SQL, Windows Server 2008, Visual Studio 2010, TFS, SSIS, SSRS.

Confidential, Boston, MA

Technical Consultant (SQL Developer)

Responsibilities:

• Acted as the primary point of contact with the customer and participate in project-based product implementations Confidential the customer’s location.
• Installed and configured OneSumX FS product on SQL server 2012 edition.
• Worked with SSDT to perform ETL operations such as loading and scrubbing data from source systems into OneSumX’s environment.
• Intensively worked on complex stored procedures and implementing best practices for better performance.
• Created Table, Matrix, and Parameterized reports using SSRS.
• Worked on Report Manager to administer reports. Configured role based security, report execution properties.
• Expertise in creating Drill through, sub report, and hyperlink reports in SSRS.
• Analyzed existing SSRS reports and made recommendations based on business requirements.
• Assist the customer in defining and analyzing requirements, translating requirements into functional specifications, testing and then implementing OneSumX solutions.
• Continually monitor & evaluate projects and provide ongoing project status reporting.
• Installed and configured OneSumX components Maestro and Task Runner.
• Responsible for the quality of the functional part of the implementation, including oversight of the implementation work performed by other members of the project team.
• Provided ongoing input to the assigned project manager regarding all project related items such as planning, progress, deliverables, risk & issues.
• Integral part of highly skilled technical team which continuously assist the clients on OneSumX products and SQL database related issues.
• Used Jira to track the status of tickets.
• Participate in status meetings and report on project progress.
• Building functional expertise through specialized workshops on regulatory reporting, banking and financial products.

Environment: SQL Server 2012 Enterprise Edition, Confidential -SQL, Windows Server 2008, SQL Server Data Tools (SSDT), Visual Studio 2012/2010, C#, OneSumX 2.0, Maestro, Task Runner, OneSumX Parameter Handler, Tortoise SVN.

Confidential, Atlanta, GA

SQL BI Developer/DBA

Responsibilities:

• DeployedSQL server 2012by upgrading existing instances of SQL Server 2008 R2 using installation wizard.
• Migrated SSIS packages from SQL server 2008 R2 to 2012.
• Assisted with the migration of MS SQL Server 2005 back-end single server environment (Development/Production) to a new MS SQL Server 2008 back-end multi-server failover environment (Development vs. Production).
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.
• Designed and developed packages using Business Intelligence Development Studio (BIDS) and Visual studio 2010, and 2012.
• Extracted data from databases like Oracle, Teradata, Sybase and MySQL and migrated into SQL server using SSIS.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Involved in installation and configuration of SQL Server 2008.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Wrote VB.NET code in script components in SSIS to validate the Data from Data base sources.
• Created the SSIS /DTS packages and scheduled them.
• 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.
• Imported data from text files and excel spread sheets into SQL Server 2005 database using SSIS package.
• Worked with Pragmatic works DTS xChange tool to convert DTS packages to SSIS 2005.
• Experienced in Replication as a Disaster Recovery Solution and Load balancing.
• Immediately following the server cut-over, perform additional database performance tuning and database support.
• Monitoring success and failure of automated jobs, monitoring system availability, updating system documentation, system and database recovery, etc.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using Confidential -SQL in Development and Production environment for SQL Server 2005.
• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Environment: SQL Server 2005/2008R2/2012 Enterprise Edition, SSIS, Confidential -SQL, Windows Server 2008, VB.Net, Microsoft Business Intelligence Studio, VB.net, C#, Visual Studio 2012/2010, DTS xChange, SQL Profiler, Database Engine Tuning Advisor.

Confidential, Roanoke, VA

SQL BI Developer

Responsibilities:

• Assisted with development of the new CTMS-NG application.
• Worked closely with the project leads, project business analysts, project data modeler, and other NS personnel to process data requirements into target databases.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Data pulled from different sources such as CSV files, Text files, Excel Spreadsheets, DB2, SQL server and Teradata.
• Updated CTMS-NG database regularly with the legacy CTMS database and other databases based on business requirements.
• Built several detailed and summary reports including pie charts, table, matrix, sub-reports and trend analysis reports based on business requirements using SSRS.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Database.
• Created SSIS packages to load data into database using various SSIS Tasks like Execute SQL Task to perform SQL statements and to return result sets to be useful for other SSIS components, Data Profiler Task to ensure the data being imported is valid, Bulk Insert Task, Data Flow Task, File System Task, For Loop and for Each Loop Container.
• Created new SSIS packages to migrate the data from legacy system using Business Intelligence Development Studio (BIDS) and Visual Studio 2010.
• Created Data Flow Tasks with Merge Joins to get data from multiple sources from multiple servers, with Look Ups to access and retrieve data from a secondary dataset, with Row Count to have the statistics of rows inserted and updated, and worked with Script Task to perform a custom code.
• Worked with Package Variables, with Event Handlers to react to the appropriate error conditions, with SSIS Parallelism, with Package properties to make package more proficient.
• Created complete documentation using Pragmatic Works BI Documenter for both Control Flow and Data Flow Task components and transformations such as properties, input columns, and output columns.
• Increased the performance by performance monitoring, tuning and optimizing indexes.
• Created and monitored scheduled jobs on DEV, QA, and Production servers. Created alerts for successful or unsuccessful completion of Scheduled Jobs.
• Deployed SSIS Package into Production and used Package configuration to export package properties.
• Actively participated in interaction with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Worked closely with DBAs to improve the database performance by applying enough indexes, triggers, and MQTs.
• Worked with Stored Procedures, User Defined Functions, Views, SQL Scripting for complex business logic.

Environment: SQL server 2008R2 RTM edition, Microsoft Visual Studio 2010, IBM DB2 v9.7 for Windows, IBM Data Studio for DB2, SSIS, SSRS, VB.Net, Passport, Pragmatic Works BI Documenter.

Confidential, Austin, TX

SQL BI Developer

Responsibilities:

• Installation and configuration of SQL Server 2008.
• Experience in creating Table Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services 2008.
• Experience in creating ad-hoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Involved in Migration of SSRS 2005 to SSRS 2008.
• Built the SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2005 and adding calculations using MDX.
• Worked in Data modeling, creating star and snowflake schemas in SSAS. Also used tools like Erwin.
• Experience in Programming AMO OLAP advanced objects like KPI’s and Perspectives.
• Experience in using XMLA protocol for SQL Server Analysis Services 2005 for interaction between client application and instance of Analysis Services.
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2005/2008.
• Experience in writing MDX queries for cubes and Performance optimization of MDX queries.
• Regular responsibilities for updating and staging the dimensional databases as well as rebuild the Dimensions and cubes in Analysis Services.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including DEV, INT, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Wrote C#.NET code in script components in SSIS to validate the Data from Data base sources.
• Created the SSIS /DTS packages and scheduled them.
• Built applications using ASP.Net.
• Imported data from text files and excel spread sheets into SQL Server 2008 database using SSIS package.
• Used Performance Point Server to create interactive reports with an ability to drill down into details.
• Experience in Planning and Monitoring reports in Performance Point Server.
• Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema and database objects.
• Coordinate in the execution of data validation programs.
• Experienced in connecting to database components using C#, VB.NET for Data Access
• Worked with Confidential -SQL to create Tables, Views, and triggers and stored Procedures.

Environment: SQL Server 2005/2008 Enterprise Edition, SSAS, SSIS, Confidential -SQL, SSRS, Visual Studio 2008, Windows Server 2003, C#, ASP.Net, Oracle 9i, Hyperion 11.1, Performance Point Server 2007.

Confidential

Software Engineer

Responsibilities:

• Developing Confidential -SQL queries, triggers, functions, cursors and stored procedures.
• Responsible for logical and physical design of SQL Server databases.
• Alter the schema for the required objects.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Created views to restrict access to data in a table for security.
• Expert in extracting data using SSIS from OLTP to OLAP.
• Performed Bulk data migration using DTS and SSIS from flat files.
• Designed and optimized all the SSIS packages.
• Created SSIS packages to Export data from text file to SQL Server Database.
• Designed, Build the Dimensions, Fact Tables, cubes with star schema using SQL Server Analysis Services (SSAS).
• Designed and implemented stylish report layouts.
• Identified the Data Source and defining them to build the Data Source Views.
• Identified and defined the Datasets for report generation and also included report parameters.
• Involved in integrating Share Point Server with SSRS and deploying SSRS reports on to Share Point Server.
• Generated complex custom Reports using SSRS and Crystal Reporting as per the customer requirement.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created datasets in Confidential -SQL, stored procedures for SSRS.
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Implemented full and differential backups and also created and managed DB objects.
• Make recommendations for File Group Creation and Placement.
• Scheduling backups and automating weekend maintenance tasks.
• Created users and roles for login authentication and validating permissions.
• Administering MS- SQL Server, performing day-to-day tasks such as Database tuning by checking indexes.
• Upgraded SQL Server 2000 to SQL Server 2005.
• Assisted developers in tuning Stored Procedures, Triggers and Functions over performance issues.

Environment: SQL Server 2005/2000, Confidential -SQL, SSIS, SSRS, SSAS, DB Artisan, Management Studio, Query Analyzer, Windows 2003/2000 Server, Visual Studio, Oracle 9i