SUMMARY:

• Over Eight Years of experience in IT Professional career in ETL, Business Intelligence and Data warehousing. Extensively worked on MS SQL Server 2014/2012/2008 /2005 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/2012/2008 /2005 2014/2012/2008 /2005, Informatica Power Center v 7.1, Unix Shell Scripting

Business Intelligence: SQL Server Reporting Services(SSRS) 2014/2012/2008 /2005, SQL Server Analysis Services(SSAS) 2014/2012/2008 /2005

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) 2010.

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

Datawarehousing Methodologies/ Processes: Dimensional Modeling (Star Schema Modeling, Snowflake Modeling), Kimball Methodology, Inmon Methodology, Maintenance of Operational Data Store(ODS) and Enterprise Data warehouse (EDW), OLAP

Internet Software/Other Tools: HTML, XML, UML, Clear Quest, Case Studio and Harvest.

PROFESSIONAL EXPERIENCE:

Confidential, Raleigh, NC

SQL Server / SSIS / ETL Developer

Responsibilities:

• As an ETL Developer for the CISCMMetrics project involved in all the phases of the project from scratch and end to end and performed different roles in the different phases of the project.
• 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 2008/2012 /2014, T-SQL, SSIS, SSAS, SSRS, Windows 7, Visual Studio 2008 /2012 / 2013, C#, VB.Net, Team Foundation Server.

Confidential, Charlotte, NC

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 2008/2012 /2014, T-SQL, SSIS, SSAS, SSRS, Windows 7, Visual Studio 2008 /2012 / 2013, C#, VB.Net, Autosys, Team Foundation Server.

Confidential, Charlotte, NC

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 2008 /2012, T-SQL, SSIS, SSAS, SSRS, C#, VB.Net, TFS, Windows 7, Visual studio 2008 / 2012, TFS

Confidential, Atlanta, GA

SQL Server BI Developer

Responsibilities:

• As a Business Intelligence Developer for the Campaign Effectiveness Reporting (CER) Data cube project involved in all the phases of the CER cube development.
• 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, Irving, TX

SQL Server SSIS/ ETL / SSRS Developer

Responsibilities:

• SQL Server Data warehouse Developer for the Confidential EDW and BI projects team. Involved in all the phases of the Sales and Billing project from scratch and end to end and performed different roles in the different phases of the project.
• 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.

Confidential

Informatica Developer

Responsibilities:

• Worked closely with executive sponsors, users and decision makers to develop the transformation logic to be used in Informatica.
• Extensively worked on UNIX shell scripts and Pl/SQL stored procedures.
• 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 mappings and loading the data into the target.
• Extensively used transformations like Router, Aggregator, Source Qualifier, Joiner and Expression transformation. Developed Mappings for loading fact tables. Designed and developed reusable objects.
• 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 programs required to retrieve data using cursors and exception handling.
• Developed shell scripts to repeat core session run for all given input files, shell script for doing ftp and sending status mail.
• Scheduled the sessions to extract, transform and load data into warehouse as per business requirements.

Environment: Sunsolaris, Oracle8i, SQL, Pl/SQL, Toad, Informatica Power center 7.1, ODBC, Actuate and Connect Direct.