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 Projects based on Waterfall and Agile methodologies and stand responsible for product success
• 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.
• Lead backlog refinement, iteration planning, just in time story elaboration, and accepting stories in to baseline along with team participating in team demo and retrospective analysis.
• Excellent problem solving skills with strong technical background and good interpersonal skills. Quick learner with ability to meet deadline & work under pressure.

TECHNICAL SKILLS

SDLC Model Framework: Agile/Scrum, Waterfall, Kanban

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

Operating System: 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:

• Prioritize the projects and iterations/releases based on the product backlog, apply 80/20 rule wherever possible.
• Analyze impacts to business process and alerts all stakeholders of any upcoming impacts leveraging Agile.
• Partner with BA and Business partners to ensure backlog/story cards are being managed effectively.
• Reviews and approves user stories in preparation for the upcoming iteration.
• In corporate changing and late requirements, harness change with Agile for customer’s competitive advantage
• Onboarding new resources, allocations, defining resources and schedule for project implementation
• Participates proactively in developing and maintaining team standards, tools and best practices.
• Collaborate with business SMEs, developers and testing teams to finalize the acceptance criteria.
• Ensure iteration-based meetings are effectively facilitated, the outcomes are achieved and their scope is maintained.
• Track and maintain projects planning in Planview throughout the lifecycle phases.
• Creates and maintains product backlog and sequence it for business value and ROI following Agile.
• Works with Development team to answer for high-level estimations, business objectives, stories and priorities.
• Contributes to vision and program backlog including team backlog and all implementations.
• Analyze the course of the project after every sprint and participate in team demo and retrospect.

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.
• Inspect the product progress at the end of every sprint and accordingly approves/reject the work done.
• 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 using Agile methodology
• 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.
• Set the sprint goals, detail stories, collect and analyze data to validate the goal.
• 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.
• Elaborate themes and features into user stories to a granular level for a single sprint.
• 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

Consultant

Confidential

Responsibilities:

• Worked extensively with Business Analysts for different front office, back office tasks and processes.
• Involved in regression testing across UAT and dev. environment to recreate the issues for simulation.
• Worked on complete table structure and complete application design from initial file load to Informatica and then to data base through UI display process.
• Analysis of Mappings & flat files from several source systems like Winfits, Impact, Kapital, IRFE etc.
• Created and Scheduled Sessions based on demand, run on time, run only once using Informatica work flow Manager, for regression testing.
• Coordinated with middle office in finding the issues with sources and different set of reports.
• Used the Subversion/Tortoise SVN tool as a part of Source code control process.

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