We provide IT Staff Augmentation Services!

Data Analyst Resume

Boston, MA

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 PROFICIENCY:

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 in corporate 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 assisting in 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

Confidential, Bloomfield, CT

Data Analyst

Responsibilities:

  • Involved in requirement gathering along with the Business Analysts Group.
  • Involved in Object Modeling in UML using Rational Rose 2000
  • Gathered all Sales Analysis report prototypes from business analysts belonging to different Business units
  • Gathered various requirement matrices from the business analysts
  • Participated in Joint Application Development (JAD) sessions
  • Conducted Design discussions and meetings to come out with the appropriate Data Mart designed for the various reporting requirements
  • Conducted Design reviews with the business analysts, content developers and DBAs.
  • Designed different type of STAR schemas like detailed data marts and Plan data marts
  • Monthly Summary data marts, Inventory data marts using Erwin with various Dimensions (Time, Services, Customers, Sales Hierarchy, Orders, Snow flake Dimensions and FACT Tables)
  • Designed Sales Hierarchy dimensions to handle sales hierarchy reporting historically and dynamically.
  • Worked with the Implementation team to ensure a smooth transition from design to implementation phase.
  • Performed Data Loading and Transformation using SQL* Loader.

Environment: SQL Server 2005, Windows NT, Erwin 4.0, MS-DTS, SQL Loader, Data Junction, Rational Rose 2005

Hire Now