SUMMARY:

• Overall 10 years of IT experience in the Analysis, Design, Development, Testing and Implementation of Business Application Systems in ETL methodologies and data Warehousing principles and architectures including concepts, designs and usage of data warehouses.
• 6 years of Experience in designing and developing efficient ETL solutions to load huge volumes of data to/from various Flat files, XML files and Relational Databases i.e. PostgreSQL, Oracle, SQL Server & Netezza.
• 4 years of Experience with all phases of software development life cycle (SDLC), involved in designing, developing, integrating and implementing software applications based on Microsoft .NET technologies.
• Proficient in gathering the Business requirements and translating them to corresponding technical requirements and strategies.
• Extensive working experience in the Analysis, Design, Development, Testing and Implementation phases of various Data Warehousing applications.
• Extensive experience in ETL methodologies for supporting Data Migration, Data Exchange, Data Transformation using Developer Tool(IDQ) and Informatica Power Center 10/9.x/8.x/7.x Suite - Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager, Repository Manager, Workflow Monitor and Debugger and created Mappings, Mapplets, Sessions, Worklets, Workflows, Processing tasks.
• Developed mappings that perform Extraction, Transformation and load of source data into Derived Masters schema using various Power Center/IDQ Transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, and Look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and Update Strategy.
• Articulate and communicate effectively in fast paced Agile /Scrum based system, facilitated SCRUM ceremonies like Backlog Story Grooming Sessions, Sprint Planning Meetings, Daily Stand-Up Meetings and Sprint Reviews.
• Proficient in the Integration of various data sources with multiple relational databases like PostgreSQL, Oracle11g /Oracle10g, MS SQL Server, Flat Files, CSV files, XML files into the staging area and Data Warehouse.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using PostgreSQL, SQL Server, Oracle PL/SQL.
• Extensively involved in Optimization and Performance Tuning of mappings and sessions in Informatica by identifying and eliminating bottlenecks, memory management and parallel threading. Also performed Performance Tuning at Database levels using Indexes, Hints and Partitioning.
• Experienced to work as Production Support person in resolving on-going maintenance issues and bug fixes. Also handled critical situations to meet the deadlines for successful completion of the tasks/projects.
• Experience in using the Informatica command line utility (PMCMD) to schedule and control sessions and batches.
• Experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Worked with complex type mappings with xml source and targets.
• Worked on Slowly Changing Dimensions (SCD's) and its implementation (Type 1, Type 2, and Type 3) to keep track of historical data.
• Experienced in using Automation Scheduling tools like Autosys and Control-M and Version Control tool like Subversion and TFS.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently and use sound judgment.

TECHNICAL SKILLS:

ETL and BI Tools: Informatica Power Center 6.x/7.x/8.x/9.x/10/10.1.0, Informatica Power Exchange 9.x, Informatica Power Exchange CDC for Oracle, Hyperion Financial Data Quality Management 9.x., SSIS

DBMS/RDBMS: Oracle 11g//10g/9i/8i/7.x, SQL server 2012/2014, Microsoft Access, DB2 8.1

OPERATING SYSTEMS: UNIX, Linux, DOS, Windows XP/ 2003/2000/2008 /NT, Windows 7, Windows 10

LANGUAGES: PostgreSQL, SQL, PL/SQL, Unix Shell Programming, C, MS-Excel, Basic, COBOL.

VERSION CONTROL System: PVCS, Tortoise SVN(Subversion), TFS (Team Foundation Version), Microsoft Visual Source Safe

JOB SCHEDULING Tool: Control-M, IDQ Scheduler.

GUI Tools: PGAdmin 4, DB Visualizer, Toad, SQL Developer, PLSQL Developer, WinSQL, SharePoint, TFS, Visual Basic, ASP, Microsoft Visio

WEB TECHNOLOGIES: HTML, JavaScript, XML

METHODOLIES: Agile/ Scrum , Waterfall, Data Warehouse and Data Modeling

PROFESSIONAL EXPERIENCE:

Confidential

ETL /Informatica Developer

Environment: Informatica Developer Tool (IDQ) 10.2 (Designer, Workflow, Workflow Monitor, Repository Manager), Informatica PowerExchange 10.2, DB2, Postgr eSQL, UNIX Shell Script, Mainframes Copybook and IDQ Scheduler.

Responsibilities:

• Involving in the Analysis, Design, and Coding and Unit Testing phases of the ETL work.
• Involving in Agile software development method to deliver the tasks on sprints.
• Analyzed the Mainframe COBOL code for extracting business requirements and designing the technical specifications for implementing the requirements.
• Building ETL jobs using Informatica Developer Tool (IDQ) and PowerExchange 10.2 tools.
• Extracting the feeds from various source systems like Mainframe, DB2 and Flat Files, Transforming the data as per the business requirements and Loading them into various target systems like PostgreSQL and EBCIDIC File format using Informatica tools.
• Responsible for using efficient ETL transformations for implementing the business requirements.
• Writing Unix Shell scripts for File Transfer from Informatica server to AWS Server and then to the Agency, triggering the Informatica jobs for complex interfaces.
• Creating and utilizing Copybooks layout from Mainframe for reading data from source or write target feeds.
• Creating Data maps in Informatica PowerExchange for importing the mainframe copybooks.
• Performed performance tuning, debugging and error handling of mappings, sources and targets for better performance.
• Involved in Code Migration into different environments based on Testing Requirement.
• Performed the unit, Integration and system testing. Assisted in building UAT Test Scripts and provided support to the end-users test performed in UAT.
• Experience in creating and effectively executing deployment plan to move all the objects, tables, mappings, workflows, SQL scripts, etc. to production.
• Worked on Service related tickets and problem tickets and identified the root cause for the business issues raised and provided enhancements and fixes in the current codes and gave a permanent resolution to the issue
• Continuously improve control processes, ensuring data integrity, quality, standardization, and security throughout the ETL process.
• Support production solutions and the ongoing updating and maintenance of Interfaces.
• Attending the Daily standup call with the technical team and client managers to provide the updates on the tasks assigned.

Confidential

Programmer Analyst/ETL Informatica Developer

Environment: Informatica PowerCenter 10.2 (PowerCenter Designer, Workflow, Workflow Monitor, Repository Manager), Oracle 11g-SQL, PL/SQL, Netezza, UNIX Shell Script, Control-M.

Responsibilities:

• Worked on Enterprise Information Quality (EIQ) Project with team of 4 in
• Handling ETL processes and tools
• Database loading and manipulation
• Managing load dependencies
• Automation for measuring progress and accuracy of data.
• Enhanced and redesigned Informatica ETL mappings to extract master and transactional data from heterogeneous data feeds and load.
• Analysed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Worked with Static, Dynamic and Persistent Cache in lookup transformation for better throughput of Sessions.
• Monitored sessions using workflow monitor that were scheduled, running, completed or failed.
• Created scripts to create new tables, views, and stored procedures for new enhancement in the application using TOAD.
• Ability to troubleshoot web API based REST layer in Informatica.
• Developed various SQL queries using join, sub-queries & analytic functions to pull the data from various relational DBs i.e. Oracle, Netezza & SQL Server.
• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
• Used the Business objects features Slice and Dice and Drill Down for multi-dimensional analysis.
• Scheduled various daily and monthly ETL loads using Control-M.

Programmer Analyst/.Net Developer

Confidential, Wayne, PA

Environment: IIS 6.0, Visual Studio .NET 2008, Visual Studio .NET 2010,.NET Framework 2.0/4.0, AJAX, ASP.NET, C# .NET, SQL Server 2008, Sub Versioning, Windows 2003.

Responsibilities:

• Designing end user interface using Web-forms in ASP.NET with various Validations Controls.
• Extensively used .NET inbuilt components like Data Grid, Repeater, Data List, Calendar controls and all the ASP.NET server controls.
• Involved in designing and developing front-end screens (user interface) using C#.NET.
• Used AJAX tools for interactive User Interface and Java Script/jQuery for validations.
• Made full use of .NET object oriented features, error handling, caching, security, tracing and event logging features.
• Built a WCF web service which is consumed by various applications internally/externally for user security.
• Used CSS to enhance the user experience with the web interface.
• Created Tables, Views, Indexes and Stored Procedures using SQL Server 2008.
• Performed unit testing and integration testing by applying test cases.
• Used Sub Versioning system as the source code repository.

Confidential

.Net Developer, Silverspring, MD

Environment: IIS 6.0, Visual Studio .NET 2005, .NET Framework 2.0, AJAX, ASP.NET, C# .NET, Oracle PL/SQL 10g, Web Services, Rational Clear Case, Windows 2003.

Responsibilities:

• Designing end user interface using Web-forms in ASP.NET with various Validations Controls.
• Extensively used .NET inbuilt components like Data Grid, Repeater, Data List, Calendar controls and all the ASP.NET server controls.
• Involved in designing and developing front-end screens (user interface) using C#.NET.
• Used AJAX tools for interactive User Interface and Java Script for validations.
• Developed .NET services components, .NET Assemblies and Web Services using XML, ASP.NET, and C#.NET.
• Developed data layer logic for user logging which lets user to access only the specified services according the roles.
• Developed business logic components as a middle-tier between database and the UI for Billing and order management modules.
• Made full use of .NET object oriented features, error handling, caching, security, tracing and event logging features.
• Developed data interface layer using ADO.NET and C# for data access.
• Developed the data layer of the system by writing stored procedure, triggers, views and indexes in Oracle 10g.
• Extensively used ADO .NET features like Data Set, Data View and Data Adapter.
• Used DHTML to enhance the user experience with the web interface.
• Performed unit testing and integration testing by applying test cases.
• Used Visual Source Safe as the source code repository.
• Worked as a production support lead for the same project.

.Net Developer

Confidential, Fountain Valley, CA

Environment: .NET Framework 3.0, 3.5, IIS 6.0,ASP.NET, C#.NET, Ajax, Dundas Charts, ADO .NET, SQL Server 2005, Visual Studio 2008, Microsoft Visio 2007,Windows 2008,VSS.

Responsibilities:

• Developed UI Using ASP.NET 3.5 with HTML, DHTML, Master pages, themes, Profiles, CSS web server controls, Dundas Charts and User Controls using C# as code-behind language.
• Designed and developed various abstract classes, interfaces, classes to construct the business logic using C#.NET.
• Used ADO.NET to interact with the Oracle database and to exchange data with the presentation-tier. The middle tier contained all the business logic.
• Developed dynamic ASPX web pages for Application using ASP.NET, C#.NET, XML, XSL/XSLT, HTML and JavaScript.
• Worked with ASP.NET Web Forms, Web Services, and State Management, Caching features, configuring optimizations and securing the web application.
• Extensively used ASP.NET Data Grid, Data List and Repeater controls for displaying the data in a clear format.
• Written JavaScript functions for client side code to implement different functionalities in events, validation and listeners.
• Extensively used AJAX Control tool kit and AJAX libraries for providing light weight AJAX requests.
• Used ADO.NET objects such as Data Reader, Dataset and Data Adapter, for consistent access to Oracle data sources.
• Followed an agile style development with frequent application demonstrations to the upper management.
• Written and performed test cases using Integration testing tool to implement Test driven development to reduce bugs and created unit test cases before coding and then write code according to pass the test case.
• Used Visual Source Safe 6.0 for source control, reporting, check-in policies, build schedule and project tracking.
• Designed and implemented the database on SQL to store employee’s specific information and created stored procedures, triggers, functions and Views.

Confidential

Systems Engineer

Environment: IIS 5.0, .NET Framework 2.0, Visual Studio 2003, ASP.NET, C#.NET,SQL Server 2000, Java Script, CVS, Windows 2003.

Responsibilities:

• Completely involved in designing and development of web-based application.
• Designed and Developed Web forms using ASP.NET.
• Developed Use Cases, Class diagrams using Visio.
• Involved in Analysis and designing the User Interfaces, Use Controls according the requirements.
• Used CSS, Master Pages and various Data controls.
• Involved in writing code for Data Bindings, and writing JavaScript’s for client side validations.
• Used AJAX for making smaller, faster and user friendly web-page application, Used ASP.NET Server Controls and HTML controls to design the web pages.
• Involved in writing the programming code for web pages using C#.NET.
• Created Database scripts, SQL, stored procedures, triggers in Oracle and tested them
• Involved in consuming a web service in getting the orders details of various clients and branches.
• Created Use Cases, Use Case diagrams and Navigational Diagrams to provide additional details for Developers as well as Quality Assurance analysts.
• Involved in unit testing of the application according to the Use cases written.
• Involved in Source Code Management using Concurrent Version Systems (CVS)
• Created the Setup for installing at the user end using .NET. Packaging and Deployment.