SUMMARY

• Over 7 yrs of experience in Database Design, Programming, Development & Implementation of Client - Server Applications & Database system using MSSQL 2012/2008.
• Experience in Installing and Configuring of Microsoft SQL Server and other Databases.
• Proficient in T-SQL and PL/SQL in constructing Tables, Normalization techniques on database Tables.
• Expert in creating and using Stored Procedures, Views, User Defined Functions.
• Strong experience in using Sub-Queries and Joins to create complex queries involving multiple tables and Exception Handlers.
• Excellent understanding of Relational Database Systems, Normalization, Logical/Physical Data Modeling and Data Warehousing.
• Strong knowledge of Data Warehouse methodologies, including, Star Schema, Snowflake Schema, Fact and Dimension tables, worked with high volume databases with partitioned data.
• Hands on experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Experienced in building Data Integration and Workflow solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Services. SSIS/(Infromatica)
• Excellent in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers.
• Highly experienced in Extracting, transforming and loading data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by Informatica/SSIS.
• Thorough knowledge in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages.
• Experienced in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard.
• Ability to prioritize and execute tasks in a high pressure environment. Effective time management skills and Resolution skills, and ability to meet deadlines.
• Experience in mentoring and providing knowledge transfer to team members, support teams and customers.
• Strong in Problem Analysis, Negotiation Skills and Leadership Skills. Excellent interpersonal, communication and presentation skills.
• Ability to interact and coordinate with internal stakeholders in the project - IT group, Business Analysts group, User Acceptance group, Operations group, Third party vendors, Change Management group and Production support group.
• Experience and excellent documentation skills in business requirements, functional specification, master documents and Process documentation using MS Office, MS Project and MS Visio and ability to work in multiplatform environments.
• Highly self-motivated, focused, quick learner, creative and team player with strong analytical thinking and problem solving skills.

TECHNICAL SKILLS

Operating Systems: Windows NT/XP/2003/2008/vista, windows server 2008R2/2012R2, UNIX, Linux

Languages: T-SQL, PL/SQL, HTML

Data Warehouse Tools: Business Intelligence Development Studio.

Databases: MS Access, MS SQL Server2008/2012, and Oracle 10g/11g

Tools: /Utility: Enterprise Manager, SQL Server Management Studio (SSMS), Informatica, SAS

Reporting Tools: Excel, SQL Server Reporting Services 2012,SSIS

Other Tools: MS Office, Visio, MS Excel, Erwin, Monarch, HPALM, Mainframe

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Data Analyst

Responsibilities:

• Performing preliminary business analysis of functional requirements to identify information, procedures, decision flows and/or corrective actions and assists clients in developing correction strategies.
• Created Functional specification Documents (FSD), Software Requirement Specifications (SRS), Use Cases, Flows, etc.
• Conduct JAD sessions with business to elicit the requirements.
• Reviewed the process and system implementation in mainframe application built with JCL.
• Created Business Requirement Documents (BRD) after identifying all the user requirements
• Identified business needs and analyzed gap between the need and capabilities.
• Involve in various gap analysis and mapping regarding data conversion.
• Involved with the team to design and development of programs and jobs using JCL.
• Working in a collaborative manner with the Business Account Manager (BAM) to define technical requirements, as well as the business and ETL rules for data population/transformations
• Experience in using SAS to read, write, import and export to another data file formats, including delimited files, Microsoft Excel, PDF and MS Access tables.
• Generate the profiling of data using IDQ (Informatica Data Quality Center) and analyze them as per requirement.
• Use SSIS packages to extract, map and generates data reports from different databases with heterogeneous sources.
• Developed SQL and PL/SQL codes for various procedures, functions, and packages to implement the business logics in an Oracle database.
• Created, modified/Updates SAS code to incorporate changes in new releases of the product.
• Produced ad hoc reports in SAS using .txt files upon request for in-depth analysis .
• Served as business liaison between business areas, senior leadership, IT development and support teams.
• Reviewed business & user requirements, system requirements and technical design specifications.
• Worked extensively on MS VISIO and other MS SUITE tools in creating the process flow and data flow diagrams.
• Define and document interfaces of manual to automated operations within application subsystems, to external systems, and between new and existing systems
• Support Defect Management process, using a defect triage approach, for both integration and UAT.
• Ensure that any decisions made regarding requests for change and outstanding items are appropriately tracked and documented within deliverables and provide regular project status updates
• Design the process working with both SOA services and SQL developers to ensure seamless conversion.
• Experience in SAS to extract data from a variety of operational data sources on multiple platforms, and build a data warehouse and data marts that integrate the extracted data.
• Involved in GAP analysis through various project phases.
• Generated daily, weekly and monthly reports using PROC REPORT via SAS and SQL .
• Created use case diagram using UML and managed the entire functional requirements lifecycle using AGILE.
• Development of source data profiling and analysis, reviewed the data content and metadata would facilitate data mapping and validate assumptions that were made in the business requirements
• Ensure the data consistency by cross-checking sampled data upon migration between the database environments.
• Develop a process to extract the source data and load it into the flat files after cleansing, transforms and integrating.

Environment: Oracle 11g, MSSQL 2014, Windows 10, MS Visio, HPALM, SAS, IDQ, Informatica, BI studio, Mainframe

Confidential, Maryland

Operation Data Analyst

Responsibilities:

• Perform analysis on enterprise data/report integration and provided functional specification to development team to build Enterprise Reporting Systems.
• Design process working with both SOA Services and SQL developers to ensure seamless conversion.
• Use various SSIS tasks such as Conditional Split, Derived Column before loading the data into the data warehouse.
• Building and maintaining strong relationships with Business and external customers.
• Analyze and research data quality issues and drive them to resolution with external partners & customers.
• Interacting with business and IT teams to identify long term solutions to data quality issues.
• Assist in issue/problem management activities, which could include researching issues and assistingin root cause analysis.
• Provide guidance and issue resolution on testing plan, provide timely & accurate data quality reconciliation reports to customers.
• Represent NGS on calls with our Partners and customers as the technical expert.
• Working with the front end and back end of financial systems, mostly worked with virtual teams which include business analyst, QA and developers.
• Use SSIS as an ETL tool to load data from flat files/XML files databases into SQL Server.
• Working with Health Care Information Systems EMR model to develop proposed workflow
• Use MIDAS(Multidimensional Insurance Data Analytics System) for the Affordable Care Act (ACA) which handles the data reporting and analytics.
• Conduct Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers
• Actively involved in understanding business requirements, collecting data, performing data analysis and data migration as per the business need to maintain Data Warehouse/Data Mart.
• Work with the Business community, SMEs and Tech Leads gathering market segmentation requirements and data loading requirements.
• Validate and run numerous SSIS packages and SQL script according to operation’s ICD.
• Work on querying data and creating on-demand reports using EXCEL, Report Builder in SSRS reports and send the reports via email.
• Extract, generate and troubleshoot 820s DHS(remit advices) files which are out of balance, once they pass validation have sent to bank for distribution to issuers.
• Deal with different kind of errors (including store procedure, index and triggers) when processing enrollments or cash(EFTs and Checks) and fix them accordingly.
• Use BizTalk Services for payment processing which include EFTs and checks, business-to business interactions, real-time decision making, and reporting.
• Generate everyday report (Recon Report, Pre-cancellation Report, monthly invoices, delinquency notice) and send to the intended departments/destinations.

Environment: RUP, UAT, GAD (Gap Analysis Document), Cognos, SQL Server 2012, Windows Management Console, Remedy, Microsoft Office 2007 (Outlook, Word, Excel, Visio, Access), Microsoft SharePoint.

Data Analyst

Confidential, Detroit, MI

Responsibilities:

• Worked closely with the developers and testers to ensure requirements and functional designs are translate accurately into working technical designs and that test plans scripts serve customer needs.
• Supported ongoing production maintenance, including production support and cross-team communication.
• Improved data quality, by providing consistent codes and descriptions, flagging or even fixing bad data.
• Helped to restructure the data so that it delivers excellent query performance, even for complex analytic queries, without impacting the operational systems.
• Worked on relational Database Systems, Normalization, Logical/Physical Data Modeling and Data Warehousing
• Wide usage of Lookup Files while getting data from multiple sources and size of the data is limited with Data Mapping.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Developed data mapping documents between Legacy, Production, and User Interface Systems
• Responsible for designing and developing universes for development of reports using business object designer
• Created Activity Diagrams, Sequence Diagrams and ER Diagrams.
• Created Mock-up forms in MS word for better visualization and understanding of the software solution.
• Analyzed the test results from QA teams using Performance Studio Analysis to create various scenarios.
• Developed strategies with Quality Assurance group to implement Test Cases in Test manager for User Acceptance Testing.

Confidential, Milwaukee, WI

Data Analyst

Responsibilities:

• Played key role in System Development Life Cycle Process consisting of: Design and Gap Analysis, Business Requirements, Systems Requirements, Test Criteria, and Implementation to have the outputs of project dealt with the automation of correspondence directed to Insurance policy owners.
• Worked as a Data Analyst in order to gather requirements and reaching each and every deadline well ahead of the time line. Methods employed were in compliance with IIBA standards.
• Performed analysis on enterprise data/report integration & provided functional specification to development team to build Enterprise Reporting Systems.
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.
• Responsible for interacting with business Analysts and business partners to identify information needs for business requirements for Cognos Reports.
• Involved in Facets System implementation, Electronic Claims and Benefits configuration set-up testing, Inbound/Outbound Interfaces and Extensions, Load and extraction programs involving HIPPA 835 and proprietary format files and Reports development.
• Defined Functional Test Cases, documented, Executed test script in Facets system.
• Performing data mapping for the application, confirm and vacillating the requirement at time of testing.
• Worked on HIPAA Transactions and Code Sets Standards according to the test scenarios such as 837 health care claim transactions.
• Used knowledge of Health Care Information Systems EMR model to develop proposed workflow in MS Visio.
• Designed High level design, for New process, integrating with legacy and Facets
• Created and Redesigned new, existing reporting solution using IBM Cognos Frame Work Manager and IBM Cognos Report Studio to improve the performance of the reports.
• Extensively involved in data modeling.
• Researched the existing client processes and guided the team in aligning with the HIPAA rules and regulations for the systems for all the EDI transaction sets.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Tuned SQL queries using optimal indexing and analyzing tables. Used EXPLAIN PLAN to understand the execution path of the SQL queries.
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Perform Gap Analysis of the processes to identify and validate requirements.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Scheduled business object reports using Broadcast agent
• Involved in the testing phase right from the Unit testing to the User Acceptance testing.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project.
• Use Cases and other Process Flow Models were designed using Visio and Rational Rose.

Environment: RUP, UAT, GAD (Gap Analysis Document), Cognos, Microsoft Office 2003 Professional (Outlook, Word, Excel, Visio, Access), Microsoft SharePoint 2003.

Confidential, Washington DC

Data Analyst

Responsibilities:

• Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting a document that contains the essential business elements and detailed definitions.
• Performed extensive testing in Facets Subscriber/Member, tested Groups, Eligibility, and Enrollment and validated outbound 834 Extracts to different Vendors.
• Responsible for architecting integrated HIPAA, Medicare solutions, Facets.
• Working with clients to better understand their needs and present solutions using structured SDLC approach.
• Developed schemas for extraction, transaction, and loading (ETL) to expedite data integration between systems
• Development of conversion related documentation including data mapping documents and conversion strategy documents.
• Prepared the Functional Specification document for the existing Cognos Reports and provided transition to BO Report developers.
• Experience in data governance/ data stewardship business/systems analyst needed to work as part of a team on data governance and writing SQL queries.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Analyzed data and created class diagrams and ER diagrams for designing databases.
• Performed felid-by-field mapping of interface between parent EMR system and downstream system.
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
• Worked on technical knowledge specific to Cognos tools and the existing data model to other team members.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.

Environment: Java, J2EE technology, Windows, Liberty,UNIX / Oracle Platform, MS Visio, RUP, UAT, Rational Rose, Rational Clear Quest, Rational ClearCase, Rational requisite pro, rational test manager, Rational Robot.

Confidential, Pittsburg, PA

Data Analyst

Responsibilities:

• Involved as Developer for Commercial Business Group data Ware House.
• Development of source Data profiling and analysis - review of data content and metadata will facilitate data mapping, and validate assumptions that were made in the business requirements.
• Create Logical and Physical Design of Database and ER Diagrams for relational and dimensional database using Erwin.
• Extracted data from relational databases Oracle, and Flat Files.
• Developed Complex transformations, Mapplets using Informatica Power Center 8.6.1 to Extract, Transform and load data into Operational Data Store (ODS).
• Designed complex mappings using Source Qualifier, Joiners, Lookups (Connected & Unconnected), and Expression, Filters, Router, Aggregator, Sorter, Update Strategy, Stored procedure and Normalizer transformations.
• Managed writing test cases and test scenarios from requirement for newly added features and executing test scripts.
• Performed Data alignment and Data cleansing, debugger to test the mapping and fixed the bugs.
• Performed Data Validations using Microsoft SQL Server Management Studio 2008.
• Created sessions, sequential and concurrent sessions for proper execution of mappings in workflow manager.
• Responsible for daily verification that all scripts, downloads, and file copies were executed as planned, troubleshooting any steps that failed, and providing both immediate and long-term problem resolution.
• Used USPS Address Mapping System for correcting the Customer Address.
• Involved in System Integration Testing (SIT) and User Acceptance Testing (UAT).
• Created various reports using Business Objects Universe.

Environment: Informatica 8.6.1, Oracle, SQL Server 2005, RDBMS, Fast load, FTP, SFTP, Business objects universe.

Confidential, Irvine, CA

Data Analyst

Responsibilities:

• Gathered business requirements through interviews, surveys, prototyping and observing from account managers and UI (User Interface) of the existing Broker Portal system.
• Involved in preparing Logical and Physical Data Models and conducted controlled brain-storming sessions with project focus groups.
• Conducted JAD sessions with management, vendors, users and other stakeholders for open and pending issues to develop specifications.
• Defined the calculations based on the reporting needs and the source data available
• Identify source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Used Aggregator stages to sum the key performance indicators used in decision support system
• Worked with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering using ERWin
• Coordinated with corporate Enterprise Data Warehouse (EDW) effort for impact of conceptual enterprise data model (EDM) to production LDMs.
• Developed Data Migration and Cleansing rules for Integration Architecture (OLTP, ODS, DW)
• Developed data mapping documents between Legacy, Production, and User Interface Systems
• Created job schedules to automate the ETL process
• Enhanced the job properties for performance tuning
• Conducted User Acceptance Testing on the application - resolved issues from the participants, prepared and submitted Test Analysis Reports and participated in Product Readiness Review
• Finished the bulk of the domain data model
• Prepared the documentation of Data Acquisition and Interface System Design.

Environment: Windows NT 4.0, Oracle, SQL Server 2005, Erwin