SUMMARY:

• Dedicated IT professional with over 4+ plus years of progressive experience in data analysis, business requirement analysis, quality assurance, design, development, and testing to further the success of various organizations' business goals and objectives.
• Experience as a Data Analyst with solid understanding of Data Modeling, Evaluating Data Sources and strong understanding of Data Warehouse/Data Mart Design, ETL, BI, OLAP, Client/Server applications to implement management and staff's business requirements into the software application in Healthcare Industry.
• Expert in writing SQL queries and optimizing the queries in Oracle, SQL Server 2008, Teradata and Microsoft Power BI.
• Expert in Data Modeling, Data Analysis, Data Visualization and Modern Data Warehouse concepts. Designed Various Reports/dashboards to provide insights and data visualization using BI/ETL tools like Mainframes SAS, SSAS, SSIS, OLTP, OLAP, Business Objects, Tableau, Informatica power center, Data stage.
• Excellent Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling
• Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Strong experience in using Excel and MS Access to dump the data and analyze based on business needs.
• Sound understanding of Big Data Analytics and its technologies, Digital and IoT concepts, AWS Cloud. SMAC (Social, Mobility, Analytics and Cloud)
• Expert in Data Modeling, Data Analysis, Data Visualization and Modern Data Warehouse concepts. Designed Various Reports/dashboards to provide insights and data visualization using BI/ETL tools like Business Objects, Tableau, and Pentaho.
• Extensive experience in working with Tableau 9.0 and 10.0 Desktop along with Tableau Server Knowledge of Claims Billing (procedure codes, modifiers, diagnoses)
• Worked on healthcare standards such as HIPAA 4010, 5010, ICD - 9, 10.
• Working knowledge of healthcare Technology standards such as HL7 and ISO standards
• Experience in automating and scheduling the Informatica jobs using UNIX shell scripting configuring Korn-jobs for Informatica sessions.
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices
• Expertise in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Results-oriented Joint Application Development (JAD) Facilitator and meetings coordinator with excellent interpersonal skills.

TECHNICAL SKILLS:

Data analysis: Requirements Gathering, JAD sessions, Process/Production Model analysis, Data Normalization, Cleansing, Profiling, System Design, Data architecture internal Standards

Languages: SQL, T-SQL, PL/SQL, Basic C, SAS & UNIX

Database Systems: SQL Server, Oracle, Teradata, DB2

MS Office Suite: MS Word, MS PowerPoint, MS Excel, MS Access

Operating Systems: Microsoft Windows, Linux, Unix

ETL and Reporting Environment: SQL Server, SSIS, SSRS, Informatica, Data Stage, Tableau

Data Modeling Tools: Power Designer 16.5, Erwin, ER/Studio, Additional QA Skills

PROFESSIONAL EXPERIENCE:

Confidential, Glenn Allen, VA

Data Analyst

Responsibilities:

• Meet with customers to determine their needs, gather and document requirements, communicate with customers throughout the project to manage customer expectations, resolve issues, and provide project status.
• Involve in requirement gatherings with Business team for building new Tableau reports and migrating existing BOBJ report to Tableau.
• Create Allowance Limit Reports, Customer Loyalty, Periodical Volume Reports, Brand awareness and other reports for measuring the KPIs.
• Convert existing BO reports to Tableau dashboards.
• Develop Tableau data visualizations using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts, Bar Charts and Density Chart.
• Create complex workbooks and Dashboards by connecting to multiple data sources using data blending and Joins.
• Creation of attributes, filters, advanced chart types, visualizations and complex calculations to manipulate the data and to analyze, obtain insights into large data sets.
• Develop SQLS and extract right data for analysis and build confidence to business that requirements are accurate and are not ambiguous.
• Interpret allowance data residing in various data sources like DB2, Teradata, SQL Server tables and analyze results using statistical techniques and provide ongoing reports.
• Identify, analyze, and interpret trends or patterns in complex Walmart sales', receiving's and allowance data by doing data decomposition.
• Involve in Data Profiling and creation of Data Mapping documents.
• Participate in tech meetings between Technical Architects and Business teams.
• Documenting various artifacts like Requirements, Analysis and Design document in SharePoint.

Data Analyst

Responsibilities:

• Demonstrable expertise in core IT processes, utilizing ETL tools to query, validate, and analyze data.
• Expert business and technical requirements documentation skills employing contemporary tools for data mapping, diagramming, Use Cases, and business rules to produce concise functional specifications.
• Follow and assess the business process model defining metadata rules and critical data elements.
• Conduct analysis, gather requirements, develop Use Cases, data mapping, and workflow diagrams.
• Develop global incident management reporting dashboard for the DQM over multiple IM platforms.
• Investigate unused modules of the DQM and report viability and feasibility for implementation.
• Comparative cost/benefit analysis between DQM modules and Inquiry Framework for DQ assessments.
• Utilize multimedia office suite applications and conduct surveys for high level dashboard reporting.
• Performing daily integration and ETL tasks by extracting, transforming and loading data to and from different RDBMS.
• Creating complex SQL queries and scripts to extract and aggregate data to validate the accuracy of the data.
• Business requirement gathering and translating them into clear and concise specifications and queries.
• Prepare high level analysis reports with Excel and Tableau. Provides feedback on the quality of
• Dataincluding identification of billing patterns and outliers.
• Identify and document limitations in data quality that jeopardize the ability of internal and external data analysts.
• Wrote standard SQL Queries to perform data validation and created excel summary reports
• (Pivot tables and Charts).
• Gather analytical data to develop functional requirements using data modeling and ETL tools.
• Systems Documentation, change control/defect analysis and updates. Implementation testing.
• Gathered data and documenting it for further reference and designed Database using Erwin
• DATAmodeler.
• Experienced in logical and Physical Database design & development, Normalization and
• Datamodeling using Erwin.
• Used Ref cursors and Collections with bulk bind and bulk collect for accessing complex
• Dataresulted from joining of large number of tables to extract data from data warehouse.
• Fine Tuned (performance tuning) SQL queries and PL/SQL blocks for the maximum efficiency and fast response using Oracle Hints, Explain plans.
• Used Teradata as a Source and a Target for few mappings. Worked with Teradata loaders within Workflow manager to configure Fast Load and Multi Load sessions.
• Load data from MS Access database to SQL Server 2005 using SSIS (creating staging tables and then loading the data).
• Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables,
• Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing.
• Migration of MS Access to SQL SERVER 2012.
• Requirements gathering, analysis, Use Cases, data mapping, and workflow diagramming.
• Data quality analysis and execution of the Data Quality Management (DQM) package.
• Wrote SQL queries using analytical functions.
• Documented Business Requirements, Functional Specifications, User stories.
• Created UML based diagrams such as Activity diagrams using MS Visio.
• Perform data extrapolation and validation of reports for analysis and audits.
• Created T/SQL statements (select, insert, update, delete) and stored procedures.
• Utilize SSIS for ETL data modeling, data migration, and analysis.
• Performed drill down analysis reports using SQL Server Reporting Services.
• Documenting the extent to which data fails to meet threshold reporting requirements
• Project manages analytics for deployment within the Development Life Cycle.
• Developed SQL scripts involving complex joins for reporting purposes.
• Develop various SQL scripts and anonymous blocks to load data SQL Server 2005.

Data Analyst

Responsibilities:

• Created logical Data model from the conceptual model and its conversion into the physical database design using Erwin.
• Used SAS to build models to identify definite patterns and suggest business with possible problems and feasible solutions. Identify requirements for new possible business flows.
• Created reports using either Cognos and/or Tableau based client needs for dynamic interactions with the Data produced.
• Designed, developed and deployed databases using MS Access to assist with inventory, payment tracking and various other data control needs.
• Use of Excel and PowerPoint on various projects as needed for presentations or summarization of data to provide insight on key business decisions. data consolidation for operational weekly and monthly business reports, effective and efficient solutions to deal with large Data sets.
• Created data Base Design of Fact & Dimensions Tables, Conceptual, Physical and Logical dataModels using Erwin tool.
• Gathered and documented the Audit trail and traceability of extracted information for data quality.
• Worked with the Business Intelligence and ETL developers on the analysis and resolution of data related problem tickets and other defects and assist them to design of efficient processes to load and manage the data, including a data Quality Assessment to ensure the quality of the source data will meet the information requirements.
• Pulled out sales order data and generated ad hoc stock pulling list using advanced excel functions every day.
• Created template and optimized the procedures which significantly decreased time spent in daily work.
• Performed in-depth data analysis, successfully made more than 4,000 less-sold items competitive in market
• Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Business requirement gathering and translating them into clear and concise specifications and queries.
• Provides feedback on the quality of data including identification of billing patterns and outliers.
• Identify and document limitations in data quality that jeopardize the ability of internal and external data analysis.
• Used SAS to mine, alter, manage and retrieve data from a variety of sources and perform statistical analysis.
• Data governance and defining processes concerning how data is stored, archived, backed up, and protected from mishaps, theft or attack.
• Used Data warehousing for Data Profiling to examine the data available in an existing database and created Data Mart.
• Developed and tested PL/SQL scripts and stored procedures designed and written to find specific data.
• Written PL/SQL Stored Procedures and Functions for Stored Procedure Transformation in Informatica.
• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Generated SQL and PL/SQL scripts to create and drop database objects including: Tables, Views, and Primary keys, Indexes, Constraints, Packages, Sequences and Synonyms.
• Conducted or participated in requirement gathering workshops and design sessions necessary to capture the business needs and develop models.
• Interfaced with business and technology stakeholders to gather, analyze, and document business and data requirements.
• Used HP Quality Center for UAT Test Case Management and defect tracking and resolution.
• Designed and implemented basic SQL queries for testing and report/data validation.
• Ensured the compliance of the extracts to the Data Quality Center initiatives
• Understood the new business requirements and plan the facilitation of data marts.
• Prepared sales reports and interpreted to managers for decision making.
• Extracted key information from highly unorganized data using excel and SQL.
• Conducted data management and used statistical techniques to clean the data.
• Tracking and reporting the issues to project team and management during test cycles.
• Utilize SSIS for ETL data modeling, data migration, and analysis.
• Prepare high level analysis reports with Excel and Tableau.
• Analyze and Assess invalid and missing data in the All Payer Claims Data
• Documenting the extent to which data fails to meet threshold reporting requirements.
• Created T/SQL statements (select, insert, update, delete) and stored procedures.
• Designed and implemented basic PL/SQL queries for testing and report/data validation.
• Troubleshooting and performance tuning of PL/SQL scripts and stored procedures.
• Define and represent Entities, Attributes and Joins between the entities.
• Extensively developed PL/SQL Procedures, Functions, Triggers and Packages.
• Written UNIX shell scripts to automate loading files into database using crontab.
• Developing batch files to automate or schedule tasks.
• Support for the development, pre-production and the production databases.