SUMMARY OF SKILLS

• 9 years of professional experience in Information Technology industry. In-depth, hands-on knowledge of Business Analysis, ETL, Data warehousing / Business Intelligence and software methodologies.
• Extensively experienced in gathering, documenting and managing Business and Functional requirements in Banking and Healthcare domain.
• Worked as a Techno-Functional resource with a strong knowledge of Banking domain, SWIFT messaging system and Healthcare Insurance domain.
• Worked on Facets a product for Healthcare Insurance sector.
• Worked on Global PAYplus a product for transferring the funds globally.
• Experienced in designing and generation of Reports and Dashboards using Informatica PowerAnalyzer Data Analyzer and Business Objects.
• Good exposure to data analysis, design, development and testing of data warehousing applications.
• Extensive experience in Dimensional Data Modeling using Star/Snowflake schema, Fact and Dimensions tables, and Physical Logical data modeling.
• Extensive experience in dissemination of work and coordinating with offshore resources to produce quality work within aggressive deadlines.

TECHNICAL SKILLS

FUNCTIONAL SKILLS

• Knowledge of Healthcare Insurance sector.
• Knowledge of HIPAA EDI Standards.
• Knowledge of Payment Systems.
• Knowledge of SWIFT messaging system for Funds Transfer.
• Payment Messages Customer Payments/FI Transfers
• Cash Management Messages and Statements
• System Messages

PROFESSIONAL EXPERIENCE

Confidential

SR Lead BSA/ETL Dwh

Responsibilities:

• Acted as BSA Lead managing offshore team in gathering requirements for ERIC Employment resource Information center
• Acted as Tech Lead for some specific healthcare related integrated projects dealing with compensations and extensively worked on agile scrum environment and documented functional and nonfunctional requirements and Creating application Prototypes and screen mock-ups
• Acted as Tech Lead and involved in managing teams dealing extensively in RAD Sessions Black Box testing and creating functional specifications, used Visio to draw flowcharts and swim lane diagrams and also having experience transforming business requirements into conceptual and logical data models
• Experience in facilitating workshops for requirements gathering and also having experience and involved in Business process reengineering and experience in using VISIO, MS office
• Exclusively involved in developing automation scripts for integrated ERIC software applications dealing with high volumes of data and worked in agile scrum model.
• Assessed the flaws in the existing as-is system and directly with end-users to define requirements and provide technical advice and assistance in a large-scale environment, BPR, incorporated them in the future to-be system design and performed Data mapping and configured Datamarts.
• Set up batches and sessions to schedule the loads at required frequency using Power Center Workflow manager and accessing Mainframe DB2, performed COBOL coding and AS400 systems.
• Acted in coordinating Informatica power center and power exchange and Data conversion using tool similar to Gateway and Data migration process using Toad and also used Informatica data quality for cleansing purposes and also used Tableau and Qlikview for visualization.
• Used Informatica power center Workflow Manager to create, schedule, execute and monitor sessions, work lets and workflows accessed information using Mainframe DB2 written Cobol Coding and have good experience with complex Sql queries.
• Created List Reports, Crosstab Reports, Drill through Reports and multidimensional Reports with cascading prompts using Cognos 8.3 Report Studio
• Trained end users to use Query Studio by performing Data mapping of sources and targets for Healthcare modules
• Conducted JAD sessions involving the user community to identify, analyze and formalize requirements and establish working relationships with business functions and solution delivery teams to meet the individual needs of the business functions. Involved in the complete SDLC and handled key responsibilities in Project Management.
• Extensively used Informatica debugger to validate Mappings and to gain troubleshooting Information about data and error conditions and also participated in file admin tasks.
• Designed, developed Informatica mappings using Informatica 9.1, enabling the extract, transport and loading of the data into target tables and loading into the Teradata
• Created mappings to perform the tasks such as cleaning the data and populate that into staging tables, Populating the Enterprise Data Warehouse by transforming the data into business needs Populating the Data Mart with only required information modulated from Hadoop applications
• Modified Experience creating workflows using formal notation such as BPMN
• Acted as Data Modeler and Implemented Slowly Changing Dimensions as per the requirements and experience designing Business Process Modeling Notation.
• Developed UML Use Cases for the application using Rational Rose and prepared the detailed work flow diagram based on the proposed enhancement for the system and MS SharePoint for documentation control and have good experience with Sql queries.
• Created Dashboards using Crystal X-Celsius for senior management for business decision-
• Making for BO Mobile interfaces.
• Performed Server Management Tasks, using Central Configuration Manager CCM and Central
• Management Console CMC , worked in Unix and windows.
• Worked on SAP BI reporting which involves Query building, Filtering, Free Characteristics,
• Restricted Key Figures and Variables, Query variants using BEx Analyzer.
• Extensively worked on BO XI 3.1 for reporting purposes.
• Involved in Adhoc query development and data mining.
• Extensively worked in INFOVIEW to create Web Intelligence, Desk Intelligence Reports over
• the Universe Created
• Lead the project team's planning efforts, worked in Agile scrum environment
• To analyze and resolve the ongoing issues with the Data Warehouse and the upstream and downstream applications.

Environment: .Net, Cognos, Quality center 10.0, MS-Project, MS-Office, Informatica, Java, PL/SQL, Microsoft SQL Server, HTML, XML, Linux, Web Logic.

Confidential

SR Business system Analyst/Guide wire Claim center and Policy/P C

Responsibilities:

• Analyzed and documented the Business Requirements, ensuring that the requirement statements are complete, traceable, and unambiguous and that they conform to standards and followed rational unified process RUP with agile scrum model.
• Getting a formal sign-off from the Business Users and Stakeholders for Guide-wire Claims center and policy configuration integration project dealing with PeopleSoft and Creating application Prototypes and screen mock-ups and experience in using VISIO, MS office
• Participated in requirements prioritization and acted as Project lead for 4 offshore resources.
• Established delivery milestones and worked in Agile for Siebel based claims transformation applications dealing with Guide wire policies and documented functional and nonfunctional requirements and have good experience with Sql Queries.
• Conducted JAD sessions involving the user community to identify, analyze and formalize requirements and establish working relationships with business functions and solution delivery teams to meet the individual needs of the business functions and worked in agile scrum model.
• Managed the development and QA resources used Visio to draw flowcharts and swim lane diagrams translating customer needs into formal business requirements and performed Guide wire configuration in Policy center apps developed in Visual basic Vb
• Worked as BI analyst in mapping the source tables with the target tables and creating graphical representations of complex business processes for Property Causality modules.
• Have a good Experience creating workflows using formal notation such as BPMN
• Drafted the Technical Solutions related to Business Objects development and also used Tableau and Qlikview for visualization.
• Assist with user testing of systems, developing and maintaining quality procedures, and ensuring that appropriate documentation is in place for Guide wire configuration and billing center applications and also having experience in Policy handling and Policy administration.
• Responsible for Content Management for the developed portal, Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams
• Involved in Design phase and Developed Logical Model and Physical Model of EPM.
• Developed centralized schema console using Business Analytics warehouse BAW , wrote analytical queries.
• Co-ordinated with the offshore delivery team for the releases.

Environment: Guide wire, .Net, Business Objects XI R2, Informatica Power Center 7.1, Java, Oracle 9i, Peregrine Service Center, Win XP, UNIX, PeopleSoft

Confidential

Business system data analyst with ETL DWH

Responsibilities:

• Setting up the offshore development and testing environment, Created Extensive designs and Data models using Erwin and ER Studio, incorporated data models into Code.
• Translated business requirements into test suites involving SFDC and purchase orders documents and experience designing user stake holder requirements.
• Reviewed and analyzed the Functional and Interface Requirement Documents for Citibank Swift applications and worked extensively in Fixed Income, Securities, Derivatives, Equities etc.
• Setting up the offshore development and testing environment, Created Extensive designs and Data models using Erwin and ER Studio, incorporated data models into Code.
• Reviewed and analyzed the Functional and Interface Requirement Documents for Guide wire policy handling and Policy administration.
• Translated business requirements into test suites involving SFDC and purchase orders documents and experience designing data models for Guide wire modules for claims and policies and have good experience with Sql Queries
• Interacted with business community and gathered requirements based on changing needs and created Guide wire rule sets developed in Visual basic Vb
• Developed a standard Guide wire framework to enable the reusability of similar logic across the board. Involved in System Documentation of Dataflow and methodology for Policy Data modules running in Trading, sales and Marketting
• Identified all the dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables, accessed AS400 mainframe systems.
• Coordinated with the admin team to get required user access, installation, set up done for the new users and created detailed Guide wire data models
• Checked performance tuning/debugging at different levels like workflows, mappings, database etc. And documented using Microsoft office, performed shell scripting.
• Created detailed technical specifications for P C Modules
• Performed Configuration Management to Migrate data from Guide wire platforms

Environment: Guide wire, Java, XML, VB, Java Script, Oracle8i, Tomcat Web Server, MTS, Tuxedo, Integra, Mercury Test Director, MQ Series, and Win NT/2000/Unix.

Confidential

SR Healthcare Business system Analyst with ETL

• Acted as business system analyst and Based on the requirements created Functional design documents and Technical design specification documents for ETL Process.
• Acted as business system analyst and Designed, developed Informatica mappings, enabling the extract, transport and loading of the data into target tables for Trizetto facets
• Created Workflow, Work lets and Tasks to schedule the loads at required frequency using Workflow Manager and documented functional and non-functional requirements
• Designed and developed Informatica mappings for data loads and data cleansing and experience in using VISIO, MS office and worked in agile scrum model.
• Created complex mappings using Aggregator, Expression, Joiner transformations.
• Designed and developed process to handle high volumes of data and high volumes of data loading in a given load intervals.
• Performed Gap Analysis for new functionality requirements for Facets and Medicare claims, as well as prioritized them based on actual business needs so as to align them with the product release roadmap.
• Involved in writing use cases for Trizetto facets model and other design documents like Data Flow diagrams, and Activity diagrams for better understanding of the system.
• Drew process flow diagrams, uses cases, Functional hierarchy diagram, activity diagrams, class diagrams and other diagrams using the System architect.
• Conducted workshops with ORACLE design and developmental team to determine how CTRM will be configured
• Designed and implemented mappings using SCD and CDC methodologies.
• Designed and developed process to handle high volumes of data and large volumes of data loading in a given load window.
• Extensively involved in migration of ETL environment, Informatica, Database objects.
• Involved in splitting of Enter price data warehouse environment and Informatica environment in to 3 of each company.
• Involved in jobs scheduling, monitoring and production support in a 24/7 environment.

Environment: Informatica Power Center 7.1.1, Teradata V2R6, Micro Strategy, MS Sql server 2000, Oracle 10g, 9i/8i,Trillium, HP Unix, Perl scripting and Windows 2000, Erwin 4.2,

Confidential

SR Business Systems Analyst/ETL Dwh

Responsibilities:

• To gather the requirements from the Business users across various groups - Membership, Billing, Claims, Sales marketing, HIPAA and Underwriting of Facets applications
• To perform Gap Analysis on the existing system with an idea of figuring out the necessary mapping steps towards the new Target system used Visio to draw flowcharts and swim lane diagrams and worked on Medicaid / MMIS and documented functional and non-functional requirements and Creating application Prototypes and screen mock-ups
• To draft the Physical Data Mapping document for the data flow from Facets to the data warehouse and developed requirement traceability matrix and Creating graphical representations of complex business processes and experience in using VISIO, MS office
• To work in the Scrum team and participate in backlog review and sprint planning sessions while following the agile methodology and also used Visio for drawing diagrams.
• To assist the Developer, while working in the agile team, in terms of the BOE Universes and reports and also having experience with Microsoft team foundation server.
• To assist in Project Management activities like effort estimation, task allocation, issue resolution and to hold post-launch review meetings to revisit the project.
• Wrote stored procedures in PL/SQL and Unix Shell Scripts for automated execution of jobs
• Wrote Shell Scripting for Informatica Pre-Session, Post-Session Scripts.
• Designed technical layout considering Standardization, Reusability, and Scope to improve if need be.
• Used live office and QaaWS to give visualizations live data connectivity.
• Creating reports using Crystal Reports with BO universe as Data source
• Created users/groups and defined privileges using Central Management Console.
• Documented the purpose of Data Warehouse including transformations, mapplets, mappings, sessions, and batches so as to facilitate the personnel to understand the process and incorporate the changes as when necessary.
• Developed complex mappings to extract source data from heterogeneous databases Tera- Data, SQL Server Oracle and flat files, applied proper transformation rules and loaded in to Data Warehouse.
• Involved in identifying bugs in existing mappings by analyzing data flow, evaluating transformations using Debugger.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Worked closely with Production Control team to schedule shell scripts, Informatica workflows and pl/sql code in Auto-sys.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Defects were tracked, reviewed and analyzed.

Environment: Facets Trizetto 4.31/4.61, Clinical CareAdvance Trizetto , Business Objects XI R2, DataStage, ERwin, Mainframe, ClearQuest, Remedy, SQL Navigator, SQL Advantage, Toad, Oracle 10g, Sybase.

Confidential

ETL Cognos BI Analyst

Responsibilities:

• Performed Gap Analysis for this supply chain CRM model project with new functionality requirements as well as prioritized them based on actual business needs so as to align them with the product release roadmap and experience in using VISIO, MS office
• Conducted JAD sessions involving the user community to identify, analyze and formalize requirements and establish working relationships with business functions and solution delivery teams to meet the individual needs of the business functions
• Analyzed ETL and Report requirements and prepared BRDs, designed patterns in Agile based environment using Cognos report net for HIPAA applications and Creating graphical representations of complex business processes
• Involved in developing mapping document indicating the source tables, transformation required, business rules, and target table's columns and data types, loading strategies
• Analyzed complex ETL requirements/tasks and provided estimates/ETCs and researched Oracle data using Oracle warehouse builder used Visio to draw flowcharts and swim lane diagrams.
• Created mappings to perform the tasks such as cleaning the data and populate that into staging tables, Populating the Enterprise Data Warehouse by transforming the data into business needs Populating the Data Mart with only required information and documented functional and non-functional requirements
• Created reusable transformations to clean the data, which were used in several mappings.
• Worked on power exchange to create data maps, pull the data from mainframe, and transfer into staging area and created reports using Cognos Report Net.
• Created Scripts using Teradata utilities Fast load, Multi load, Fast export
• Modified BTEQ scripts to load data from Teradata Staging area to Teradata data mart
• Implemented Slowly Changing Dimensions as per the requirements and experience designing Business Process Modeling Notation.
• Responsible for monitoring scheduled, running, completed and failed sessions. Involved in debugging the failed mappings and developing error-handling methods.
• Worked with Informatica Administrator to setup project folders in development, test and production environments and also worked with Microsoft SharePoint
• Developed Test plans and test cases based on functional specifications.
• Analyzed the session and error logs for troubleshooting the Data Loading process.
• Developed the reports and dashboards and experience working with Documentum.
• Provided support for the business users and created cubes using Cognos report studio.
• Point of Contact for Enhancement and Defect Change Requests.
• Kept track of scheduled environment refreshes and coordinate/communicate with Dev, Ops, and Analysts.

Environment: Informatica Power Center 7.1, Cognos, Rational Requisite Pro, Oracle 9i, Win2k.

Confidential

Banking Business Analyst/Financials/Dwh

Responsibilities:

• Interacted with Business Users and stakeholders to gather the requirements and Creating application Prototypes and screen mock-ups and experience in using VISIO, MS office
• Gap analysis of all dimensions required to build the new Data Warehouse and worked extensively in Fixed Income, Securities, Derivatives, Equities etc.
• Involved in developing mapping document indicating the source tables, transformation required, business rules, and target table's columns and data types for Data models dealing with Swift.
• Involved in documenting the business requirements and data specifications for Business Objects Universes and Reports and documented functional and non-functional requirements
• Conducted JAD sessions involving the user community to identify, analyze and formalize requirements and establish working relationships with business functions and solution delivery teams to meet the individual needs of the business functions
• Managed all the requirements in RequisitePro, making them available to the whole project team and also developed requirements traceability matrices
• Developed the workflows using Workflow Manager to run the sessions and monitor them using Workflow monitor and also used MS Project and Clarity and also experience with 21 CFR Part 11 Compliance and documented functional and non-functional requirements
• Developed the reports using features like drill capabilities, Functions, slice and dice, and cross tab tables with multiple breaks.
• Provided BO support for the business users and also worked with Documentum.
• Created Test Scenarios and developed strategies with QA team to track and resolve defects.
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse.
• Keep track of scheduled environment refreshes and coordinate/communicate with Dev, Ops, and Analysts and Creating graphical representations of complex business processes
• Offshore - onsite coordination with daily status updates and experience designing Business Process Modeling Notation.

Environment: Abinitio, Business Objects 6.5, Rational Requisite Pro, Oracle 9i, Win2K.