SUMMARY

• Over 7+ years IT experience in Reporting Services, Integration Services and as MS SQL Server SSRS/SSIS Developer 2017/ 2016/2014/2012 /2008 and as an Oracle PL/SQL Developer.
• Experience in Physical and logical Database Design in different domains with expertise in MS SQL Server 2017/ 2016/2014/2012 /2008 and Microsoft's suite of products like SSIS and SSRS.
• Experience in migration of Data from Excel, Flat file, Oracle9i/10i to MS SQL Server by using SSIS, BCP and DTS utility. Extracting, Transforming and loading of data using SSIS and DTS.
• Experience in designing SSIS Packages to extract data from various data sources such as Oracle, SQL Server, Access database, Excel spreadsheet, xml files and flat files into SQL Server for further Data Analysis and Reporting. Good understanding and experience in Change Data Capture ( CDC ).
• Expert in development, implementation, administration and support of ETL processes for Data Warehouses using Data Transformation Services (DTS) and SSIS with MS SQL.
• Proficient in creating On - demand and Scheduled reports, handling sub reports and defining query for generating drill down reports using MS SQL Server Reporting Services (SSRS).
• Proficient in creating sub reports and defining query for generating drill down reports using SSRS and Experienced in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
• Expert in creating and developing Power BI Dashboards into rich look and tested Power BI reports of Database and verified it with the source data.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Strong experience in Data warehouse concepts, ETL and Good understanding of data modeling, processing and warehousing techniques
• Good knowledge on logical and physical Data Modeling using normalizing Techniques.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Expert in providing database maintenance for MS SQL Server 2008/2012/2014 database.
• Experience working in Agile and Waterfall model working methodologies.
• Strong analytical and problem-solving skills coupled with excellent written, verbal and inter-personnel communication skills.

TECHNICAL SKILLS

SQL Server Tools: SSMS, SQL Enterprise Manager, DTS, Profiler, DTA

ETL & Reporting Tools: SSIS, SSRS, BIDS, DTS, Business Objects, Power BI, Informatica

Databases: SQL Server 2005/2008/2008 R 2/2012/2014/2016 , Oracle 10/11g, MS Access

Programming Languages: SQL, T-SQL, PL/SQL

Scripting: JavaScript, VB.NET

Other Tools: Report Builder

Operating System: Windows XP/ 2003/2007/2010 , Windows Server 2008 R2, Windows Server 2012

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, TX

MS SQL Server SSIS/SSRS Developer

Responsibilities:

• Designed packages using Lookup Transformations, Merge Joins and Derived Columns with Multiple Data Flow Tasks.
• Used different type of Transformations for Data Conversion, Sorting and cleaning the data from different sources into Company format.
• Deployed packages to SQL Server and file system in 2014 and also used the new Project based Deployment introduced in SQL Server Data Tools (SSDT) to deploy the 2016 packages.
• Created Package Configurations, Event Handlers for On Error/Warning/Task Events.
• Automated SSIS Packages using SQL Server Agent Jobs and Windows Scheduler.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Involved in Monitoring and troubleshooting complex packages by using Data Viewers Grids.
• Performance Tuning the Stored Procedures used in SSIS Packages and SSRS Reports.
• Worked with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Involved in Creating Complex Ad- Hoc reports, Sub reports, Linked reports, Charts, Drill Through, and Report Models Drill Down Reports.
• Prepare documentation related to database design, objects security and rules.
• Used SQL Profiler and Execution Plan to view index performance and thereby eliminate table scan.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Experience of creating PL/SQL Packages, Procedures, Functions, Triggers, Views and Exception handling for retrieving, manipulating, checking and migrating complex data sets in Oracle.
• Expertise in creating the indexes on tables and partitioning the table for SQL tuning purpose.
• Expertise in writing procedures, functions, views, materialized views as required.
• Responsible for performance tuning activities in the project.
• Ability to write complex SQL queries for reporting purpose.
• Customizing the application using PL SQL techniques.
• Support the users of application with using multiple SQL and PL SQL techniques.

Environment: MS SQL Server 2017/2016/14/12 , SSIS, SSRS, DB2, Oracle 11g, ETL, MS Access, HTML, Windows XP.

Confidential, Overland Park, KS

MS SQL Server SSIS/SSRS Developer

Responsibilities:

• Designed and created SSIS packages to extract, transform and load data from Excel and Text to SQL Server destination using various complicated transformations like conditional split, derived column, and data conversion for fee schedules from the existing QNTX database.
• Modified the existing packages by making changes in the stored procedures according to the requirement.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
• Implemented data mart, facts, dimensions, snowflake schema.
• Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report services (SSRS).
• Used various data flow transformations like conditional split, look up, derived column etc.
• Worked with SSIS tool suite like Conditional Split, Lookup, Multicast and Derived Column.
• Involved in performance tuning for new databases and existing databases by using SQL profiler.
• Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles using T-SQL.
• Used Event handlers to run send mail tasks in the background upon success or failure of a package in SSIS.
• Collaborated with fellow team members through Team Foundation Server for effective project management which includes work issues and track on the update of versions.
• Involved in troubleshooting, enhancing and creating new ones of claims retro report templates.
• Extensively used various patterns and designed patterns for configuring finance calculations, snapshot measures, time series calculations.
• Created various measures with Confidential and rich PowerBI visuals for business and Configured security, Organizational Content Packs, Workspaces, data Gateways, refresh schedules for PowerBI service.
• Used Power Query to connect to various data sources and acquire data and design high rich visuals in the PowerBI Desktop.
• Proficiency in developing reporting, designing analytics platforms, data modeling, performance point, Power pivot, dashboard development.

Environment: MS SQL Server 2016/2014/2012 , SQL Server Integration Services (SSIS), SSRS, T-SQL, SQL Excel, POWER BI, Windows XP.

Confidential, Atlanta, GA

Oracle PL/SQL DEVELOPER

Responsibilities:

• Involving in the full development cycle of Planning, analysis, design, development, testing, and implementation.
• Designing logical and physical data models for star and snowflake schemas.
• Created and modified SQL Plus, PL/SQL and SQL Loader scripts for data conversions.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Wrote SQL, PL/SQL, SQL Plus programs required to retrieve data using cursors and exception handling.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Coordinating with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Created and modified several Unix shell scripts according to the changing needs of the project and client requirements.
• Wrote Unix shell scripts to process the files on a daily basis like renaming the file, extracting the date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Can assist in developing and implementing new technologies.
• Support all day to day activities related to database like data consolidation, data migration scripting.
• Creating complex views, materialized views on multiple tables as per customer requirement.
• Used PL/SQL Tables, Cursors to process huge volumes of data and used bulk collect for mass update as performance improvement process.
• Migrated data from flat files to tables using SQL*loader.
• Develop and modify VBA code for Microsoft Products
• Collect raw data and generate monthly consumption report (number of (hardware) servers, Middleware, software in use.
• Verifies the accuracy and performance of all code developed, including the preparation of test data and the execution of program.
• Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Informatica Designer 8.6 to extract the data from multiple source systems that comprise databases like Oracle 10g, SQL Server 7.2, flat files to the Staging area, EDW and then to the Data Marts.

Environment: Oracle 10g/11g (SQL, PL/SQL, Stored Procedures, Triggers), MS SQL SERVER DB2, Teradata, MS Access. ETL Tools: Informatica (Power Center AB Initio and SQL Loader), Visual Studio 2015 .

Confidential

SQL Server Developer

Responsibilities:

• Developed Tables, Views, and Stored Procedures using SQL Server Management Studio.
• Optimized the query performance with modifications in T-SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins.
• Used SQL Profiler to debug T-SQL and slow running queries.
• Designed complex ETL strategies to pull data from different sources, like SQL server oracle, and flat files and load it to the destination database after using multiple transformations.
• Coded the SQL Server stored procedures for the enhancements.
• Created Linked reports, Ad-hoc reports and etc. based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports using SSRS in SQL Server.
• Created databases, tables, relationships, constraints. Wrote SQL Queries, views, Stored Procedures for the interaction of transferring data to and from screens to the backend, at optimum performance.
• Enhancement involved implementation of SQL Server with the usage of Stored Procedures, SQL Execution Statistics / Plans, Optimizer and SQL Profiler for back end.
• Data modeling, normalization, de-normalization, physical database design, and relational models.
• Creating and maintaining roles and profiles for security and limited access of data. Design and implementation of Backup & Recovery strategies.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database server.
• Monitored the Database Performance using execution plans and Index tuning.
• Created Pivot tables in excel using data from various sources like SSRS and MS Access.
• Collaborated with fellow team members through Team Foundation Server for effective project management which includes work issues and track on the update of versions.
• Diagnosing and tuning the server and query optimal performance using SQL Server Profiler and Database Tuning Wizard.

Environment: MS SQL Server, SQL Server Reporting Services (SSRS), SQL Server Data Tools, ETL, Windows XP.