EXPERIENCE SUMMARY:

• Around 10 years of IT experience with expertise in Data warehouse solutions using Microsoft BI and Oracle Suites.
• Extensive knowledge of Data warehouse architectures, methodologies, EDW designs and data models.
• Experience with SQL Server 2012/2008 R2, and Oracle 10g/11g. Strong expertise in T - SQL as well as PL-SQL scripting.
• Worked on different Data warehouse environments using the industry leading BI tools like SSIS, Informatica, OWB, and Cognos, Tableau and SAS
• Efficient in Data modelling, ETL designs and performance management.
• Around 6 years of exp. in data warehouse environment using SSIS and Informatica.
• Around 3 years of exp. in dashboard designs and development using Cognos and Tableau.
• Experience in Interacting with Business users, Requirements gathering and participating in analysis sessions with the user community to capture and define data requirements.
• Skilled in system analysis, business process modelling and business communications.
• Excellent skills in creating SQL objects such as Tables, complex Stored Procedures, Functions, Views, Indexes, Triggers, Rules, Constraints and using new features.
• Extensively used Dynamic SQL, Joins, Inline views, Sub Queries, Rank, Exists/Not Exists features of T-SQL.
• Proficient in Query Performance Tuning using Execution Plans, SQL Profiler and Tuning Advisor.
• Contributed to all phases of Database Design, Data Modeling, Development, Implementation, Testing, Extraction, Transformation and Loading (using SSIS BCP and Bulk Insert), and Reporting.
• Excellent experience in Creating, Configuring, Deploying and Maintaining SSIS packages.
• Resolved complex issues in SSIS packages, Error Handling in SSIS packages and tuned the slow running SSIS packages.
• Extensively used For each Loop Container, Sequence Container and various Control Flow tasks
• Extensively used many transformations viz. Conditional Split, Merge Join, Data Conversion, Derived Column etc.
• Extensive knowledge on package configurations - XML Configuration, SQL Server, Environment Variable and Parent Package variable.
• Extensive hands-on experience in Database development in both OLTP (Batch Processing, Online Processing) & OLAP Systems (SSIS, SSAS, SSRS).
• Experience in designing and implementing Star Schema / Snowflake Schema, Fact and Dimensional tables and Operational Data Store (ODS).
• Skilled in Unix and Shell Scripting
• Knowledge about Cloud computing principles and applications
• Experienced in SOA designs

COMPUTERS WORKED ON:

• Windows
• SQL Server
• SQL, T-SQL
• SQL Server 2008 R2, SQL Server 2012, SSIS, SSAS, SSRS
• Oracle
• PL-SQL
• Oracle 11g, Informatica 9.2, OWB, Toad, Hyperion
• SAS
• SAS
• PC SAS, SAS EG
• Cognos
• SQL, J-Script
• Cognos 8.2, Cognos 10.1 Report Studio.
• Core
• C++, Pro CHP Service Manager, HP Quality Centre
• IBM Mainframe Z/OS
• DB2
• PL/SQL, JCL
• ISPF/DB2
• Unix - HPUX / Solaris/ AIX
• SAS, DB2
• Shell Scripting (C, Bash, Korn), PERL, TCL-TK
• Hummingbird
• Digital Multiplexing Switch
• PROTEL
• PLS Mentor, CATT, CMUST, VSOS, MAPCI

CAREER PROFILE:

Confidential

Business Intelligence & Analytics

Responsibilities:

• Collect business requirements from users and translate them as technical specifications and design documents for development.
• Create Data Models (both operational and dimensional).
• Develop and Maintain database objects viz. Tables, Views, Cursors, Constraints, Clustered and Non-Clustered Indexes, Triggers.
• Develop, tune and deploy complex SQL Queries and Stored Procedures.
• Perform performance tuning and query optimization using SQL Profiler, Tuning Advisor and Execution Plan.
• Extensively used complex joins, Temp Tables, Dynamic SQL, Rank, Dense Rank, Row Number functions.
• Design, Develop and implement ETL processes using SSIS packages to extract data from heterogeneous sources like Excel, flat files, Oracle, DB2, Teradata, MS Access, MS SQL Server and apply desired transformations and load them to MS SQL Server.
• Automation of the alert/monitoring systems using elementary indicators of the data and integration with customized email services through SSIS Mail Agent and C# scripts.
• Develop ETL Load Control using CDC features of SQL Server and SSIS.
• Test, fine tune and Standardize Data meeting the business standards using lookups, Conditional Split, Derived Column, Merge Join, in SSIS transformations.
• Schedule Jobs via ESP to invoke SSIS packages and Stored Procedures to perform daily ETL operations.
• Generate scripts to compare and maintain sync between the Dev, QA and Production environments.
• Used Cognos Report Studio to create KPIs and Scorecards to improve metrics based Analysis.
• Develop Interactive Dashboards to display and analyze Claim Metrics(KPI’s) data using the Cascading Parameters features, Crosstab, Drill through and multiple graphs and charts.
• Extensively used Cognos features like conditional variables, render variables, crosstabs, various charts (pie, bar, speedometer, trencharts).
• Customize report designs using java scripts.
• Improve report runtime performance through design optimizations and query tuning.
• Adhoc report generation and analysis using SAS.
• Coordinate with offshore team members.

Hardware: IBM

Operating System: Windows, IBM Mainframe Z/OS, AIX

Languages: SQL, PL-SQL, TSQL, SAS

Special Software: MS SQL Server 2012, MS BI Suite, SAS, Oracle 11g, DB2, Cognos Report Studio

Confidential, Hartford

Responsibilities:

• Design and develop BI solutions for Operations and Management of TH&N organization across multiple lines of business.
• Create operational Data Models as well as dimensional data models using snow flake schema.
• Develop and Maintain database objects viz. Tables, Views, Indexes and Constraints.
• Create complex Procedures, Cursors and Triggers to implement business rules and transformation logics.
• Perform performance tuning and query optimization using Quest Toad Explain Plan and SQL Optimizer.
• Design, Develop and implement ETL processes using Informatica 9.2 to extract data from heterogeneous sources like flat files, Oracle, DB2, Teradata, MS Access, MS SQL Server and apply desired transformations and load them to Oracle Databases.
• Create complex mappings using multiple transformations like expression, lookup, joiner, normalizer, rank and aggregator
• Create workflow and deploy to various environments.
• Schedule Jobs via ESP to invoke Informatica Workflows and Stored Procedures to perform daily ETL operations.

Hardware: IBM

Operating System: Windows 7, IBM Mainframe Z/OS, AIX

Languages: SQL, PL-SQL, SAS

Special Software: Oracle 11g, DB2, Teradata, SQL Server, Informatica 9.2, Cognos Report Studio.

Confidential

Data Warehouse Solution Designer & Developer

Responsibilities:

• Developed new package using SSIS Control components like Execute SQL Task, Data Flow Task, Task Factory Components Execute Package Task, File System Task, Script Task (Both VB and C#), FTP Task, Containers and Transformations.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Troubleshoot migration issues like replacing the deprecated features in T-SQL code, addressing Collation errors, the SQL connections, users, permissions and configurations.
• Managed all the dependencies, storage issues, protection level of package, SMTP Tasks and retrieved the source code.
• Review and execute data refresh requests
• Maintaining warehouse data after migration and monitoring ETL job execution.
• Provide status update to Client Service Manager.

Hardware: Dell Workstation

Operating System: Windows, Sun Solaris

Languages: SQL, T-SQL, Shell Script

Special Software: MS SQL Server 2005/2008 R2, SSIS.

Confidential

Senior Data Warehouse and ETL Developer

Responsibilities:

• Worked with various upstream and downstream systems and customers in interfacing various systems for Data extractions, ETL, Analytics and reporting needs
• Developed Tables, Indexes, Views, complex stored procedures and Functions.
• Involved in source Data Analysis, Design and Creation of Data Mappings for Extraction of bulk data from heterogeneous sources like Oracle and other OLEDB data sources.
• Created Data-data packages in SSIS as part of the automating the process for billing method.
• Extracted data from various sources like SQL server 2008, Oracle, CSV, Excel and text file from Client servers and through FTP.
• Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Transform and load the Data from various Databases and into SQL Server using SSIS
• Scheduling and Maintaining SSIS Packages and batch jobs using Shell Scripts and batch (.bat) files on a day to day basis
• Experience in configuring with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
• Developed OLAP cubes by identifying tables (fact and dimension), data source and data source views, attributes and dimension members using SQL Server Analysis Services (SSAS)
• Worked on KPIs, design of Star schema and snowflake schema in Analysis Services (SSAS)

Hardware: IBM Workstations, Virtual Remote Servers.

Operating System: Windows 7, Window XP, Unix - Solaris

Languages: SQL, PL-SQL, C++, Pro C

Special Software: MS SQL Server 2008 R2, SQL Server Data Tools (SSIS, SSRS, SSAS)

Confidential

Data Warehouse & ETL Developer

Responsibilities:

• Worked as a core ETL developer for modular design and development towards Enterprise Data Warehouse for Client’s retail line of business.
• Created Dimensional Data Model using Star Schema.
• Created ETL workflow diagram showing the details of the process including multiple transformation gates.
• Developed Tables, Indexes, Views, Packages, Procedures, Functions, Cursors and Triggers using PL-SQL.
• Involved in creation of Data Mappings for Extraction of bulk data from heterogeneous sources including flat files and Oracle data sources.
• Developed shell scripts to format and cleanse raw data from flat files, as well as schedule ETL packages.
• Developed Load Control architecture using Procedures
• Developed Mappings and Workflows using Informatica for multiple ETL processes.
• Scheduling workflows using shell scripts.
• Prepared test data, written unit test cases and performed unit testing and system testing.

Hardware: IBM Workstations

Operating System: Windows, Unix - Solaris

Languages: PL-SQL, K-shell script

Special Software: Oracle 10g, Toad for Oracle, Informatica, Winscp & Putty.

Confidential

GPS Feature Designer and Developer

Responsibilities:

• Performing Impact Analysis and Effort Estimation for different components of the GPS features.
• Prepare high level solution design
• Code and develop features using PROTEL.
• Prepare Test scenarios in lab switches (MSC) and perform feature testing.
• Simulate switch traffic for virtual testing.
• Conduct peer reviews for quality assurance.
• Deploy features to live switches after UAT.
• Take ownership of feature and monitoring development progress throughout SDLC.

Hardware: Dell Workstations, DMS-MSC, VSE-MSC

Operating System: Window XP, HPUX, SOS (Switch Operating System)

Languages: PROTEL, C++, Shell Scripting

Special Software: Hummingbird, PLS, CATT, CMUST, SIPTRACK, MTXTRACK, VSOS