SUMMARY

• Over 3 years of experience in System Analysis, Design, Development and Implementation of Relational Database Systems, Data Warehousing Systems, Data Marts and Data Migration using ETL Tools like Informatica, DataStage, and SSIS.
• Good Knowledge on OLTP, OLAP, Dimensional Modeling, Fact Tables, Dimension Tables and Star Schema Modeling.
• Experience in IBM DataStage Components like DataStage Designer, Director, and Administrator and Informatica PowerCenter Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Experienced in working with SQL Server, Oracle PL/SQL, DB2, and MySQL databases.
• Knowledge in Visual Analytical tools such as Tableau, PowerBI and Qlik View.
• Experience in UNIX shell scripts.
• Have extensively worked on solving critical production support issues, data truncation process, unit testing, deployment and documentation.
• Having excellent track record as a strong team player with effective communication, analytical and multi - tasking skills, multilingual, detail-oriented professional with strong technical skills.

TECHNICAL SKILLS

Operating Systems: Windows

Software / Applications: MS Word, MS Excel, Outlook, PowerPoint

Database: SQL Server, Oracle 11g/10g, DB2, Teradata

ETL: DataStage 9.1/8.x/7.5, Informatica PowerCenter 9.6.1, SSIS

OLAP/BI Tools: Tableau, PowerBI, Cognos, SSAS, SSRS

Languages: Java, HTML, SQL, PL/SQL, DAX, Python, C#

Web/Apps Servers: IBM Web Sphere, Tomcat

Tools: TOAD, Visio, Eclipse, Visual Studio

PROFESSIONAL EXPERIENCE

Confidential - Charleston, WV

Programmer Analyst

Responsibilities:

• Expertise in designing and implementing DataStage jobs in Data warehousing and Business Intelligence projects.
• Worked with Data Modelers/Architects to identify and understand the data from different source systems.
• Involved in the Analysis of the functional side of the project by interacting with functional experts to design and write technical specifications.
• Involved in data warehouse designing - Star Schema.
• Created Data stage jobs (ETL Process) for populating the data into the Data warehouse constantly from different source systems like ODS, flat files.
• Extracted data from sources like DB2 Database and Flat Files.
• Responsible for performance tuning and enhancements.
• Involved in Unit Testing and Integration Testing to test jobs/sequences.
• Worked on Change Requests as per clients and projects technical specification needs.
• Automated process of job monitoring which in-turn helped minimizing the manual intervention & documented them.
• Provided support for monthly/weekly batches in production run.
• Worked with the Production Support Team and helped in finding the cause for the Production Environment issues.
• Worked with Database Administrators and network Administrators in case of critical Production issues.
• Involved in the Documentation of the ETL phase of the project.
• Integrated data from different data sources using DAX and worked on creating dashboards consisting of insights to show customer complaints, financial, HR data using Tableau/PowerBI.
• Also involved in migrating the old management website run in Cold Fusion and Flash to C# .Net.
• Worked with senior programmers to create an administrator website using front-end technologies like HTML, CSS, Bootstrap, AngularJS.
• Worked on bugs and Change Requests given by the users.
• Documented business processes, lessons learnt & best practices for the project.

Environment: DataStage 9.1 (Designer, Manager, Director), Oracle 11g, DB2, Unix, .Net, C#, Visual Studio, AngualarJS

Confidential - Houston, Texas

Data Analyst

Responsibilities:

• Got trained and worked on in-house projects using IBM DataStage.
• Used DataStage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into Data Warehouse.
• Performed Import and Export of DataStage components and table definitions using DataStage Manager.
• Extracted data from heterogeneous sources like Oracle, and DB2.
• Worked extensively on different types of stages like Sequential file, ODBC, Aggregator, Transformer, Merge, Join, Lookup, Sort for developing jobs.
• Strong understanding of the principles of Data warehouse using Fact Tables, Dimension Tables, Star and Snowflake Schema modeling.

Environment: DataStage 9.1 (Designer, Manager, Director), Oracle 10g, Unix, DB2

Confidential - Huntington, WV

Application Developer

Responsibilities:

• As a part of Master’s Degree program, worked on creating an administrative website for Confidential, Huntington, WV, USA.
• Collected requirements, developed the website on .NET framework using C# language and MVC model, and SQL Server database at the back-end, according to the client's requirements.
• Created a repository on GitHub and deployed the project to run on AppHarbor.
• Included admin functionalities as requested, reporting features.
• Reports on employee management, product management and customer management were generated according to the needs of Business Users.
• Also worked on the user-manual as requested by the client.
• Monitored the performance of newly deployed system and handled deployment issues.

Environment: .NET, C#, Visual Studio, MS-SQL Server, GitHub, AppHarbor

Confidential

Senior Associate, Business Intelligence & Data Warehousing

Responsibilities:

• Designed, developed and upgraded ETL jobs using IBM DataStage/Informatica ETL tool in development environment and improved the performance of ETL jobs running in production environment.
• Coordinated with Client/Business Analysts to understand the requirements in developing ETL-Jobs/SQL- Queries to extract data from source database, perform transformations and load data to target database.
• Created DataStage/Informatica jobs (ETL Process) according to the mapping documents, for populating the data into the Data warehouse constantly from different source systems like ODS, flat files, DB2 database.
• Worked extensively on different types of stages like Sequential file, ODBC, Aggregator, Transformer, Merge, Join, Lookup, Sort for developing jobs.
• Created & loaded dimension and fact tables using Star schema.
• Implementation of Data Vault which stores single version of facts(Slowly Changing Dimension-1/2), based on client specifications.
• Involved in Unit/Integration Testing on jobs/sequences developed in Development Environment.
• Created operational/visual analytical reports using Tableau, QlikView.
• Responsible for performance tuning and enhancements.
• Provided support for monthly/weekly batches in production run.
• Worked with the Production Support Team in finding the cause for the Production Environment issues.
• Worked with Database Administrators and network Administrators in case of critical Production Issues.
• Created specification and mapping documentation.

Environment: DataStage 8.7/7.5 (Administrator, Designer, Manager, Director), Informatica PowerCenter 9.6 (Designer, Workflow Manager, Workflow Monitor), Oracle 10g, Unix, DB2, Tableau