INFORMATION TECHNOLOGY PROFESSIONAL

• Over 10 years of strong track record in Information Technology and Business results in Banking Finance, Retail, Healthcare, Energy Manufacturing Sector work with extensive experience in leading global cross-functional teams within Confidential to manage complex projects and client expectations with discipline and efficiency. Offer a blend of management and technical expertise to align business strategy to identify new opportunities and position organizations competitively.
• Focused Analysis of Development, Testing and Production Implementation Processes.
• Aligning business requirements Scope, Change, Release and Risk Management
• Spearheaded Quality Planning, Assurance Control methodologies
• Strong analytical skills coupled with techno-functional background. Quick Learner and Excellent Confidential

EXPERIENCE 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.

Technology Experience

BUSINESS CONTRIBUTIONS

Confidential

Project Manager

Project Description: This project involves the development and maintenance of multiple set of intelligent reporting modules for web and mobility environments including smart phones and tablets as well. Data visualization, reporting and mining is been done using top industry tools including OBIEE and Informatica.

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.
• Working on highly technical and mobile reporting requirements including data landing patterns in database, movement, information and presentation layer design for various applications.
• Reviews and approves user stories in preparation for the upcoming iteration.
• 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.
• Collaborate with business SMEs, developers and testing teams to finalize the acceptance criteria.
• 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.
• Track and maintain projects planning in Planview throughout the lifecycle phases.
• Creates and maintains product backlog and sequence it for business value and ROI.
• 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

Confidential

Graduate Assistant

• 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

Project Lead

Project Description: This project involved the development and maintenance of the Corporate Applications and their maintenance. Worked on new projects, enhancement requests and change request from the business, stakeholders and customers all across the globe with regards to corporate applications.

Responsibilities:

• Create the business model and the product roadmap including user experience and product features.
• 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

Project Description: This project involved a thorough analysis of the current Confidential system in place at the client side. Implemented changes for improvement and created recommendations for better system performance for next phase.

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

Technical Lead

Project Description: Confidential -Data Integration Project - resulted in creation and maintenance of the data extraction processes between Confidential and one of the new company which was acquired by it Confidential. All the processes were created to send the Pharmacy data based on different requirements to the client in the Flat File structures.

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

Technical Lead

Project Description: Confidential - project involved two separate requests, one was to modify the existing Confidential file layouts to ensure that correct Confidential numbers are populated and the same is being transmitted to the several downstream systems. It also had a request for table change and modification request to clean up the data and provide correct data based on Confidential number crosswalk.

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

Technical Lead

Project Description: Confidential - This project involved Confidential six medical provider Confidential and Confidential division for the data exchange processes. It involved a lot of data validation, checks and balances, claim, adjudication process and reconciliation processes.

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

Project Description: Confidential This project for a Multi-national bank involved setting up ETL processes between different source and target systems from Confidential and setting update tasks.

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

Software Engineer

Project Description: Confidential Corporate application was created for data integration processes between different portfolios and layers in the organization level and different business units.

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

Senior Analyst

Project Description: Confidential - This project was done for the change control application migration from an earlier version to a new version. It involved a lot of performance issue checks, new application functionality testing, and process flow migration and creation.

Responsibilities:

• Involved in the support of web based application Confidential in conjunction with Confidential, which was on a roll out phase in several west coast Confidential region including Confidential.
• Confidential 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

Senior Analyst

Project Description: Confidential -This project was undertaken for the Change control version 3 applications, it involved a lot of data flow issues between change control and Clarify application. It also involved the data flow issues and process changes between change control and external customer sites.

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