SUMMARY

• Over 7+ years strong experience in the IT industry as SQL Server and BI Developer/Architect in Development and Implementation.
• Expertise in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Ad - Hoc Reports.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity and query writing.
• Strong Knowledge in dimensional Star Schema and Snowflakes Schema.
• Extensive experience in writing SQL Queries, Stored procedures, Functions, Packages, Database triggers.
• Proficient in tuning data flow tasks in SSIS using SQL Profiler, SSIS performance monitor.
• Expertise in solving run time issues using error and event handler, breakpoint, check point and loggings in SSIS.
• Well experienced in creating various types of reports like Tabular, Matrix, Drilldown, Cascaded parameterized, Sub reports, Ad-Hoc Reports, Cross Tab Reports in multiple formats like Excel, Word, PDF, Image, and Power Point using SQL Server Reporting Services (SSRS) and Tableau based on client requirements.
• Expertise in distributed query performance tuning by using EXPLAIN PLAN and hints.
• Very strong in SQL Query Tuning, Database Triggers, Stored Procedures, reducing time for night batch jobs by reviewing SQL code, modifying database query.
• Extensively worked in Client-Server application development using SQL, PL/SQL, T-SQL, SQL Server 2008/2010/2012, SSIS 2010/2012, SSRS 2010/2012.
• Experience in the Analysis, Design, Development, Testing and Implementation of business application systems.
• Assisted QA Teams for bug testing, User Acceptance Testing (UAT) & System Integration Testing.
• Experience in MS Excel skills like Pivot Tables, Macros.
• Experience in application development using various advanced features of Oracle like Collections, Bulk Collections, Table Functions, Autonomous Transactions, Dynamic SQL, Object types and Records.
• Extensive experience in data migration techniques using SQL* Loader, Import/Export, bulk and batch processing.
• Experienced in SDLC data analysis, data modeling, development, testing and documentation of projects.
• Excellent in High Level Designing of SSIS Packages to perform ETL from heterogeneous sources such as Excel, CSV, Oracle, flat file, Text Format Data using multiple transformations provided by SSIS to generate underlying data for the reports and to export cleansed data and deploying them on various production servers.
• Experience in Production Support and troubleshooting data quality and integrity issues.
• Extensively Worked on Extraction, Transformation and Load (ETL) process using PL/SQL to populate the tables in OLTP and OLAP Data warehouse Environment.
• An Enthusiastic and goal oriented team player with excellent analytical, communication and interpersonal skills and proficient in technical writing and presentations.
• Ability to work independently or part of a team to accomplish critical business objectives.

TECHNICAL SKILLS

Database Tools: SQL Server 2005/08/10/12, SQL * Loader, TOAD, Oracle SQL Developer, SQL Tool, SQL*Plus, SSIS, SSRS, SSAS, Cognos, Crystal Report, Visual Basic

Data Modeling Tools: Erwin, Microsoft Visio

Data Analysis: Requirement Analysis, Business Analysis, Detail Design, Data Flow Diagrams, Data Definition Table, Business Rules, Data Modeling, Data Warehousing, System Integration.

Programming Languages: Unix Shell Scripting, XML, C, C#, C++, Java, JavaScript, CSS, VBScript, .Net, HTML, XML, COBOL, CICS, JCL

Environment: Windows, Unix, MS DOS, ZOS

PROFESSIONAL EXPERIENCE

Confidential, Burnsville, MN

SQL BI SSIS/SSRS/SSAS Developer

Responsibilities:

• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Used SSIS to unite data from existing system and performed transformations on MS SQL.
• Extract Transform Load (ETL) development Using SQL server 2012, SQL 2012 Integration Services(SSIS).
• Generated drill down and drill through reports using SSRS.
• Created cubes using SSAS.
• Developed SSIS packages with Error Handling.
• Experience in using SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Visual Studio.
• Bulk inserted data from huge files to different destination tables in SQL server using SQL Server Integration Services (SSIS).
• Wrote many TSQL Stored procedures to perform specific tasks as per the requirements.
• Performed debugging on various Stored Procedures to handle errors.
• Developed different kind of reports such as charts, matrix, graphs, etc.
• Extensively used T-SQL in constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.

Environment: MS SQL Server 2008/2012, T-SQL, SSAS, SSIS Packages, SSRS, SQL*Plus, MS-Office, Beyond Compare, Oracle SQL Developer, SVN.

Confidential, Frederick, MD

MSBI Developer

Responsibilities:

• Created database objects like tables, views, indexes, stored procedures, Packages using SQL.
• Exposure to SQL Loader and ETL concepts in a data warehousing environment with large volume databases.
• Actively participated in gathering Business Requirements and System Specification. Participated in implementing the logical design to the physical design by creating tables.
• Involved in the design of new schema, new tables, field definitions and mappings, queries.
• Created SSIS Packages by using advance transformations (i.e. Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate)
• Created Dynamic SSIS packages using complex expressions, variables and control flow components such as For Each Loop, For Loop to loop over a Directory to load inbound files coming daily.
• Prepared the document showing the paths for input and output files, configuration files, table scripts, stored procedures and SSIS packages.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services (SSRS)
• Created different type of reports which include: Cross-tab, Conditional, Sub report, Drill-down and Parameterized and deployed and scheduled Reports in Report Manager using SSRS to generate all daily, weekly, monthly and quarterly Reports.
• Monitoring performance and optimizing SQL queries for maximum efficiency
• Loaded data from Source to destination using different format file like Text file, OLDB file, Excel file in SSIS.
• Created SSIS Packages to read claims status data from Oracle andSQLdatabases and generated output files that hold the payment information in various file formats like TXT, Excel, .CSV, etc.
• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
• Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Exposure to data modeling concepts in a RDBMS environment.
• Involved in performance tuning for complex SQL queries using Explain Plan tables, collections, and table partitions to optimize performance.
• Built physical data structures like tables, views, constraints & Indexes and Data Modeling.

Environment: SQL Server 2012, SQL *Plus, MS-Office, T-SQL, Beyond Compare, SVN, SSIS 2012, SSRS 2012, Toad, Visual Studio, Windows, Unix.

Confidential, Chicago, IL

MDBI Developer

Responsibilities:

• Involved in database development by creating SQL Query, SQL Functions, Procedures, Triggers, Packages, Performance Tuning, Records and Collections.
• Involved in Planning, Defining and Designing database diagram using Erwin 8.0 on business requirements and provided documentations.
• Worked in the Agile methodology using Scrum which has its primary focus on the management part of the software development, dividing the whole development period into small iterations (of thirty days) called "sprints."
• Wrote complex SQL queries using 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.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created various MSBI(SSIS) packages using data transformations like Merge, Aggregate, Sort, Multicasting, Conditional Split, and SCD (Slowly Changing Dimension) and Derived column, transformation of XML based on XSD File Experience with designing the ETL process, including data read/write, data transformations, error handling, process design, logging and Development.
• Generated Drill down, Drill through, Ad hoc, Matrix Reports, parameterized reports using MSBI( SSRS).
• Worked Closely with QA and DBA Team. Based on Requirement to Modify the code.
• Involved in application enhancements according to user requirements.
• Designed Oracle workflows for automation of business processes.
• Worked on ETL tools using SSIS, SSRS, and SSAS.
• Involved in performance tuning for complex SQL queries using Explain Plan tables, collections, and table partitions to optimize performance.
• Built physical data structures like tables, views, constraints & Indexes and Data Modeling.

Environment: SQL Server 2012, SQL Loader, Visual Studio, Toad, Beyond Compare Tool, QC 11(ALM), SSIS 2012, SSRS 2012, SSAS, Cognos, MS-Office, MS Visio, Erwin, UNIX/Linux and Windows.

Confidential, Southfield, MI

MSBI Developer

Responsibilities:

• Gathered requirements to identify, create and use database objects like tables, views, stored procedure, triggers and indexes.
• Created Stored Procedures for commonly used complex queries involving joins and union of multiple tables.
• Created virtual library for source code and converted different types of source code format as per the requirement.
• Involved in database development by creating SQL Functions, Procedures, Records and Collections.
• Worked on Claims, Facets and Plans.
• Involved in application enhancements according to user requirements.
• Built physical data structures like tables, views, constraints & Indexes.
• Documented design specifications and architecture using Microsoft outlook, Microsoft Excel.
• Developed TOAD, SQL loader scripts to load data in the custom tables.
• Transferred the data using FTP toolbox in SSIS.
• Configured oracle reports and crystal reports with internet information services (ISS).
• Involved in performance tuning for complex SQL queries using Explain Plan tables, collections, and table partitions to optimize performance.
• Built physical data structures like tables, views, constraints & Indexes and Data Modeling.
• Documented design specifications and architecture using Microsoft outlook, Microsoft Excel.

Environment: SQL Server 2008/10, SQL Loader, SVN Tool, MS-Office, Crystal Reports XI, SSIS 2008, SSRS 2008.

Confidential, Boston, MA

Database Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirement and provided documentation.
• Created SSIS packages to extract data from OLTP to Data warehouse systems and scheduled Jobs to call the packages and Stored Procedures.
• Applied various MSBI data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column, and etc.
• Developed Unit Test Plans for SSIS packages.
• Modified the existing MSBI (SSIS) packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on daily basis.
• Designed, developed, and deployed reports in SQL Server environment using MSBI (SSRS 2008).
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for monitoring and tuning report performance.
• Developed tables with partitions and created indexes, constraints, triggers, synonyms, database links, table spaces, roles etc in different schemas.
• Worked with SQL loader and control files to load the data in different schema tables.
• Implemented features including materialized views for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
• Created database objects like tables, views, Stored procedures, Packages using Oracle Utilities like PL/SQL, SQL* Plus, Toad.
• Developed Complex queries to retrieve the data as per client requests based on certain parameters and restrictions.
• Extensively Worked on Extraction, Transformation and Load (ETL) process using PL/SQL to populate the tables in OLTP and OLAP.
• Used Exception Handling extensively to display the error messages in the application.
• Involved in Production Support and troubleshooting data quality and integrity issues.

Environment: SQL Server 2008, SSIS, SSRS, SQL *Plus, MS-Office, Crystal Reports XI, Toad, Windows.

Confidential

Database Developer

Responsibilities:

• Designing Tables, Views, Cursors, Triggers according the requirements given in the design document.
• Developed system standards, architecture, scenarios, detailed screen specifications and documented logical and physical data model using Erwin Data Modeler.
• 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 MSBI (SSIS).
• Worked Extensively with MSBI - SQL Server Integration Services (SSIS) to import, export and transform the data between the linked servers.
• Created packages using MSBI (SSIS) for data extraction from Flat Files, Excel files, OLEDB source to data warehouse.
• Used SSRS to create reports, customized reports, On-Demand reports and Ad-Hoc reports and involved in analyzing multi-dimensional reports in MSBI (SQL Server Reporting Services 2005).
• Developed stored procedures, triggers and functions to account for some automated insertion of records in some of the tables.
• Writing code for stored procedures, functions according to the requirements.
• Involved in the complete life cycle of the product from requirements gathering to end of system testing.

Environment: SQL Server, Oracle SQL Developer, MSBI (SSIS, SSAS, SSRS), Toad.