PROFESSIONAL SUMMARY:

• Over 9+Years of experience in IT Professional career in ETL, Business Intelligence and Data warehousing. Extensively worked on MS SQL Server MSBI Technologies (SSIS, SSAS and SSRS), C# and .NET.
• Experience in software development life cycle, business requirement analysis, design, programming, database design, data warehousing and business intelligence concepts, Star Schema and Snow Flake Schema methodologies.
• Involved in understanding of business processes, grain identification, identification of dimensions and measures for OLAP applications. Created slowly Changing dimensions (SCD) and optimized fact table inserts.
• Experienced in executing complex queries using stored procedures, Triggers, Cursors, User Defined Functions using T - SQL.
• Experienced in creating complex T-SQL queries for data analysis and data manipulation. Organize analytical data, ensure data quality and aggregate data for strategic reporting, performance optimization on database solutions.
• Experience in data migration from various data sources like Excel, SQL Server, Oracle, XML files, Flat files using SSIS packages and SQL commands. Monitoring, debugging and tuning ETL jobs and workflows.
• Experience in developing SSIS packages to transfer data from OLTP to OLAP Databases with different types of control flow tasks, data flow transformations and deploying the packages to Production server.
• Experience in Designing, Creating and processing of cubes using SSAS. Created and Configured Data Sources and Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI's, Hierarchies and calculated measures for OLAP cubes.
• Worked with Multi-Dimensional Expression (MDX) for querying and manipulating the multidimensional data stored in OLAP cubes.
• Experience in the Reports generation by using Authoring and Managing Components of SSRS from both relational databases and OLAP Cubes.
• Experience in generating on-demand and scheduled reports for business analysis using SQL Server Reporting Services (SSRS). Generated Drill down reports, Parameterized reports, Linked reports, Sub reports, Matrix reports and Cascaded reports in SSRS.
• Experience in creating test data and unit test cases. Writing test cases and system plans to ensure successful data loading process.
• Experience working 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 seven days) called "sprints".
• Experience in performance tuning of SSIS packages, Query optimization and database consistency checks. Very good skills of documenting different kinds of metadata.
• Experience in using Team Foundation Server (TFS) as a tool for source control, data collection, reporting and project tracking.
• Having excellent communication, Presentation skills, and Strong analytical and problem solving SKILLS.

TECHNICAL SKILLS:

Databases: MS SQL Server 2014/2012/2008 R2/2008/2005, Oracle 8i/9i /10g, Access

ETL Skills: SQL Server Integration Services (SSIS) 2014/2 2014/ 2012/2008/2005 , Informatica Power Center v 7.1, Unix Shell Scripting

Business Intelligence: SQL Server Reporting Services(SSRS) 2014/2, SQL Server Analysis Services(SSAS) 2014/2

Programming Languages: C#, VB.Net, SQL, T-SQL, PL / SQL.

Tools: Toad, SQL Navigator, Erwin, MS-Office, Visual Source Safe 2005, Team Foundation Server (TFS)

Operating Systems: Windows XP/2000/7, Windows Server 2003, Sun Solaris/HP/AIX

Data Ware housing: Dimensional Modeling (Star Schema Modeling, Snowflake

Methodologies: Modeling), Kimball Methodology, Inmon Methodology Processes Maintenance of Operational Data Store(ODS) and Enterprise Data warehouse (EDW), OLAP.

WORK EXPERIENCE:

Confidential, Cincinnati, OH

Sr.SQL Server, SSIS, ETL Developer

Responsibilities:

• As a Data warehouse Developer involved in all the phases of the project from scratch and performed different roles in the different phases of the project.
• Analysed business requirements and worked closely with the business users to understand business requirements and designed the process for the data extraction, business logic implementation and loading into target tables. Identified the dimensions, Fact tables and designed the data mart.
• Designed and developed the ETL solution using SSIS packages to implement slowly changing dimensions of Type 2 to populate current and historical data into Dimensions. ETL solution validated incoming data and sent notifications when jobs are done.
• Designed and documented the error-handling strategy in the ETL load process. Prepared the complete ETL specification document for all the ETL flows.
• Created Stored Procedures, User Defined Functions, Views. Created database triggers to check the referential integrity of the database.
• The Customer data thus loaded in to data warehouse is utilized to generate reports using the SSRS reporting functionality.
• Developed monthly, weekly and daily reports as per the requirement and gave roles, user access with respect to security in Report Manager.
• Created test data and unit test cases to ensure successful data loading process.

Environment: SQL Server, T-SQL, SSIS, SSAS, SSRS, Windows 7, Visual Studio / 2013, C#, VB.Net, Autosys, Team Foundation Server.

Confidential, Dublin, OH

SQL Server, SSIS, ETL Developer

Responsibilities:

• Detailed study and data profiling of all the underlying information security application systems and understood the information security data models. Identified and captured the right metadata from source systems.
• Developed the proto-type and delivered three months of historical data in development environment to the business users for a proof of concept.
• Identified the field and column level data quality issues of the source systems to drive the data quality, data cleansing and error checking in the ETL packages.
• Analysed and performed Data mapping which involved identifying the source data fields, identifying target entities and their lookup table ids and translation rules.
• Designed and developed ETL packages using SQL Server Integration Services (SSIS) to load the data from SQL server, XML files to SQL Server database through custom C# script tasks.
• Designed and documented the error-handling strategy in the ETL load process. Prepared the complete ETL specification document for all the ETL flows.
• Filtered bad data from legacy systems using T-SQL, implemented constraints and triggers into new system for data consistency.
• Created T-SQL stored procedures, functions, triggers, cursors and tables.
• Developed Drill-through, Drill-down, sub Reports, Charts, Matrix reports, Linked reports using SQL Server Reporting Services (SSRS).
• Involved with Query Optimization to increase the performance of the Reports.
• Co-ordinated with business users to perform the User Acceptance Test (UAT). Prepared migration and deployment plans for Production deployment.

Environment: SQL Server, T-SQL, SSIS, SSAS, SSRS, Windows 7, Visual Studio / 2013, C#, VB.Net, Team Foundation Server.

Confidential, Glen Allen, VA

SQL Server, SSIS, ETL Developer

Responsibilities:

• As an ETL Developer for the Logility Metrics project involved in all the phases of the project. Employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered, non-clustered indexes and import of data using SSIS packages.
• Identified the field and column level data quality issues of the source systems to drive the data quality, data cleansing and error checking in the ETL packages.
• Designed and developed ETL packages using SQL Server Integration Services (SSIS) 2008 to load the data from different source systems (SQL Server, Oracle, flat files, csv files).
• Designed and documented the error-handling strategy in the ETL packages.
• Created T-SQL stored procedures, triggers, cursors and tables.
• The customer data loaded into the SQL Server was used to generate reports and charts using the SQL Server Reporting Services (SSRS) 2008 reporting functionality.
• Developed different kinds of reports per the requirement using SSRS reporting functionality.
• Created test data and unit test cases to ensure successful data loading process.

Environment: SQL Server, T-SQL, SSIS, SSAS, SSRS, C#, VB.Net, TFS, Windows 7, Visual studio, TFS

Confidential, Pittsburg, PA

SQL Server BI Developer

Responsibilities:

• Understanding existing business model and customer requirements. Detailed study and data profiling of the underlying application systems for the sales of the different campaigns promoted.
• Developed the proto-type of the Multidimensional objects CER cube SQL Server analysis Services (SSAS) 2008 and delivered six months of historical data in development environment to the business users for testing purpose.
• Created the (CER Cube) and developed Aggregations, partitions, calculated members for the cube and generated daily reports to measure the sales of the segmented people across different regions for different campaigns.
• Designed and developed the ETL data flow to populate the CER Cube Analysis Database using the SQL Server Integration Services (SSIS) 2008. Scheduled and automated the packages to populate the data in the cube daily up to date for business reporting.
• Extensively involved in the SSAS storage, partitions and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Designed Dimensional Modeling using SSIS Packages for End Users. Created Hierarchies in Dimensional Modeling. Defined appropriate measure groups and KPIs.
• Designed and deployed direct and indirect customers reports for targeted segmentation of people and across different regions with Drill down approach. Also developed Drill-through reports to measure the performance detail of different distribution channels.
• Created quarterly sales reports with Chart controls to measure the progress of sales every quarter for different distribution channels.
• Created test data and unit test cases to ensure successful data loading process.
• Preparation of Root Cause Analysis document to document the failure of the nightly job, root cause, and corrective action.

Environment: MS SQL Server 2008, T-SQL, SSIS, SSAS, SSRS, C#, VB.Net, Windows Server 2008, IIS 6.0, MS Visual Studio 2008, Visual Source Safe 2005.

Confidential, Minneapolis, MN

MS SQL Server Developer, SSIS and SSRS

Responsibilities:

• Migrated reports that were build in Actuate Reporting System to SSRS using VB Scripts.
• Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report, Analytical Cube or an Excel pivot table.
• Designed SSIS packages to Extract data from different sources like SQL server 2008, MS Excel, MS Access; transform them and then load into Dimension and Fact tables in Data Warehouse using SSIS.
• 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.
• Produced operational reports in SSRS 2008 i.e. drill-down, drill-through, dashboard and matrix reports.
• Wrote complex SQL queries and stored procedure to create reports using SSRS 2008 from the relational database.
• Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables.
• Created SSRS Data Model projects using Microsoft Visual Studio 2008 and using Report Builder for report server to create reports.
• Configured the report server and generated the report models for user interactions.
• Responded to ad hoc requests and special projects that require immediate attention while at the same time maintaining deadlines on existing requests.
• Developed and maintained system documentation, diagrams and flowcharts.
• Worked with project manager and technical leads for resolution of technical issues.
• Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL.
• Created clustered and non-clustered indexes on tables for new database to faster retrieval of data for the Reports.

Environment: MS SQL Server 2005, Microsoft Visual Studio, Microsoft Visual Basic, Oracle 11g, SQL Server Management Studio, MS Excel, T-SQL,ERWIN, Photoshop 7.0.

Confidential, Baltimore, MD

SQL Server SSIS, ETL, SSRS Developer

Responsibilities:

• Understood the Business point of view to implement coding using SQL Server. Worked closely with executive sponsors, users and decision makers to develop the transformation logic to be used.
• Designed, developed, tested and automated Extraction Transformation and Loading (ETL) processes using SQL Server Integration services.
• Worked with high volume datasets from various sources like Oracle, Text files, Relational Tables and xml targets. Responsible for mandatory checks, date field checks and number field checks in ETL packages.
• Incorporated error logging logic in all the packages. Involved effectively with the users regarding the source system problems.
• SDLC - from analysis to production implementation, with emphasis on identifying the source and source data validation, implementing business logic and used transformations as per the requirement in developing ETL packages and loading the data into the target.
• Developed database object as T-SQL stored procedures, user defined functions, triggers, views, complicated queries, indexing.
• Met end users to discuss legacy reporting, to gather requirements, design specifications and developed new reports using SQL Server Reporting Services 2005/2008. Created various SQL Server Reports like Sub reports, drill down reports.
• Involved in the system integration and the entire system test and support of the project. Involved in the documentation of the project. Prepared the test scripts, executed the test scripts and validated the results with the co-ordination of business users.
• Involved in the troubleshooting and resolved complex technical issues. Involved in the performance tuning of the databases.

Environment: SQL Server 2005/2008, T-SQL, Windows Enterprise Server 2003, SSIS, SSAS 2005/2008, SSRS 2005/2008, IIS 6.0, C#, VB.Net 3.5, Visual Source Safe 2005.