SUMMARY

• More than 5 years of IT experience in Data Design and Development on Microsoft SQL Server 2016/2014/2014/2012 , T - SQL, Performance Tuning, Troubleshooting, Microsoft Business Intelligence tools - SSIS/DTS, SSRS, SSAS (Multidimensional and Tabular models).
• Proficient in Database modeling and normalization up to 3rd NF, Dimensional modeling using star and snowflake schemas.
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Experience with logical and physical data modeling and database design using Erwin.
• Experience in Performance Tuning and Query Optimization.
• Strong Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good hands-on SQL Server Analysis Services (SSAS).
• Experienced in report development using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Experienced in developing, monitoring, extracting, and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Experience in handling slowly changing dimension type 1 to type 3 using slowly changing dimension wizard of SSIS and custom SHA-5 hash generation using T-SQL Hashbytes function.
• Hands on experience on various SQL Server tools like Import Export Wizard, SQL Profiler and Index tuning Adviser Wizard.
• Hands on Experience in Installing, Configuring, Managing, monitoring, and troubleshooting SQL Server 2016/2014/2012.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Data Loading Experience in SQL Server 2008 using SSIS ETL and Experience in developing packages in SSIS and DTS according to task.
• Data analysis and data migration by transferring them using SSIS packages.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Deployed and processed SSAS cube weekly to update information by using SQL Server Agent.
• Expert in creating SSAS cubes and creating dashboards in PPS (Performance Point Server) using Business Modeler.
• Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using SSRS in Business intelligence development studio (BIDS).
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Experience in using Automation Scheduling tools like Autosys and Control-M.
• Worked extensively with slowly changing dimensions.
• Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Capable of forming and maintaining positive and productive working relationships in internal/external and team environments.

TECHNICAL SKILLS

Databases: Microsoft SQL 2014/2012/2008 , Oracle 11g/Oracle 10g, Oracle 9i, MS Access

BI and ETL Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Oracle SQL, Microsoft Visual Studio 2010/2013/2017

Reporting Tools: Microsoft SQL Server Reporting Services (SSRS), Power BI, Tableau

Database Design and Data Modeling Tools: MS Visio, Oracle SQL Developer Data modeler

Operating Systems: UNIX, LINUX, Sun Solaris 5.8/5.9/5.10 Windows XP/07/10, Windows Server 2012/2012 R2/2016

Tools: and Utilities: Business Intelligence Development Studio (BIDS), SQL Server Data Visual Studio 2013/2007, Share Point 2013, Team Foundation Server (TFS), Microsoft Word, Excel, and PowerPoint

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

SQL/ETL Developer

Environment: - Microsoft SQL Server 2016/2014, SSIS, SSRS, XML, ETL, OLTP, FTP, ASP.Net, C#, VB.Net, SQL Profiler, Windows XP, GitHub.

Responsibilities:

• Collaborated in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems.
• Interacted with Business Analyst, Subject Matter Experts and Stakeholders to understand the business needs and documented the complex business requirement into simpler one and automate the process by writing complex scripts and scheduling on the jobs.
• Designed, Developed, and deployed database tables and structures and ensuring their stability, reliability, and performance.
• Developed complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Used Database Trigger for making history of insertion, updating, deletion and all kind of Audit routines.
• Used EXPLAIN PLAN, ANALYZE, HINTS, TKPROF to tune queries for better performance.
• Created Indexes and Sequences for faster retrieval of the customer information and enhance the database performance.
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
• Extended Design to Dimensions, Measure Groups in OLAP Cubes, Developed SSIS package to process cubes using process cube control flow tasks and SQL Agent jobs.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS
• Collaborated in production OLAP cubes, programmed queries to produce reports using SQL Server 2016 Analysis Services (SSAS) and Reporting service (SSRS)
• Designed and Developed reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Developed new Forms which are used to extract data from different systems and criteria. The results are written to a flat file.
• Performed unit testing of data extraction forms.
• Prepared technical specifications document for the Procedures which is used to update the purchase order information from one database to another database.
• Utilized tools like TOAD during development of the application.
• Used shell scripting in UNIX for Automatic Tasks like loading data into Tables, Importing and Exporting data.
• Extensively used the DBMS SESSION, DBMS STAT and DBMS PUTLINE oracle supplied packages.
• Developed Documentation of development code and the test cases involved.
• Worked extensively on Exception Handling, to trouble-shoot PL/SQL code.

Confidential, Fairfax, VA

SQL SSIS/SSRS Developer

Environment: - MS SQL Server 2014, SSIS, SSAS, SSRS, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, TFS, Visio.

Responsibilities:

• Facilitated business analyst as a senior SQL developer to understand and translate business requirements into technical documentation such as high level and low-level design specification documents, database schema and mapping documents.
• Developed and updated documentations (Data Analysis Forms, Data Mapping File, Business Requirement)
• Designed and developed specific databases for collection, tracking and reporting of data.
• Designed, coded, validated, and debugged custom queries using Microsoft T-SQL and SQL Reporting Services.
• Conducted research to collect and assemble data for databases - Was responsible for design/development of relational databases for collecting data
• Built data input and designed data collection screens - Managed database design and maintenance, administration, and security for the company.
• Using SQL to query Databases performing various validations and mapping activities
• Build a common utility framework to handle all the exceptions in a business process.
• Using Excel and VBA in the development of robust and flexible reporting systems.
• Performed cost benefit analysis of different ETL packages (SSIS) to determine the optimalProcess.
• Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description.
• Retrieved data from data warehouse and generated a series of meaningful business reports using SSRS.
• Validated and tested reports, then published the reports to the report server.
• Performed and conducted complex custom analytics as needed by clients.

Confidential, Washington, DC

Jr. SQL Developer

Environment: - SQL Server 2012, SSIS, SSAS, SSRS, BIDS, ETL, T-SQL, MS Excel, MS Access, MS Visio

Responsibilities:

• Worked closely with business analyst as a senior SQL developer to understand and translate business requirements into technical documentation such as high level and low-level design specification documents, database schema and mapping documents.
• Prepared and updated documentations (Data Analysis Forms, Data Mapping File, Business Requirement)
• Performed Normalization & De-normalization on existing tables for faster query results.
• Programmed complex SQL Queries, Stored Procedure, Triggers, Views & Indexes using DML, DDL commands and user defined functions to implement the business logic.
• Advised optimization of queries by looking at execution plan for better tuning of Database.
• Programmed T-SQL Queries and procedures to generate DML Scripts that modified database objects dynamically based on inputs.
• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
• Created SSIS package to import and export data from various CSV files, Flat files, Excel spread sheets and SQL Server.
• Designed and developed different types of reports like matrix, tabular, chart reports using SSRS.
• Involved in migration on SQL Server 2012 databases to SQL Server 2014.
• Maintained positive communication and working relationship with all business levels.
• Coordinating with onshore/offshore & stake holder’s team for task clarification, fixes, and review.
• Reviewed, analyzed, and implemented necessary changes in appropriate areas to enhance and improve existing systems.