OBJECTIVE

• Looking for Lead developer/Architect or other leadership positions.

SUMMARY

• More than 16 years of experience in Information Technology.
• More than 14 years of data warehousing experience in the areas of ETL design, development, testing and Production support.
• Hands on experience in Informatica Power center, Informatica Master data management, Informatica IDQ, Informatica Metadata manager, OBIEE, Oracle Essbase, SSIS, SSRS, Perl and Abinitio environment.
• Working knowledge on different data sources ranging from flat files, Excel, Oracle, SQL Server, UDB DB2 databases and XML files.
• Involved in full lifecycle of various projects, including requirement gathering, system designing, data modeling, application development, enhancement, deployment, maintenance and support.
• Hands on experience in upgrading Oracle Essbase from version 9 to version 11.
• Hands on experience upgrading Informatica power center from 5.x to 6.x, 5.x to 7.x, 6.x to 7.x,7.x to 8.x and 8.x to 9.x
• Responsible for all activities related to the development, implementation and support of ETL processes for large - scale data warehouses using Power Center 5.1/6.2/7.1/8.5/9.6.1 and Power Mart 4.7/5.1.
• Worked extensively with Dimensional modeling, Data migration, Data cleansing, ETL Processes for data warehouses.
• Hands on experience in configuration and using Informatica Power Connect 7.1/6.2/5.1 for IBM MQ series/JMS/ SAP BW/Mainframes.
• Strong ETL data integration experience using Informatica Power Center, Informatica Power Mart (Source Analyzer, Repository Manager, Data warehousing designer, Mapping Designer, Mapplet, Transformations), Power Connect, Oracle, SQL*Loader, OLAP, SQL Server and MS Access.
• Highly skilled, motivated team player, outstanding organizational skills and excellent communication and Inter-personal skills.

TECHNICAL SKILLS

Hardware: HP-UX, IBM-AIX, Windows XP, Windows 2000, Windows NT 4.0 and MVS

Databases: MSSQL Server 2000/7.0/6.5, Oracle 10g/9i/8i/7.3, MS Access 2000/7.0, DB2-UDB

ETL Tools: Informatica Power Mart 8.5/7.1.4/6.2/5.1 (Source Analyzer, Repository Manager

Other Tools / Utilities: SQL*Plus, Sync sort, MS Word, MS Visio, F-secure ftp, Putty.

Scheduling Tools: Cisco Tidal scheduler, Tivoli Workflow Scheduler 8.3, UNIX crontab, Opcon, Informatica scheduler and Windows task scheduler.

Modeling Tools: Erwin 7.1/4.1/4.0/3.5 and Oracle Designer.

Reporting Tools: OBIEE, SSRS, Crystal Reports 8.0/8.5, Business Objects 5.1 (Designer, Supervisor, Reporter, Broadcast Agent, Web Intelligence), Cognos Impromptu 6.0, Powerplay 6.6, Micro strategy 6.0/7.5, SAS.

Languages: Windows Power shell, UNIX Shell Scripting, Perl, SQL, PL/SQL, and JCL

PROFESSIONAL EXPERIENCE

Confidential

Lead Application developer

Responsibilities:

• Designed ETL logic and documented technical specifications.
• Written complex ETL workflows to pull data from EDW and then load the data into Oracle.
• Mentored other junior developers regarding datawarehouse concepts and informatica.
• Implemented Power exchange configuration set up for the first time in the team.
• Used informatica powerexchange to upload the files from Linux server to mainframe.
• Written Mainframe JCL scripts to compress the files and send the files to the vendor.
• Worked with devops tools like Harvest, udeploy, Jenkins, Git-bitbucket and Artifactory.
• Worked with SQLloader scripts to load the files into Oracle database.
• Worked with NDM scripts which uploads and downloads from linux to mainframe.
• Used TSO commands to browse mainframe objects.
• Learned and Support Data comtrol framework for mnemonic.
• Worked on decommissioning CA7 jobs.
• Developed and documented test cases for SVT (small volume testing) and FVT (Full volume testing).
• Sent adhoc files to the business and vendor based on their requirement.
• Read data from Teradata and loaded into flat files and Oracle tables.
• Scheduled meetings with business folks, DBA's,
• Performed Peer code review, SIT and UAT testing.

Environment: Red hat Linux, Teradata 15, Oracle 11, SQL loader, Informatica power center 9.6.1, IBM Mainframe, Informatica power exchange 9.6.1 for VSAM sources, Rocket Bluezone mainframe display, NDM/ connect Direct

Confidential

Assistant Vice President

Responsibilities:

• Worked as developer, ETL architect, administrator and PROD support lead in different phases of the project.
• Worked as a lead developer for few projects.
• Migrated Informatica Power center and MDM code across several environments.
• Worked in user security, audit report creation, maintenance and other admin activities.
• Developed ETL solutions for Credit risk and Remote deposit capture projects using Informatica.
• Created MS SQL server stored procedures and functions for Campaign project.
• Created windows batch scripts to copy, rename and archive files.
• Created Perl scripts to load historical data for TPR FDR FRAUD FALCON data.
• Created Windows power shell scripts to do pattern matching and check valid files for PINGEN project.
• Worked as PROD support as part of on call rotation.
• Worked on few work tracker tickets like making changes to W ASSET D table and generated report for compliance.
• Created several mappings, sessions and workflows for credit risk project.
• Created pattern 3 mapping for Remote deposit capture project.
• Created pattern1, pattern 2(slowly changing dimensions) and pattern 3 mappings for credit risk project.
• Made changes to SQL server reporting services code for CRIF DIRECT and CRIF indirect subject areas.
• Worked on reconciliation process and implemented the existing reconciliation code for other projects.
• Performed run book reviews with the vendor and suggested changes to the ETL code and design during early stages of the project.
• Worked on informatica upgrade from version 8.6.1 to 9.6.1
• Worked on data center migration.
• Worked on several vendor releases. Changed the code, validated and migrated to production environment.
• Reviewed ETL server architecture and suggested changes.
• Trained new hires and scheduled few Knowledge transfer sessions.
• Worked on MDM enhancements.
• Attended several informatica PC, MDM and IDQ trainings.
• Reviewed MDM and IDQ code with the vendor and suggested changes.
• Developed and supported SSIS ETL scripts for CRIF indirect application and SSRS reports for CRIF direct and indirect applications.

Environment: Informatica Power center 9.6.1, Informatica MDM 9.7.1, Informatica IDQ, Informatica metadata manager, MS SQL server 2008, SSIS, SSRS, Perl, Windows power shell scripting, Windows Batch scripting, SSRS, Opcon scheduler, service now.

Confidential, Pittsburgh, PA

Senior Datawarehouse Programmer/ Senior Business Intelligence developer

Responsibilities:

• Used Business Intelligence Development Studio to build reports using the wizards and designers, and deploy them to Report Server.
• Created new and improve existing database reports using SQL Reporting Services 2005.
• Responsible for creating reports based on the requirements using SSRS 2005.
• Created Stored Procedures, views in SQL Server using T-SQL to collect data for SQL reports.
• Developed and implemented procedures to ensure the quality, usability and accuracy of reports.
• Created dimensional models using Erwin.
• Scheduled enterprise data warehouse jobs using Tidal scheduler and scheduled Hyperion jobs using Star analytics command center.
• Responsible for OBIEE and Hyperion architecture, configuration and administration.
• Migrated OBIEE RPD and Web catalog across DEV, TEST and PROD environments.
• Created RPD and web catalog for Institutional effectiveness subject area.
• Written Perl code for maintenance activities like disk space, archiving and purging of old files and logs.
• Played a key role in upgrade of Oracle essbase from version 9 to version 11.
• Used Essbase administration services to load the data into essbase from flat files.
• Worked in Charter of accounts outage every month which is part of Hyperion maintenance.
• Supported more than 500 OBIEE and Hyperion users.
• Used Essbase integration services to create the outline which has drill down capability.
• Created several tickets with Oracle, Microsoft and Informatica to troubleshoot product issues.
• Worked as on call support for data warehouse and Essbase teams.
• Retrieved data using Hyperion excel add-in when needed to troubleshoot issues.
• Used Star analytics integration services to convert essbase’s multi-dimensional format to relational format so that Hyperion metadata can be transferred to enterprise data warehouse.
• EDW is in the process of migrating from SQL server to Teradata. Tested integration of Teradata with Hyperion platforms.
• Pulled data from Lawson ERP to data warehouse and then pulled data from data warehouse to Hyperion database.

Environment: SQL Server 2008R2/2008/2005, Windows 2008 server, Windows Server 2003(x64), SQL Server Management Studio, Tidal scheduler, OBIEE 10.1.3.4, Informatica Power center 8.5/7.1.3, Cognos Impromptu, Cognos power play, Business objects Crystal Reports, IBM Data stage, Oracle Essbase 9/11, Hyperion planning, EAS, EIS, Star analytics, Star integration server, Star command center, Perl 5.8, Windows power shell, Windows batch script, Windows vbscript. Essbase excel add-in 9/11, Erwin, Teradata, Lawson ERP, Microsoft Dynamics CRM..

Confidential, Pittsburgh, PA

Senior ETL Developer/ Data Modeler/ Architect

Responsibilities:

• Gathering business requirements for several tasks from business users and documented business requirements document.
• Designed several logical/physical dimensional model Stars (Dimensions and Facts) using Erwin 7.x
• Created separate Informatica mappings to load staging tables, dimensions and facts.
• Used parameter files in informatica to load history as well as ongoing data load.
• Converted PL/SQL code to Informatica code for few projects.
• Created PL/SQL stored procedures, materialized views and views based on reporting requirements.
• Performed performance tuning of SQL queries and verified whether indexes are available in the target table and suggested DBA’s to create it when needed.
• Created PTM’s to push the code from Dev to QA and QA to Production.
• Implemented processes to receive incoming files from several sources using delimited/ fixed width format and written ftp programs to move the files to informatica servers.
• Worked with Oracle Business integration enterprise edition (OBIEE) answers to test the reports.
• Worked with Mainframe Tapes and DASD. Pulled data from mainframe datasets and loaded into oracle tables. Worked with COBOL Copybooks.
• Written UNIX ksh scripts to run informatica workflows which were called by CA7 scheduler.

Environment: Informatica Power center 8.5/7.1.3, Sun OS 5.9, TOAD 8.5.3, OBIEE, F-secure ssh, CA Erwin 7, Mercury Quality Center 9.0, OBIEE 10.1.3, Oracle 10g, Cognos Impromptu 7.0, CA7 scheduler, All Fusion Harvest r 7.1.

Confidential, Willington, DE

Application Developer (ETL developer)

Responsibilities:

• Created Technical Specifications document based on Functional document for few interfaces related to circuit city conversion.
• Created Abinitio Graphs using Abinitio GDE 1.14.
• Also created subgraphs. Used Phases and used check points where needed.
• Used EME data store to check in and checkout graphs.
• Created .dbc files to connect to database.
• Logged system events like logging events in Control databases which is in Oracle.
• Scheduled UNIX scripts using Tivoli Workflow Scheduler.
• Executed the force run and placed the jobs streams on hold when required. Used Alias and Is draft options when necessary.
• Worked with Data modeler in adding and updating entities, their relationships and attributes in ERWIN data modeler.
• Created UNIX ksh scripts to check job dependencies, run graphs and other functionalities.
• Deployed graph as UNIX korn shell script.
• Involved in isolating defects and document them in mercury Quality Center.
• Used Harvest to check in/check out UNIX and sql scripts.

Environment: Abinitio 1.14, GDE 1.14, Co-Operating system 2.14,EME, IBM GPFS, All Fusion Harvest r 7.1, IBM Tivoli Workflow Scheduler 8.3, Mercury Quality Center 9.0, Oracle 10.2, IBM-AIX 6.1, Enterprise Change Management, Peregrine Ticket service center, Unix Korn shell scripting, CA Erwin 7.2, TOAD 9.0, Oracle SQL developer, SQL Navigator, Business Objects XI 3.0.

Confidential, Richmond, VA

Lead Application Developer /Data Modeler/Production Support

Responsibilities:

• Involved with the Business analysts in requirements gathering, business analysis, testing, and project coordination.
• Created complex mappings using Aggregator, Expression, Joiner transformations including complex lookups, Stored Procedure, Update Strategy and several other transformations.
• Extracted, Transformed and Loaded data from Oracle tables and flat files to staging area and then to production using Informatica mappings and complex transformations.
• Monitored the daily load and solved issues related to pending, failed jobs during DW oncall (24X7 production support) for 2 and half years.
• Involved in benchmarking new systems with the old ones including Informatica and operating system.
• Worked on the server manager to run several sessions and batches concurrently and sequentially.
• Tuned complex queries/sub queries/ correlated sub queries from business users and improved performance.
• Used Explain Plan to calculate the cost and reduced the cost by tuning the query.
• Developed UNIX shell scripts to use xfiles instead of direct connect (ftp) for external applications and changed the scripts to use sftp for internal applications.
• Check in and Checkout of Informatica mappings and sessions in XML format.
• Created mappings to handle slowly changing dimensions.
• Written scripts to back up Informatica Repository on daily basis.
• Knowledge of service oriented architecture and new features of 8.5.
• Worked as Informatica administrator. Migrated folders, mappings and sessions from Dev TQA ITE PROD. Administered User access.
• Written scripts to shutdown start informatica server and repository server.
• Installed and Upgraded new versions when needed and prepared test plan to test the upgrade.

Environment: RCS, ECMS, Informatica Power Mart 5.1/ Informatica Power Center 8.5/7.1.2, Oracle 9.2.0.6, HP-UX 11.11, TOAD 8.5.1.6, IBM - AIX 5.2, Perl 5.8, Korn shell, WRQ Reflection, Cognos Impromptu/Power Play 7.0, Winsql, TSYS.

Confidential, Birmingham, AL

Lead Application Developer/ Data Modeler

Responsibilities:

• Involved in project management plan and the understanding of Business Process and Process flow.
• Involved in Dimensional modeling to Design and develop STAR Schemas using ERWIN 4.0 to identify Fact and Dimension Tables.
• The end users request could vary from a simple extraction of data from the base tables (data mart tables), or could go to the extent of making code logic changes.
• Provided guidance and help develop mappings, mapplets and sessions from source to target to other developers.
• Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformations.
• Tested all the mappings and sessions after upgrading it to 7.1 and then moved Tom Production.
• Used UNIX shell scripts and Perl for data cleansing and data scrubbing.
• Used XML source qualifier to process XML messages from IBM MQ series.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Testing of Informatica Sessions, Batches and the Target Data.
• Extensively involved in performance tuning at source, target, mapping, session and system levels.
• Developed Shell Scripts, PL/SQL stored procedures, table and Index creation scripts.
• Involved in unit, Integration, functional and performance Testing.
• Worked as Informatica Administrators. Contacted Informatica support when needed.
• Written scripts to back up repositories on a daily basis. Also written scripts to monitor whether the server is working or not.
• Worked with developers when having issues execution of informatica mappings, sessions, mapplets or worklets.
• Introduced Parameter files concepts for the current system. Monitored workflow logs to check if there are any errors running sessions and workflows.

Environment: Informatica Power Center 6.2/7.1, Informatica power connect for IBM MQ series, SQL Server 2000, Oracle 9i, TOAD, Sun Solaris 2.6, IBM MQ series, Queue manager, and Business Objects 5.0, Perl and Test Director 8.0

Confidential, Manhattan, NY

ETL Developer/ Data Analyst/Informatica Administrator

Responsibilities:

• Meeting the customer and understanding their business requirements.
• Analyzed specifications and identified source data needs to be moved to data warehouse, participated in the Design Team and user requirement gathering meetings
• Designed logical and physical database models using Erwin.
• Obtained data from various remote sources using FTP feature of Informatica.
• Involved in the preparation of documentation for ETL standards, procedures and naming conventions.
• Developed Shell Scripts, PL/SQL stored procedures, table and Index creation scripts.
• Created Pipeline partitioning to improve Session performance.
• Involved in configuration and environment set up for Informatica power center connect for SAP BW.
• Defined target connection string in the workflow manager and executed the session and inserted data into SAP Business Information warehouse, which has backend as Oracle.
• Used Power center connect for SAP BW to send the data to the target, which is in SAP Business Information Warehouse.
• Developed different types of Reports using Cognos Impromptu 6.0, Cognos PowerPlay 6.6
• Creating catalogs, folders and reports with Cognos Impromptu
• Used Impromptu features such as sub-reports, Drill through and charts

Environment: Oracle 8i, Informatica Power Center 6.2/7.1, Informatica Power connect 7.1 for SAP BW, HP-UX, UNIX shell scripting, Perl, Cognos Impromptu 6.0, Cognos Power Play 6.6

Confidential, Las Cruces, NM

Software Programmer (Graduate Assistant/ Research Assistant/ Teaching Assistant)

Responsibilities:

• Involved in overall software life cycle of the project.
• This includes gathering business requirements, design, development, testing and production support.
• Worked with the business team in person to understand the business requirements.
• Worked as Lead developer for agricultural communications.
• Mentored new hires and trained new hires to get them up to speed.
• Participated in several training courses to build a good product.
• Followed industry best practices and delivered quality project.
• Created logical and physical data models for various applications.

Environment: MS SQL server, MySQL, Microsoft Access, SQL server management studio, Windows OS, ASP, PHP, HTML, XML, CSS, Lasso, C programming.