SUMMARY

• Database Analyst of experience on source to target mapping, gathering business requirements from business/user, creating source to target mapping document, creating process flows, and DFD.
• Collaborate with Enterprise Architects for identification and ingestion of Strategic Data Sources.
• Collaborate with business and technical stakeholders while defining solutions.
• Collaborating with the Enterprise Architects, Data Scientists, Program Leads for communication and program documentation.
• Strong experience in data profiling and data analysis using complex sql queries.
• Document technical applications, specifications, and enhancements.
• Collaborate with the data scientists to organize huge sets of data for data modeling.
• Documenting FHIR API specification.
• Keep the Solution Documents updated for the features.
• Experience in Claims, Eligibility, Benefits and Provider Domain.
• Experience in Performing Impact Analysis for Data Model Breaking Changes.
• Very good understanding of Data warehousing Concepts - Star and Snowflake schema, SCD Type1/Type2, Normalization/De-Normalization, Dimension & Fact tables.
• Proficient with SDLC methodologies and processes like Agile SCRUM, RUP and Waterfall.
• Knowledge in Cloud services such as Microsoft Azure and Amazon AWS.
• Amazon Web Services (AWS) and knowledge in Big Data ecosystem components like Hadoop, MapReduce, Spark, Hive.
• Strong testing experience in performing Functional Testing, Smoke Testing, Regression Testing and User Acceptance Testing (UAT).
• Experience in conducting Joint Application Development (JAD) sessions with end users, Tech Leads, developments and testing teams for conflict resolution.
• Experience in Reference data Analysis and establishing Enterprise code for Enterprise Data Warehouse.
• Experience with version control tool - Git
• Worked on different data formats such as JSON, XML.
• Knowledge on NoSQL Databases such as Cassandra and Mark Logic.
• Extensive experience in Data Visualization including producing tables, graphs and tools such as Tableau, PowerBI and QlikView.
• Solid working knowledge on Agile/Scrum concepts like Product Backlog, Spring Planning, User Stories, Planning Meeting, Daily Stand-up Meeting and Burn-down Charts.
• Extensive experience in creating detailed Business Requirements Document (BRD), Functional Requirements Document (FRD), Web Services and APIs Documentation and User Interface Document (UID) and Requirements Traceability Matrix (RTM).
• Effective team player with strong communication and interpersonal skills, posses a strong ability to adapt and learn new technologies and new business lines rapidly.
• Proven expertise in successful Requirements gathering using suitable elicitation techniques.
• Competent in creating Business Process Modeling Notation (BPMN) and Unified Modeling Language (UML) diagrams like Use Case Diagrams, Sequence Diagrams, and Flow Charts by MS Visio.
• Experience in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design.
• Experience in working third party tools like WinSQL and SQL Developer.
• Created complex parameterized reports in SSRS using BIDS.
• Hands on experience on Microsoft Power BI.
• Translate business requirements into ETL and report specifications.
• Worked closely with QA team to support Test Planning, Test Preparation, Test Execution and Defects/Bugs Validation through various defect tracking tools like Silk Central, Jira and Bugzilla.
• Strong knowledge and hands-on experience in SQL and Relational Databases.
• Hands on experience with SQL database, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Extract, Transform, Load (ETL).
• Developed Custom Reports and different types of Tabular Reports, Matrix Reports, and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).

TECHNICAL SKILLS

Management Tools: SAP Power designer, Rational Requisite Pro, Rally

U I Design Tools: MS Visio, Visual Paradigm, Smart Draw

Business Analytics Software: Microsoft Power BI, SSDT, SSIS, SSRS, Tableau

Project Management Tools: MS Project, MS Office (Word, Excel, PowerPoint, Access)

Databases: MS SQL Server 2008/2012, MS- Access, Oracle 11g, 10i 9i/8i

SQL Server: 2008/2005/2000 , IBM DB2, Teradata 12, Sybase ASE 12

Marklogic: (NOsql database), CASSANDRA, AWS ATHENA

Defect Management Tools: JIRA, HP ALM, Bugzilla

Languages: C#.NET, Java, XML, SQL, HIVE

Database Tools: DbVisualizer 10.0.2, Dbeaver

Web services Testing Tool: SOAPUI - 5.4.0, POSTMAN

Communication tool: CISCO JABBER, Microsoft Teams

Repository: GIT, SHAREPOINT, CONFLUENCE

PROFESSIONAL EXPERIENCE

Data Analyst

Confidential, Minneapolis, MN

Responsibilities:

• Worked closely with Data Architect to review all the conceptual, logical and physical database design models with respect to functions, definition, maintenance review and support Data analysis, Data Quality and ETL design that feeds the logical data models.
• Interacted closely with Subject Matter Experts (SME) for requirements gathering.
• Worked with stake holders / product owners under Agile - Scrum to prioritize the User Stories for Sprint.
• Understand the source data and enterprise data models and create source to target mapping documentation.
• Experience with version control tool - Git.
• Responsible for Data mapping testing by writing complex SQL Queries.
• Extensive experience in Data Visualization including producing tables, graphs and tools such as Tableau.
• Data profiling through different data sources to identify business trends and turn insights into actionable recommendations.
• Modify the existing databases and database management system or direct programmers and analysts to make changes.
• Database testing to ensure that the values that an application is retrieving or storing into the database are accurate or not.
• Responsible for critically reviewing data analysis requests and identifying opportunities to support or impact business decisions or management purposes.
• Assist in project planning and task estimation.
• Gathers required data and performs data analysis to support business need. Anticipates clients' future and ongoing needs.
• Work closely with the internal teams to ensure data analysis and outcomes are linked across datasets to best practice recommendations.
• Determine best method to gather, model, and present data. Gather business requirements and translates business questions into requirements
• Partner with business users to validate business requirements/requests for analysis and present intermediate and final data analytical results.
• Proficient in database and data warehousing technologies.
• Helped the product owner to groom the product backlog by organizing the user stories, prioritizing the stories and splitting epics into user stories.
• Handled communication between business and technology.
• Participated in Sprint review meetings to present developed product to the Business users.
• Worked on different data formats such as JSON, XML.
• Knowledge on NoSQL Databases such as Cassandra and Mark Logic.

Data Analyst

Confidential, Minneapolis, MN

Responsibilities:

• Understand the source data and enterprise data models and create source to target mapping documentation.
• Collaborate with Enterprise Architects for identification and ingestion of Strategic Data Sources.
• Collaborate with business and technical stakeholders while defining solutions.
• Collaborating with the Enterprise Architects, Program Leads for communication and program documentation.
• Strong experience in data profiling and data analysis using complex sql queries.
• Document technical applications, specifications, and enhancements.
• Collaborate with the data scientists to organize huge sets of data for data modeling.
• Documenting FHIR API specification.
• Keep the Solution Documents updated for the features.
• Exprience in using visualization tools PowerBI and QlikView for creating dashboards.

Data Analyst

Confidential, Minneapolis, MN

Responsibilities:

• Responsible for creating source to target mapping documentation.
• Responsible for Data mapping testing by writing complex SQL Queries.
• Interacted closely with Subject Matter Experts (SME) for requirements gathering.
• Prepared Solution documents as per the business requirements.
• Validated the implemented features based on the business requirements.
• Created Reference Mapping Documents and API Mapping Documents.
• Worked with stake holders / product owners under Agile - Scrum to prioritize the User Stories for Sprint.
• Database testing to ensure that the values that an application is retrieving or storing into the database are accurate or not.
• Responsible for critically reviewing data analysis requests and identifying opportunities to support or impact business decisions or management purposes.
• Assist in project planning and task estimation.
• Gathers required data and performs data analysis to support business need. Anticipates clients' future and ongoing needs.
• Partner with business users to validate business requirements/requests for analysis and present intermediate and final data analytical results.
• Participated in Sprint review meetings to present developed product to the Business users.
• Helped the product owner to groom the product backlog by organizing the user stories, prioritizing the stories and splitting epics into user stories.

Data Analyst

Confidential, Minneapolis, MN

Responsibilities:

• Worked closely with Data Architect to review all the conceptual, logical and physical database design models with respect to functions, definition, maintenance review and support Data analysis, Data Quality and ETL design that feeds the logical data models.
• Interacted closely with Subject Matter Experts (SME) for requirements gathering.
• Worked with stake holders / product owners under Agile - Scrum to prioritize the User Stories for Sprint.
• Understand the source data and enterprise data models and create source to target mapping documentation.
• Responsible for Data mapping testing by writing complex SQL Queries.
• Data profiling through different data sources to identify business trends and turn insights into actionable recommendations.
• Modify the existing databases and database management system or direct programmers and analysts to make changes.
• Database testing to ensure that the values that an application is retrieving or storing into the database are accurate or not.
• Responsible for critically reviewing data analysis requests and identifying opportunities to support or impact business decisions or management purposes.
• Assist in project planning and task estimation.
• Gathers required data and performs data analysis to support business need. Anticipates clients' future and ongoing needs.
• Work closely with the internal teams to ensure data analysis and outcomes are linked across datasets to best practice recommendations.
• Determine best method to gather, model, and present data. Gather business requirements and translates business questions into requirements
• Partner with business users to validate business requirements/requests for analysis and present intermediate and final data analytical results.
• Proficient in database and data warehousing technologies.
• Helped the product owner to groom the product backlog by organizing the user stories, prioritizing the stories and splitting epics into user stories.
• Handled communication between business and technology.
• Participated in Sprint review meetings to present developed product to the Business users.

Senior IT Business Analyst/Data Analyst

Confidential, Frisco, TX

Responsibilities:

• Interacted closely with Subject Matter Experts (SME) for requirements gathering.
• Worked with stake holders / product owners under Agile - Scrum to prioritize the User Stories for Sprint.
• Responsible for Data mapping testing by writing complex SQL Queries.
• Allowed the User Stories into the Sprint based on team velocity and individual capacity.
• Understood and performed the AS-IS and TO-BE business process and developed the GAP Analysis.
• Created User Stories to implement product enchancements and monitored Burndown charts on daily basis during sprint.
• Helped the product owner to groom the product backlog by organizing the user stories, prioritizing the stories and splitting epics into user stories.
• Provided project manager with regular status updates.
• Assisted in Test Planning, Test Case development, Functional and Integration Testing.
• Written SQL queries to retrieve and validate data, prepared for data mapping document.
• Gathered and transformed the business requirements into meaningful User Stories for developing SSRS reports.
• Developed Custom Reports and different types of Tabular Reports, Matrix Reports, and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Designed and developed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2014 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Created Cross-Tab, Drill-down, Drill-through and Sub-Report using RDL.
• Experience using REDGATE to compare and synchronize all database objects.
• Created process flow diagrams based on the business requirements.
• Worked closely with the implementation specialist and resolved the production issues.
• Assisted development team in understanding the requirements and answered their queries from business users.
• Involved in Change Management process, using Requirement Traceability Matrix (RTM).
• Available on call during the product deployments.

Senior Business Systems Analyst

Confidential, New Jersey

Responsibilities:

• Worked with stake holders / product owners under Agile - Scrum to prioritize the User Stories for Sprint.
• Prioritized requirements by conducting brainstorming sessions with the Stakeholders.
• Analyzed the high level requirements and drafted the Statement of Understanding.
• Collaborated with development teams for design discussions and creation of data models.
• Collaborate with testing teams in creation of test cases, review and approval of the same.
• Assisted development team in understanding the requirements and answered their queries from business users.
• Assisted in Test Planning, Test Case development, Functional and Integration Testing.
• Involved in Change Management process, using Requirement Traceability Matrix (RTM).
• Created stored procedure for generating reports using SSRS.
• Created Cross-Tab, Drill-down, Drill-through and Sub-Report using RDL.
• Created Tabular Reports, Matrix Reports, and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Written SQL queries to retrieve and validate data, prepared for data mapping document.
• Collaborated with all IT teams during deployment and Post production validations.
• Analyzed Requirements and created Use Cases and Activity Diagrams using MS Visio.
• Provided team status update weekly to Senior Managers of progress made on all aspects and milestones achieved, got the feedback and shared with team to improve our performance.
• Assisted testers in developing a variety of possible test scenarios and test cases to ensure that the system built according the requirements in testing phase.
• UAT support and issue tracking and closure.

Data Analyst

Confidential, Durham, NC

Responsibilities:

• Modify existing Ab-Initio mappings to utilize Power Exchange sources and Oracle and Netezza targets.
• Responsible for Data mapping testing by writing complex SQL Queries using TOAD.
• Identified objects and relationships and how those all fit together as logical entities, these are then translated into physical design using the forward engineering ERWin tool.
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Develop complex SQL queries to generate ad-hoc reports for the business analysts of BCBS to implement complex business rules.
• Worked closely with Testing team and helped in testing the Informatica mappings, workflows, and scripts
• Created test plan conducted whole Metadata Portal application UAT testing during the upgrade.
• Wrote SQL queries of different report and update as business need in SAP Business object.
• Established Horizontal linage and vertical linage of physical table to show up source to target information in metadata portal.
• Responsible for the collection of functional requirements, nonfunctional requirements, data mapping, and light data modeling.
• Created DTS and SSIS packages to load data from different file sources, such as text file, excel sheets.
• Created ETL mappings with PL-SQL procedures to build business rules to load data.
• Performance tuned the database which includes indexes and optimized SQL statements, after monitoring the SQL server using the Profiler.

Business Systems Analyst/Data Analyst

Confidential

Responsibilities:

• Worked with stake holders / product owners under Agile - Scrum to prioritize the User Stories for Sprint.
• Allowed the User Stories into the Sprint based on team velocity and individual capacity.
• Motivated the team under Agile - Scrum methodology to come up with quality shippable product and meet the product goals.
• Set up and maintain the Scrum Board for Project tracking in JIRA.
• Decomposed Epics into user stories and created category hierarchy for the backlog.
• Performed bug checking, requirements management using JIRA and Grasshoppers.
• Created User Stories out of Epics, Themes and Sprints and calculated velocity and story-points in TFS.
• Review of Business requirement documents and signing off.
• Prioritized requirements by conducting brainstorming sessions with the Stakeholders.
• Collaborated with development teams for design discussions and creation of data models.
• Collaborate with testing teams in creation of test cases, review and approval of the same.