PROFILE SUMMARY

• Over 9 years of experience in Business System/Data Analysis, Development, Administration and Support solutions.
• Strong understanding of RDBMS and Data warehousing concepts. Knowledge in Data mart development, ER Modeling and Data-Flow Modeling.
• Interacting with stakeholders, gathering requirements, rating them and assigning priorities to each of them.
• Documenting business processes and translating them to functional specifications.
• Expertise in gathering, analyzing and documenting business requirements, functional requirements, and data specifications for Business Objects Universes and Reports.
• Demonstrated proficiency in requirements gathering interview techniques, JAD sessions, questionnaires , requirements.
• Experienced BOBJ implementation to post-production support
• Expertise in dimensional data modeling, Star Schema Modeling, Snow Flake Modeling, fact and dimensional table design, physical and logical data modeling.
• Experienced in customization of war files into different Web Application Servers.
• Expertise in Development, Maintenance, Upgrade, Integration, Production Support and Re-engineering Projects.
• Good understanding of health care industry claims management process, Medicaid and Medicare Services and insurance sector.
• Expertise in designing Universes for Performance Management and Reporting needs.
• Experienced in developing Desktop Intelligence, Web Intelligence / Rich Client and Crystal Reports using different Data Sources.
• Good practical knowledge in understanding Medicare Concepts, detailed knowledge of the claims adjudication process within a healthcare payer and interacting with hospitals
• Extensive experience in creating Stored Procedures, Packages, Functions, Triggers, Materialized Views, Cursors and other database objects using SQL, PL/SQL.
• Experience in creating DDL, DML and Transaction queries in SQL.
• Experience in SQL Tuning/Performance tuning of SQL queries/stored procedures using partitioning, Explain Plan, SQL Trace.
• Server Intelligent Agent SIA ,Central Configuration Manager, Central Management Console, Business Objects Enterprise, BO Performance Management, Auditor, Crystal Reports, Crystal Xcelsuis, Query as a Web Service QaaWS , Voyager, Live Office, Dashboard Manager.
• SDLC- Software Development Life Cycle Methodology and ASAP Methodology
• Efficiently mapped business requirements and processes to technical solutions.
• Writing Use cases and producing Use Case Model, Analysis model, Behavior diagrams Sequence diagrams, Collaboration diagrams and Class diagrams based on UML Methodology and Business process flow diagrams using MS Visio.
• Conducted JAD Sessions and other formal and informal discovery sessions with users and customer IT personnel to identify requirements and develop design specifications for data warehouse projects and corresponding applications.
• Strong knowledge of Software Quality Assurance methodology
• Defining Test Cases, analyzing bugs, interaction with team members in fixing errors and User Acceptance Testing UAT .
• Using project management tools like MS-Project for status reporting and planning.
• Strong analytical and troubleshooting skills
• Ability to adapt to change in a fast-paced environment, be creative, and be able to balance multiple priorities simultaneously
• Formidable ability to coordinate multiple projects and meet deadlines under pressure
• Exceptional ability to inspire and communicate with both clients and team members to achieve and surpass project goals

PROFESSIONAL EXPERIENCE

Confidential

Business System Data Analyst

Responsibilities:

• Performed Gap analysis between Provider Redesign Project between Facets, ODS and EDW.
• Performed impact analysis of other enrollment processing systems to determine potential scope/impacts.
• Performed thorough analysis of the companion guides from each trading partners both Medicaid as well as Commercial clients and identified the changes that specific clients need.
• Documented and mapped the various CPT and ICD 9 and 10 codes with incoming claim messages.
• Mapped the data according to the client requirement.
• Worked on data profiling and data extraction for the extract files going out the door to Altegra.
• Once, Altegra comes back to us with issue, was involved in documentation and assignment of work to correct team/resource.
• Worked closely with Data Analyst folks to check/validate the issues defects and fix them to deliver to client then to Altegra and intern to CMS for reporting purposes.
• Worked on Data mapping, logical data modeling used SQL queries to filter data within the Oracle database tables.
• Manage alignment of business data requirements with the Data Management Infrastructure
• Has been a part of Creating Pharmacy Benefit Management PBM Mapping document.
• Prepared Requirement Traceability Matrix, Functional Specification, System Change Documents, Technical Specification Documents, As-is and To-be flows for the entire conversion process.
• Create Requirement Traceability Matrix RTM , Crosswalk, mapping documents for ETL process.
• Participated in ETL process to load the base table and to build aggregates incorporate business logic / Summarization .
• Participated in Data Analysis and Design and data mining with the Data analyst in defining data sources and required data content for the data warehouse component.
• Documented the dimensional models of ETL system, worked closely with ETL folks to code correctly.
• Worked with the commercial business owners as well as with the state representatives in process of gathering the requirements.
• After performing the thorough analysis, designed the new translator based on the specific requirement from the commercial and state clients.
• Performed System Testing for the X12 formatted data that gets translated to the flat file through translator.
• Assist with ETL development, documentation and testing.
• Worked/supported with post deployment and regression testing bridges.

Confidential

Data Analyst/Technical Analyst

Responsibilities:

• Involved in the entire SDLC of the project. Requirement Analysis, Design, Development, QA, UAT and Implementation.
• Was part of the requirements workshop and assisted in requirement gathering from the users and creation of BRD. Prepared the FBTR Functional, Business and Technical requirement document based on the BRD.
• Created BRD and FRD for Medicaid managed care requirements and documenting them.
• Gathered required business rules for data transformation
• Utilized Rational Unified Process RUP to configure and develop process, standards and procedures.
• Prepared the business requirement document BRD and system requirement document SRD .
• Responsible for checking member eligibility, provider enrollment, member enrollment for Medicaid and Medicare claims.
• Wrote FRDs for the defects and enhancements and got approval from business for the developers.
• Worked on Technical design documentation TDD of the claims processing system.
• Data modeled part of the warehouse tables and assisted designing the final conceptual, logical, physical model in ERWIN
• Documented the dimensional models of ETL system
• Worked with providers and Medicare or Medicaid entities to validate EDI transaction sets or Internet portals. This includes HIPAA 4010 837, 835, 270/271, and others.
• Support maintenance of database schema, tables, procedures and users/user access levels for each segment of database and modify existing databases and database management systems.
• Developed data quality test plans and manually executed ETL and BI test cases.
• Worked on electronic Medicaid eligibility verification system the Medicaid Medicare intermediary along with their roles in claim processing
• Coordinated with the developers and IT architects to design the interface of the new system according to the X12 270, 276, 278, 834, 837 I,P,D and 820 standards
• Work as part of a project team to coordinate database development and determine project scope and limitations. Review project requests describing database user needs to estimate time required to accomplish project.
• Used SQL to test various reports and ETL load jobs in development, QA and production environment
• Worked extensively with client gathering requirements to generate customized SQL reports.
• Performed extensive task which include Data Quality Analysis, Data lineage and Data Standardizations.
• Responsible for the full HIPAA compliance lifecycle from gap analysis, mapping, implementation and testing for processing of Medicaid Claims.
• As part of technical team that focuses on ensuring compliance to the data models, data standards and overall data architecture. Monitored compliance by conducting reviews of the project logical and physical data models.
• Performed Work Product Review WPR to ensure that the documentation was up to the standard and without any errors.
• Designed Universes on Teradata V2R5/V2R6 DB platform as per the technical requirements and applied the necessary object level, row level security.
• Written SQL queries for validation of ETL Reports from Source to Target system
• Implemented various joins including equijoin, outer-join, self-restricting joins. Defined cardinalities and resolved issues like loops by creating aliases and contexts to remove the cyclic dependencies.
• Created Classes Sub classes , Objects, Prompts and Predefined conditions and user defined objects and custom Hierarchies for drill down purposes.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for reporting purposes
• Developed ER diagrams and Physical Data-model along with the testing team so as to provide a clear understanding of the system under development and for reference of the testing tem
• Extracted data by running SQL queries, and analyzed financial and customer metadata that gets populated on the web application
• Extensively used ETL to load data from XML files, Flat files data also used import data
• Involved in report rationalization as part of the entire BI platform stabilization project.
• Analyzed, designed, built and tested reports while working directly with end-users.
• Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters as per the business rules and the requirements of the end users.
• Designed the Unit test cases required for Unit testing before migration to the Testing Environment.
• Tested the Universe on various parameters such as Database Connectivity, loops and Contexts, object mapping, aggregate awareness. Tested the report data against the database.
• Performed Production support activities to the users throughout the Production cycle.
• Performed the support activities during the cutover.

Confidential

Business Data Analyst

Responsibilities:

• Interacted with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Utilized Rational Unified Process RUP to configure and develop process, standards and procedures.
• Prepared the business requirement document BRD and system requirement document SRD .
• Facilitated Provider Enrollment, Setting up Provider profile Trading Partner Agreement.
• Interacted with Users to know their Business views while gathering the Report requirements and provided Several Report Mock-ups to finalize th requirements.
• Converted business requirements in business/technical requirement documents.
• Used the Sql Server profiler tool to monitor the performance of SQL Server-particularly to analyze the performance of stored procedures.
• Involved in data warehouse testing by checking ETL procedures/mappings.
• Created and maintained SSIS packages designed for replication of data.
• Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for reporting purposes
• Designed Use Cases using UML and managed the entire functional requirements life cycle using RUP.
• Written Stored Procedures to display the data in front end application
• Did data analysis, created data mapping and data interface documents and kept the documents updated with changes in requirements and functional specifications.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
• Analyzing the change request and coordinating the changes required with the development team
• Writing SQL queries and matching the data with database and reports.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Generated Reports from Different Data Providers in Business Objects using a Normalized Schema Database.
• Involved in data warehouse testing by checking ETL procedures/mappings.
• Created Web Intelligence reports Ad-hoc and canned reports.
• Tuning the queries to improve the performance of the report refresh time.
• Identifying and Removing Bottlenecks in order to improve the performance of Dashboards and Reports.
• Worked closely with DBAs to create aggregate tables to support Universes and dashboard.
• Implemented Open Doc to drill down to detail webI report from Xcelsius Dashboard.
• Exported Xcelsius to repository to make it available for users through infoview.
• Migrated universes and reports from ST/UAT to production using Import wizard.
• Deployed configuration on all Development, Test, SIT, UAT and Production Environments.
• Expert level knowledge of complex T-SQL using Teradata functions, UDFs, macros and stored procedures.
• Used agile methods to promote a disciplined project management process that encourages frequent inspection and adaptation.
• Developed enhanced stored procedures in SQL Server 2005 to update its logic based upon the changing business environment.
• Implemented row level Security, object level Security at the Universe level for security purpose.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Tuning the queries to improve the performance of the report refresh time.
• Created customized Web Intelligence reports from various different sources of data.
• Created Derived Tables in the Universe using views and stored procedures to meet the Reporting Requirements.
• Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe.
• Worked closely with DBAs to create aggregate tables to support Universes and dashboard.
• Tested the aggregate awareness to ensure the query is pulling correct level of aggregation
• Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements.

Confidential

Business Data Analyst

Responsibilities:

• Performed Business Analysis and identified critical Metadata for key Business Divisions. Created Mapping Metadata documents. Created rules for Electronic cataloging of data via attribute extraction services.
• Extracted and analyzed data from existing data stores and performed ad hoc queries.
• Assisted in the design and implementation of new production and DB systems.
• Part of team that coded monthly Datamart scripts which extracted data from Third-Normal form Teradata table.
• Intensive use of SQL within the Teradata platform. Performed the Back-end testing manually by writing and executing SQL statements on Oracle Database in UNIX environment to query the database for Data validation, identifying, cleaning/scrubbing.
• Developed universes to accommodate complex database design approaches.
• Tuned and Enhanced Universes with SQL Queries for the Report Performance.
• Streamlined SQL generation from Universes by implementing Aggregate Aware functions and Variables.
• Created highly formatted reports to visually represent data..
• Collecting report Visual requirements from users/business owner.
• Enhanced the Performance of the Dashboards by manipulating and using complex formulas on the Universe and Excel.
• Worked in the Team closely with Functional Architect, DBA and Analysts to get a clear understanding on the Application.
• Created and modified views within Teradata for Business Analysts.
• Identified the usage of Indexes in Teradata at various situations as part of tuning.
• Collected statistics and used join indexes
• Prepared universe for Ad-hoc query functionality to educate users. Allowing them to run queries to create some reports using objects in the universe.
• Created Derived Tables in the Universe using views and stored procedures to meet the Reporting Requirements.

Confidential

Business Data Analyst

Responsibilities:

• Performed analysis and tracking of requirements and data specifications for Business Objects Universes and Reports.
• Perform data analysis activities to appropriately source and document new data points to be provided over interface with the team to create sample XML scenarios to provide to application delivery team DEV and QA with data reflective of planned data source new sourced data points .
• Performed Data mapping source to target- XML transactional database to Teradata and data profiling.
• Created Use Cases and Data Flow Diagrams in MS Visio
• Created PowerPoint Presentation for high lever overview of Projects.
• Conducted brainstorming sessions with several groups of stakeholders to the project, including Subject Matter Experts SME's , management groups and the IT group.
• Worked with the project manager to estimate best/worst case scenarios, track progress with weekly estimates of remaining work to do, conducted formal weekly meetings with the team.
• Responsible for the full HIPAA compliance lifecycle from gap analysis, mapping, implementation and testing for processing of Medicaid Claims
• Worked with SAP Business Objects developers and ETL team to ensure clear communications on requirements.
• Involved in ETL Process Validation for data completeness, data correctness and data transformations according to the requirements
• Reviewed and tested SQL codes for core reports and performed testing of adhoc BOBJ Universe.
• Created user manuals and Supported Business Objects' end-user in areas including software Designer, Reporting, Web Intelligence, and Publisher and running ad hoc/core reports.
• Performed Data Validation running SQL against new data source - Teradata, Integration and UAT Testing.
• Developed 100 adhoc reports using SAP Business Objects to test new BOBJ Universe to insure all joins, calculations, filters and mapping worked according to the requirements.
• Used SharePoint to share the documentation, setting up the security and creating workflows according to the requirements
• All work was documented Minutes of Meetings and approved via approval workflow in SharePoint to avoid miscommunicationConfidential

BO Consultant

Responsibilities:

• Gathering system requirements from Business Owners and Business Users.
• Interacted with Business Users to understand their specific Business needs for reporting for their daily business.
• Organized and conducted meetings with users both one to one and in groups are Risk Management, Loan Admin and Accounting.
• Understanding the banking domain with capital market.
• Understanding existing system and documented all the reports and Universes.
• Defined Business Views for crystal reports development.
• Created reports for different departments like Risk Management, Loan Admin and Accounting.
• Designed crystal reports with dynamic content Custom UI.
• Created Reports using all the BO functions like Drill Down, Prompts, Dimensional and Measure variables to show accurate Results.
• Scheduled crystal reports and Implemented dynamic cascading prompts.
• Installed and configured BCA for publishing the reports through emails and worked on BCA console.
• Created Analytics on top of Metrics for the Performance Manager.
• Involved in creating dashboards for management and able to perform drill down action to view more details on the report.
• Maintained Supervisor for administrative privileges with user accounts and access.
• Worked with team closely with Functional Architect, DBA and Analysts.
• Understanding Investors of all types have the opportunity to participate in financial strategies that can strengthen the general economy as well create financial security.
• Provided guidelines of Job scheduling process integrating Web Administrator and job scheduling process with job dependencies.
• Worked and maintained three systems: Development, UAT QA and Mock Production .