SUMMARY

• Over 10 years of core IT/Business experience with over 6+ years of strong lead experience as a Project Manager/Business Analyst/Project Lead and handling Projects across different domains (Banking & Finance, Retail, Healthcare, Energy and Manufacturing Sector).
• Worked across geographies including USA, Australia, Malaysia, India and Ireland.
• Worked on high level scope and objectives of the project and defining processes of the section or whole of the organization in a very transparent manner for the implementation.
• Extensively worked on understanding the requirements to ensure there is a minimum gap amongst end user/stakeholders and the technical team.
• Worked on aggressive analysis and validation techniques for development, testing and implementation phases.
• Possess solid understanding of the Change management processes for the new requirements or any proposed changes, Release management and quality audits.
• Worked under different roles like Project Manager, Business Analyst, Technical Lead, Software Engineer, Senior Analyst etc.
• Worked on ISMS and ISO standards for IT departments and across projects for security and compliance & audit requirements.
• Excellent problem solving skills with strong technical background and good interpersonal skills. Quick learner with ability to meet deadline & work under pressure.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/7.x, SQL*Plus, Oracle Warehouse Builder, Data Stage. Power Exchange, Power Mart, Data Quality/Informatica Developer, Informatica Data Transformation (B2B), Oracle Data Integrator, OLAP, OLTP, Star schema, Snowflake Schema.

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snow - Flake Modeling, FACT and Dimensions Tables, Physical / Logical Data Modeling, Erwin 4/3

Databases: Oracle 8i/9i/10g/11g, SQL Server, DB2, MS Access., Teradata

Reporting Tools: Tableau, Rapid Miner, BUSINESS OBJECTS - Designer, COGNOS- Power Play transformer, SSRS

Programming: SQL, PL/SQL, HTML, DHTML, XML, C, C++, ASP.NET, Cold Fusion, Shell, Perl, Cobol, JCL

Environment: Windows95/98/2000/XP/2003, Unix-AIX 5.2/4.3,Sun Solaris7, WinNT4.0, Mac OS X, CRM tools, ERP

Enterprise systems: Salesforce, SAP, Clarify 10.1, Remedy 4.0, PeopleSoft, Icare 2.1

Request/Versioning/Bug Reporting/Scheduling Tools: HP Service Centre Client, Clear Case, Peregrine enterprise service center, Bugzilla, Subversion/TortoiseSVN, Work Load Manager by CA, Control M

PROFESSIONAL EXPERIENCE

Confidential

Project Manager

Responsibilities:

• Working on highly technical and mobile reporting requirements including data landing patterns in database, movement, information and presentation layer design for various applications.
• Executing complex projects/programs from design to development to production phases.
• Onboarding new resources, allocations, defining resources and schedule for project implementation
• Developing, managing the Project management plan and completed the Quality Assurance directives.
• Requirement gathering from the business and stakeholders and converting them in the HLD, LLD and planned for the roll out of the changes in the Dev, UAT and Prod environment.
• Track and maintain projects planning in Planview throughout the lifecycle phases.
• Maintain documentations related to projects in SharePoint, TFS and several other KPI dashboards.

Environment: OBIEE, Informatica 9.1.1, SQL, ASP .Net, Oracle 10g, Remedy 4.0, MS Office, MS Project

Graduate Assistant

Confidential, OH

Responsibilities:

• Completed the project planning and coordination for other on campus activities.
• Worked on audit scenarios and managed the entire schedule portfolio for order management.
• Supervised laboratory groups and advising in BI projects.
• Played a leadership role within the Business College and international business contests.
• Participated in activities designed for MBA students within the college.
• Project management learnings and strategic initiatives.

Confidential, MI

Project Lead

Responsibilities:

• Requirement gathering from the business and stakeholders and converting them in the HLD, LLD and planned for the roll out of the changes in the Dev, UAT and Prod environment.
• Build and maintained the project schedule and tracked complete audit requirements.
• Took part in all the phases of the project including design, development, testing, migration phases across different environments.
• Worked on quality and process documents and their approval processes and version maintenance process.
• Coordinated the meetings and discussions with Informatica team about the different versioning tool and best practices for methodologies and best practices across business and IT.
• Performance tuning of ETL jobs and analyzing log files for production and other testing issues.
• Approving RFCs, RFRs, managing the release, phased releases and maintaining the system stability.

Environment: Informatica 8.1.1, SQL, TOAD, ASP .Net, CFMX, Oracle 10g, WebFOCUS, Remedy 4.0, MS Office, MS Project

Confidential

Project Leader

Responsibilities:

• Led and managed the Project, implemented project strategy and business plan.
• Reviewed the current BI and ETL system including Informatica power center, existing application and database architecture and gathered business process understanding.
• Completed the end to end analysis of the performance issues in the current ETL/Informatica system.
• Analyzed the different report performances issues in different service modules.
• Worked on documentation of the potential bottlenecks for the report generation process.
• Analyzed the MDX queries, Cube calculation design, and database structures of the existing system.

Environment: SSRS, SSIS, Informatica 7.1, SQL, TOAD, ASP .Net, Oracle 10g, Remedy 4.0, MS Project

Confidential, Mason, OH

Technical Lead

Responsibilities:

• Interface between two or more clients for data file exchange between PBM and RHI for the benefits, Formulary and Opt-in/Opt-Out extracts.
• Took part in all the phases of the project including design, development, testing, migration phases across different environments.
• Worked on creating various jobs using Informatica and Datastage designers to extract, transform and load in to the enterprise data warehouse.
• Used the complete Informatica for the entire project for the data quality, management, migration.

Environment: Informatica Power Centre 8.1/7.1 and Power Exchange, IDE and IDQ, Datastage 8.1, Toad 9.0, UNIX, Oracle, Oracle based MDM Schema, Teradata, Hummingbird (FTP), SSIS, SSAS, Perl, Workload Manager (WLM), Service Centre client, Clear Case, MS Project

Confidential, Mason, OH

Technical Lead

Responsibilities:

• Managed the complete project from requirement gathering to transition phase.
• Worked with the project management team with PO Scores etc.
• Validation of WPSRs, Run rate track sheet for the entire on site and off shore team.
• Created the aggregation designs and cube partitions for better performances.
• Worked on all the consoles of Informatica and Datastage consoles for development and migration.
• Modifications of already existing control cards, jcls, FTP cards to suffice the mainframe requirements.
• Worked on the Cube structures, Dimensions, calculations and KPI’s.
• Co-coordinated the different fix, correction of bugs and errors for successful migration and implementation.

Environment: Informatica Power Centre 8.1/7.1 and Power Exchange, IDE and IDQ, Datastage 8.1, Toad 9.0, UNIX, Oracle, Oracle based MDM Schema, Teradata, Hummingbird (FTP), SSIS, SSAS, Perl, Workload Manager (WLM), Service Centre client, Clear Case, MS Project

Confidential, Mason, OH

Technical Lead

Responsibilities:

• Data file exchanges per different vendors per their customized layouts.
• Took part in all the phases of the project including design, development, testing, migration phases across different environments.
• Worked with different medical and pharmacy clients like UHC, Humana, Aetna and BCBS of different states.
• Played support role for different prod and UAT issues.
• Used a lot of Informatica and Data stage schedulers to execute parallel jobs as the application was near real time and multiple jobs had to run multiple times in a day.
• Analysis of different eligibility issues for OOP and DED medical and pharmacy amounts per member.
• Analysis with regards to different processes including daily, weekly and monthly file exchanges.

Environment: Informatica Power Centre 8.1/7.1 and Power Exchange, IDE and IDQ, Datastage 8.1, Toad 9.0, UNIX, Oracle, Oracle based MDM Schema, Teradata, Hummingbird (FTP), SSIS, SSAS, Perl, Workload Manager (WLM), Service Centre client, Clear Case, MS Project

Confidential, CA

Software Engineer

Responsibilities:

• Worked on complete SDLC from Extraction, Transformation and Loading of data using Informatica.
• Involved in the analysis, design and development of all the interface’s using Informatica in interface team and interfaced with all the other tracks for business related issues.
• Worked on Power Center Designer tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Developed Informatica mappings, re-usable transformations, re-usable mappings and Mapplet for data load to data warehouse and database (oracle)
• Multi source Extraction Transformation and loading into the Repository using Informatica.

Environment: Informatica Power Center 6.1, Perl, Unix, Oracle 9i, Nortel-VPN connectivity, MS Office Suite, Peregrine Service Centre, Windows 2000

Confidential, Hopkinton, MA

Senior Analyst

Responsibilities:

• Involved in the support of web based application CCA5 in conjunction with Clarify 10.1, which was on a roll out phase in several west coast (USA) region including Denmark & Australia.
• CCA5 assists was not just the implementation of a solution, but rather with the entire lifecycle of a solution from the Design phase through the implementation phase.
• Analysis of the application performance including various testing. Includes complete reporting and documentation.
• Change Control Application used by the customer engineers for storing and sharing of customer environmental information of several EMC manufactured products.

Environment: Clarify 9.0, Peregrine Enterprise Service Centre; Web based CC Apps, C, HTML, Perl, UNIX, MS Office Suite, and Windows 2000

Confidential, Westborough, MA

Senior Analyst

Responsibilities:

• Administrative level support of Clarify tool and other inter-linked applications.
• Coordinated phased roll out, modifications.
• Worked with all its related applications like WebEx, net agent and power link.
• Was the backup SPOC of 6 member team and worked on Onsite/Offshore model.
• Used to attend the weekly conference call with the client.
• Did complete requirement gathering and analysis for the two phased approaches.

Environment: Clarify 9.0, Peregrine Enterprise Service Centre, C, HTML, Citrix-Meta frame connectivity, PeopleSoft I care 2.1, Windows 2000

Confidential

Technical Support Engineer

Responsibilities:

• Administrative level support of corporate application and other sales applications.
• Completed phased support functions and beta testing.
• Worked on data management issues and worked with the business team to understand new changes.
• Worked on internal change control applications.

Environment: PeopleSoft I care 2.1, Peregrine Enterprise Service Centre, C, HTML, Citrix-Meta frame, Windows 2000