PROFESSIONAL SUMMARY:

• 10+ years of strong IT experience in Database Design, Development, ETL and business intelligence with various business domains like Banking, Insurance and Health care.
• Exceptional hands on working knowledge with ETL Tools SQL Server Integration Services (SSIS), Pentaho Data Integration, Talend Data Integration, IBM Web Sphere Data stage and Quality Stage
• Exceptional hands on working knowledge with Reporting Tools SQL Server Reporting Services (SSRS), Pentaho Report Designer, Looker 4.20
• Expertise in creation and deployment of dimensions, partitions, aggregation and cubes on SSAS.
• Worked on predefined, developed stored procedures for automation and scheduling in crystal reports.
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, and drill down reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Expertise in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using SSIS.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Expertise in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using DTS and SSIS services.

TECHNICAL SKILLS:

Data Modeling: Data modeling experience using Dimensional Data modeling, Star Schema, Snow - Flake Schema, FACT and Dimension tables, Physical and logical data modeling, Erwin 4.1.4

Databases: Oracle, PostgreSQL, MS-Access, DB2, MS SQL Server, Teradata, MySQL, and Sybase.

Programming: SQL, T-SQL, PL/SQL, Unix Shell Scripting, LookML and exposure to SAS, JAVA, and PERL.

Domain Knowledge: Banking, Insurance, Healthcare, Spend Data Analysis, Sales and Warranty AnalysisManufacturing and Education

Environment: Windows 98/NT/XP, Windows 7 Professional, UNIX (AIX), and Linux.

Miscellaneous: MS Office, Visio, Hyperion, Toad, Control M, and exposure to Congo s, Business ObjectsUC4, OBIEE, ODI, Brio, and Tableau

WORK EXPERIENCE:

Confidential, SAN Antonio, TX

ETL/ SSIS/SSRS/ Developer

Responsibilities:

• Created different Dashboards and charts using Power BI that were published the business stake holders for analysis and customization using filters and actions.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created/Updated database objects like tables, views, stored procedures, function, packages.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS.
• Created different views using SSRS that were published the business stake holders for analysis and customization using filters and actions.

Tools: and Technologies: MS SQL Server 2016, SSIS, SSAS, SSRS Oracle11g,OBIEE, Visual Studio 2015, VSS 2005, Erwin 7.3, Power BI, Microsoft .NET framework, C#, ASP.NET, XML.

Confidential, San Antonio TX

ETL/SSIS/SSRS Developer

Responsibilities:

• Wrote complex queries using T-SQL to create joins, sub queries, functions and correlated sub queries to retrieve data from the database.
• Experience in Web-Forms and Win-Forms using ASP.NET, C#. NET, VB.NET with SQL Server.
• Worked on ASP.NET MVC for building RESTful applications on .NET Framework.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created/Updated database objects like tables, views, stored procedures, function, packages.
• Designed MS SSIS Packages to extract data from various OLTP sources to MS SQL Server
• Build efficient SSIS packages for processing fact and dimension tables with complex Transforms and type 1 and type 2 slowly changing dimensions.
• Created mapping tables to find out the missing attributes for the ETL process.
• Created SQL Jobs to schedule SSIS Packages
• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
• Created VB.Net, C# Script for Data Flow and Error Handling using Script component in SSIS.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
• Generated Drill down, Drill through, Matrix Reports, parameterized reports using SSRS.
• Preparing reports using calculated fields, parameters, calculations, groups, sets and hierarchies in SSRS.
• Used Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Migrated reports from SSRS to PowerBI.

Tools: MS SQL Server 2014/2016, SSRS, T-SQL, SSIS, OBIEE, Win 2008 Advanced Server, Erwin v8.0, ASP.Net, C#, MS Access 2010

Confidential, San Antonio TX

SQL /SSIS/SSRS/SSAS Developer

Responsibilities:

• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using For Each Loop Container, Execute Package task, Execute SQL Task, Sent Mail task, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension and more.
• Data Access Classes using the Microsoft Entity Framework when building an ASP.NET MVC application.
• Extract, Transform and Load (ETL) source data into respective target tables to build the required data marts.
• Involved in designing ETL as a part of Data warehousing and loaded data in to Fact tables using SSIS.
• Supported Production Environment with schedule the packages and make the package dynamic with SQL Server Package Configuration.
• Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Developed queries or stored procedures using T-SQL to be used by reports to retrieve information from relational database and data warehouse
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images and Maps.
• Create Common Table expressions (CTE) and temp tables to facilitate the complex the queries
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
• Developed Query for generating drill down and drill through reports in SSRS.
• Designed new reports and wrote technical documentation, gathered requirements, analyzed data, developed and built SSRS reports and dashboard.
• Developed SQL queries or stored procedures used by reports to retrieve information from relational database and data warehouse.

Tools: and Technologies: Microsoft SQL Server 2012, T-SQL, SQL SSIS, SSAS, SSRS, SQL Profiler,OBIEE, Visual Studio 2008, Visual Intercept Enterprise Edition, Oracle 10g, VB.Net

Confidential, Houston, TX

SSIS Developer

Responsibilities:

• Wrote queries using T-SQL to create joins, sub queries and correlated sub queries to retrieve data from the database.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created/Updated database objects like tables, views, stored procedures, function, packages.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete.
• Involved in table and index partitioning for performance and manageability.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Created different views using SSRS that were published the business stake holders for analysis and customization using filters and actions.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting on future projections.
• Helped create process logging and new monitoring tools, integrity reports, and mapping tools.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.

Tools: and Technologies: MS SQL Server 2012, SSIS, SSAS, SSRS Oracle11g, Visual Studio 2008, VSS 2005, Erwin 7.3, Windows NT/2003, Microsoft .NET framework 3.5, C#, ASP.NET, XML.

Confidential, San Francisco, CA

ETL SSIS Developer

Responsibilities:

• Involved in the Installation and Configuration of SQL SERVER 2008 with latest service packs.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as 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 SSIS packages.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins, Temp tables for applications.
• Created and modified various Stored Procedures used in the application using T-SQL.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Used various Data Flow Transformations like Lookup, Lookup Plus, Union All, Multicast, Cache Transform, and Conditional Split while developing the packages.
• Developed SSIS Packages using Look Up Values & implementing rules provided by Business in the mapping document.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes using the TF Dimension Merge Slowly Changing Dimension (Task Factory Tool).
• Identified the potential Issues that occur during the package execution by redirecting the rows from source component to Error Output by TF Error Output Description (Task Factory Tool).
• Identifying the mapping issues and discussing them with business analysts in team.
• Handled the database components (Code migration, Change control) for application releases.
• Developed the packages with monitoring features and logging so that information of the packages and their execution results are loaded into the designed error table.

Environment: SQL Server 2008/2005, Windows Server 2003, SSIS, SSAS, SSRS and TFS, ProClarity/PPS, Confidential, ODS

Confidential, Boston, MA

ETL Developer

Responsibilities:

• Involved in complete SDLC life cycle.
• Extract, Transform and Load source data into respective target tables to build the required data marts.
• Understand user requirements and Data Model defined and developed by the business analysts and data architects.
• Performed DBA tasks like Backup, restore of tables and Stored Procedures and Refreshing Database on weekly basis.
• Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Implemented different types of constraints on tables.
• Designed and applied entity and attributes description and definition for the models.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Worked on different sources in SSIS (XML, Flat file, Excel, OLEDB Source).
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Responsible for gathering business requirements to create business user reports.
• Developed optimal stored procedures and queries to create data sets for reports.
• Created SSRS Reports on the top of the cube using some MDX queries.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Migrating COGNOS reports to SSRS.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Developed SSAS Cubes, partitions, aggregation from scratch with Star Schema.
• Performed unit and system testing, troubleshooting and bug fixing in Prod and QA environments.

Environment: Windows Server 2003, SQL Server 2008/2005, SSIS, SSAS, SSRS, ProClarity/PPS, Confidential, ODS

Confidential, Boston, MA

SQL Server Developer

Responsibilities:

• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
• Created SSIS process design architecting the flow of data from various sources to target.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases and process SSAS cubes to store data to OLAP databases.
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Created ETL SSIS packages both design and code to process data to target databases.
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
• Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
• Used Notification services to generate error messages and send them to the user through e-mails, pager messages, and PDA as well as window messengers.
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.

Environment: Windows Server 2003, SQL Server 2008/2005, SSIS, SSAS, SSRS, ProClarity/PPS, Confidential, ODS.

Confidential

Jr. SQL Server/ETL Developer

Responsibilities:

• Installation of MS SQL enterprise servers on test and development boxes.
• Designed and Created databases, tables, views, stored procedures and triggers.
• Created groups, roles, users and assigning access privileges to users.
• Database and Log Backups & Restoration, Backup Strategies, Scheduling Backups. Backing up master & system databases and restoring them when necessary.
• Monitored and scheduled existing/new jobs on production environment.
• Optimizing Database Queries for performance enhancements and Writing T-SQL Views and triggers.
• Worked to tune the SQL queries using SQL Profiler.
• Tested backup and recovery strategies in a test environment before and after moved to production environment.
• Created new stored procedures and modifying existing ones.
• Migrated data from SAS environment to SQL Server 2005 with SQL Server Integrated Services (SSIS).
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2005.
• Developed optimal stored procedures and queries to create data sets for reports.
• Designed and implemented stylish report layouts.
• Generated Reports using Global Variables, Expressions and Functions for the reports.

Environment: Windows Server 2003, SQL Server 2005, BI studio 2005, SSIS, SSAS, SSRS, Microsoft windows XP