SUMMARY

• Overall 9+years of Business Systems/ Data Analyst experience in building Enterprise Applications such as Banking, Financial Services Health care and Insurance Sector.
• 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 wif Enterprise Architects for identification and ingestion of Strategic Data Sources.
• Collaborate wif business and technical stakeholders while defining solutions.
• Collaborating wif teh 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 wif teh data scientists to organize huge sets of data for data modeling.
• Documenting FHIR API specification.
• Keep teh Solution Documents updated for teh 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 wif 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 wif 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 wif 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 wif 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 wif 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 wif 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 me 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/8iSQL Server 2008/2005/2000 , IBM DB2, Teradata 12, Sybase ASE 12Marklogic (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 wif Data Architect to review all teh conceptual, logical and physical database design models wif respect to functions, definition, maintenance review and support Data analysis, Data Quality and ETL design that feeds teh logical data models.
• Interacted closely wif Subject Matter Experts (SME) for requirements gathering.
• Worked wif stake holders / product owners under Agile - Scrum to prioritize teh User Stories for Sprint.
• Understand teh source data and enterprise data models and create source to target mapping documentation.
• Experience wif 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 teh existing databases and database management system or direct programmers and analysts to make changes.
• Database testing to ensure that teh values that an application is retrieving or storing into teh 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 wif teh 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 wif 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 teh product owner to groom teh product backlog by organizing teh user stories, prioritizing teh stories and splitting epics into user stories.
• Handled communication between business and technology.
• Participated in Sprint review meetings to present developed product to teh 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 teh source data and enterprise data models and create source to target mapping documentation.
• Collaborate wif Enterprise Architects for identification and ingestion of Strategic Data Sources.
• Collaborate wif business and technical stakeholders while defining solutions.
• Collaborating wif teh 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 wif teh data scientists to organize huge sets of data for data modeling.
• Documenting FHIR API specification.
• Keep teh Solution Documents updated for teh 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 wif Subject Matter Experts (SME) for requirements gathering.
• Prepared Solution documents as per teh business requirements.
• Validated teh implemented features based on teh business requirements.
• Created Reference Mapping Documents and API Mapping Documents.
• Worked wif stake holders / product owners under Agile - Scrum to prioritize teh User Stories for Sprint.
• Database testing to ensure that teh values that an application is retrieving or storing into teh 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 wif 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 teh Business users.
• Helped teh product owner to groom teh product backlog by organizing teh user stories, prioritizing teh stories and splitting epics into user stories.

Data Analyst

Confidential, Minneapolis, mn

Responsibilities:

• Worked closely wif Data Architect to review all teh conceptual, logical and physical database design models wif respect to functions, definition, maintenance review and support Data analysis, Data Quality and ETL design that feeds teh logical data models.
• Interacted closely wif Subject Matter Experts (SME) for requirements gathering.
• Worked wif stake holders / product owners under Agile - Scrum to prioritize teh User Stories for Sprint.
• Understand teh 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 teh existing databases and database management system or direct programmers and analysts to make changes.
• Database testing to ensure that teh values that an application is retrieving or storing into teh 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 wif teh 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 wif 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 teh product owner to groom teh product backlog by organizing teh user stories, prioritizing teh stories and splitting epics into user stories.
• Handled communication between business and technology.
• Participated in Sprint review meetings to present developed product to teh Business users.

Senior IT Business Analyst/Data Analyst

Confidential, Frisco, TX

Responsibilities:

• Interacted closely wif Subject Matter Experts (SME) for requirements gathering.
• Worked wif stake holders / product owners under Agile - Scrum to prioritize teh User Stories for Sprint.
• Responsible for Data mapping testing by writing complex SQL Queries.
• Allowed teh User Stories into teh Sprint based on team velocity and individual capacity.
• Understood and performed teh AS-IS and TO-BE business process and developed teh GAP Analysis.
• Created User Stories to implement product enchancements and monitored Burndown charts on daily basis during sprint.
• Helped teh product owner to groom teh product backlog by organizing teh user stories, prioritizing teh stories and splitting epics into user stories.
• Provided project manager wif 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 teh 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 teh business requirements.
• Worked closely wif teh implementation specialist and resolved teh production issues.
• Assisted development team in understanding teh requirements and answered their queries from business users.
• Involved in Change Management process, using Requirement Traceability Matrix (RTM).
• Available on call during teh product deployments.

Senior Business Systems Analyst

Confidential, New Jersey

Responsibilities:

• Worked wif stake holders / product owners under Agile - Scrum to prioritize teh User Stories for Sprint.
• Prioritized requirements by conducting brainstorming sessions wif teh Stakeholders.
• Analyzed teh high level requirements and drafted teh Statement of Understanding.
• Collaborated wif development teams for design discussions and creation of data models.
• Collaborate wif testing teams in creation of test cases, review and approval of teh same.
• Assisted development team in understanding teh 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 wif 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 teh feedback and shared wif team to improve our performance.
• Assisted testers in developing a variety of possible test scenarios and test cases to ensure that teh system built according teh 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 tan translated into physical design using teh 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 teh business analysts of BCBS to implement complex business rules.
• Worked closely wif Testing team and halped in testing teh Informatica mappings, workflows, and scripts
• Created test plan conducted whole Metadata Portal application UAT testing during teh 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 teh 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 wif PL-SQL procedures to build business rules to load data.
• Performance tuned teh database which includes indexes and optimized SQL statements, after monitoring teh SQL server using teh Profiler.

Business Systems Analyst/Data Analyst

Confidential

Responsibilities:

• Worked wif stake holders / product owners under Agile - Scrum to prioritize teh User Stories for Sprint.
• Allowed teh User Stories into teh Sprint based on team velocity and individual capacity.
• Motivated teh team under Agile - Scrum methodology to come up wif quality shippable product and meet teh product goals.
• Set up and maintain teh Scrum Board for Project tracking in JIRA.
• Decomposed Epics into user stories and created category hierarchy for teh 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 wif teh Stakeholders.
• Collaborated wif development teams for design discussions and creation of data models.
• Collaborate wif testing teams in creation of test cases, review and approval of teh same.