SUMMARY:

• Expertise in working with relational databases such as SQL Server 2014/2012/2008 , MS Access, Oracle 11g/10g and Teradata
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications
• Strong Data Warehousing ETL experience of using SQL Server Internet Service and Informatica 9.6.1
• Expertise in Data Warehouse, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling, Worked extensively with slowly changing dimensions.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Experience in using Automation Scheduling tools like Autosys and Control - M.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Working knowledge of Hadoop, PIG and HIVE.
• Experience with Agile Development, SCRUM and Extreme Programming methodologies
• Oracle, PL/SQL and SQL Server Certified Professional
• Masters in Computer Science with excellent programming background and expertise with Database technologies
• Built Test Cases, involved in major project deployments in Production and ran automated validation tests

TECHNICAL SKILLS:

Languages: C#, ASP.NET, JAVA, Python, HTML, JavaScript, CSS, SQL, T-SQL, PL/SQL

ETL Tools: Informatica PowerCenter 9.6/10, Visual Studio 2012\2014

Databases: SQL Server 2014/2012/2008 , Oracle 11g/10g, Teradata, MySQL, PostgreSQL

Data Modeling: Logical and Physical Modeling, ER Diagram, Star Schema, Snowflake Schema, MS Visio

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

WORK EXPERIENCE:

Confidential

Data Engineer

Responsibilities:

• Enhanced cash flow forecasting, portfolio monitoring and performance measurement and benchmarking using T-SQL
• Identified and resolved end-user issues related to Front-End Applications, resolved data inconsistencies, created new data structures on SQL Server and ASP.Net
• Created Stored Procedures, Functions, and Views for new Reports and custom Parameter UI Forms in ASP.Net
• Built complex stored procedure using PIVOT, CTE and Analytical functions like CUME DIST, LAG, LEAD, RANK
• Created Database objects like Database Schema, Tables, Triggers, Constraints, Indexes, Functions, Views
• Handled the data migration project from Private i4 to Privatei5 using SQL Server Integration Services (SSIS)
• Interacted with the clients for business requirements, development and support activities
• Optimized queries and SQL Server performance, managed user groups, security and access levels for the product
• Responsible for Issue tracking, Defect Resolution and Service Request Escalations.
• Handle deployment using team foundation server (TFS)

Environment: SQL Server 2014\2012\2008, Visual Studio 2012\2014, TFS

Confidential

Responsibilities:

• Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Design and develop SSIS package for loading data from OLTP to ODS and finally to Data Warehouse
• Used ETL to implement Slowly Changing Dimension to maintain historical data in Data Warehouse
• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages
• Created packages using the various control flow task such as data flow task, execute SQL package task, File System task.
• Created SSIS Packages/projects to move data from source to destination programmatic by using Visual Studio 2013
• Created logic and indexed tables/views/stored Procedures based on the business requirements
• Performance Tuning of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.
• Successfully created database diagrams and physical models for the project.
• Performed cost benefit analysis of different ETL packages (SSIS) to determine the optimal Process.
• Experienced solving issues raised by QA, UAT for database, Unit testing and Integration testing for various modules
• Used SQL Server Analysis Services (SSAS) to design cubes for summary reports using Tableau and SSRS
• Created multiple reports for different department to show daily cumulative transactions.
• Present data in multiple formats including reports, charts, graphs, aggregates and statistical computations

Environment: T-SQL, SSIS, Tableau, and SSRS

Confidential

Responsibilities:

• Interacted with end users and line managers to gather business requirements and conducted user acceptance.
• Interacted with third party vendors and identified different external and internal homogenous and heterogeneous sources and extracted and integrated data from flat files, Oracle, Teradata sources and loaded to staging area and database mart tables.
• Used Collections in Python for manipulating and looping through different user defined objects.
• Written Python scripts to parse XML data and load into databases.
• Developed the required XML Schema documents and implemented the framework for parsing XML documents
• Created Informatica Data quality plans for business requirements to standardize, cleanse and validate data.
• Assisted in building the ETL source to Target specification documents by understanding the business requirements
• Developed mappings that perform Extraction, Transformation and load of source data into datamart using various power center transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy to meet business logic in the mappings
• Reusable transformations and Mapplets are built wherever redundancy is needed
• Performance tuning is performed at the Mapping level as well as the Database level to increase the data throughput
• Integrated data quality plans as a part of ETL processes
• Use Control-M to schedule ETL Packages
• Debugged existing ETL processes and did performance tuning to fix bugs.

Environment: Informatica Power Center 9.6.1, Informatica IDQ 9.6, Oracle 11g, SQL, PL/SQL, Python

Confidential

Responsibilities:

• Provide development to integrate enterprise systems to help the Finance Directors, Marketing and Sales Team for their vital decisions. Business decisions were based on the reports produced using CRM database
• Developed different type of reports including: Sales Report, Client Contact Report, Accounting Statement Report, Benefits statements report, Enrollment count summary report, Billing report by using SSRS and tableau
• Scheduled and managed daily/weekly/monthly sales and operational reports based on the business requirements.
• Developed the new “Contract” module by combining opportunity and account to tracked opportunities for each product
• Configured and customized new modules with developing Plug-ins in C# to give better look and advanced functionalities
• Build JavaScript code for Data Validation and automation
• Modified and built new workflows using processes and Plug-ins

Environment: Tableau, SQL Server 2008\2012, SSRS, MS Access, Microsoft Dynamic CRM 2013, JavaScript, C#

Confidential

ASP.net developer

Responsibilities:

• Built Confidential using ASP.Net\C#, JavaScript, CSS for the team to facilitate DBA tasks like performance enhancement metric
• Deployed database patches to QA, UAT and production databases, restore and update web site

Environment: Visual Studio 2014, SQL server 2012\2014

Confidential

Developer

Responsibilities:

• Wrote new module using Core Java and Hibernate with stored procedures in PL/SQL for Treasury Dashboard Systems, Modified TIBCO codes for sending/receiving trades add/edit messages

Environment: Java, Hibernate, Swing, JSP, Oracle 11g, PL/SQL, TIBCO

Confidential

Developer

Responsibilities:

• Developed web pages using Eclipse, Applied AJAX, JavaScript, CSS, and HTML to make web pages attractive

Environment: JAVA, Swing, JSP, CSS, HTML, and Oracle