SUMMARY

• Over 6+ years of working experience as a Data Modeler and Data Analyst with high proficiency in requirement gathering and data modeling including design and support of various applications in OLTP, Data Warehousing, OLAP and ETL Environment.
• Hands on experience in importing, cleaning, transforming, and validating data and making conclusions from the data for decision - making purposes.
• Solid understanding of statistical analysis, predictive analysis, machine learning, data mining, quantitative analytics, multivariate testing, and optimization algorithms.
• Worked on various databases Oracle, Sql server, Sql Server, Teradata andDB2.
• Expertise in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Ability to use custom SQL for complex data pulls.
• Well versed in system analysis, ER/Dimensional Modeling, Database design and implementing RDBMS specific features.
• Skilled in visualizing, manipulating and analyzing large datasets and also has ability of designing and developing effective reports. Proficient with MS Office Applicants, Excel(Pivot Table, Hlook UP, Vlook Up, CountIf, etc.)and also experienced with Tableau, MS SQL Server,
• Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export through the use of multiple ETL tools such as Informatica Power Center
• Experience in testing, data validation and writing SQL and PL/SQL statements - Stored Procedures, Functions, Triggers and packages.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Worked on Data Model design, Data Extraction, Transformations and Loading, Mappings & Workflows, Customized Analytics Reports.
• Highly skilled in Tableau Desktop for data visualization, Reporting and Analysis, Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Experience with data warehousing techniques like Slowly Changing Dimensions, Surrogate key, Snow flaking etc. Worked with Star Schema, Data Models, E-R diagrams and Physical data Models.
• Extensive knowledge on Data Profiling using Informatica Developer tool.
• Experience in Performance Tuning and Debugging of mappings and sessions. Strong in optimizing the Mappings by creating/using Re-usable transformations, Mapplets and PL/SQL stored procedures
• Experience in Data warehousing, Data Architecture &Extraction, Transformation and loading (ETL) data from various sources into Data Warehouse and Data Marts using Informatica Power Center.
• Profound knowledge of Data modeling including Star Schema and Snow Flake Dimensional Data modeling, 3NF Normalized Data Modeling. Very good understanding of Logical Modeling and Fine-tuned Physical Data Modeling.
• Worked on Tableau and created adhoc reports and dashboards.
• Worked in creating different Visualizations in Tableau using Bar charts, Line charts, Pie charts, Maps, Scatter Plot charts, Heat maps and Table reports.
• Involved in Design of the Enterprise Data Visualization Architecture. Defined best practices for Tableau report development.
• Expert knowledge of UNIX Shell Scripting and understanding of PERL & Korn scripting.
• Creating Checklists for Coding, Testing and Release for a smooth, better & error free project flow.
• Experience in Integration and extraction of data from various sources like DB2, SQL Server, Oracle, Sybase, and Teradata, MS Access, Flat files into a staging area.in using ETL methodologies for supporting Data
• Extraction, Data Migration, Data Transformation and loading using Informatica Power center, IDQ.
• Strong SQL Skills related to information retrieval and analysis. Exposure to Client Interaction, User requirement Analysis and Support.
• Expert in evaluating data models to design Tableau solutions.
• Extensive development/maintenance/analyst and production support experience in RDBMS (Hyperion Essbase, IBM MDM, Teradata, Sybase, and Microsoft SQL Server 2008), C, and UNIX & Python. Well versed with Data Warehouse concepts, Data modeling, Data structure design, Data Quality governance, Defining Logical and Physical Data Models/Structures and providing ETL support. Certified Teradata professional and Teradata SQL specialist.
• Extensive experience in creating data scope and requirements. Strong expertise in understanding various data sources.
• Experience working with data analysis tools for data lineage, metadata, and data profiling
• Proficient in working with senior executives and multiple stakeholders to understand key data issues and identifying their resolution.
• Extensive experience in developing Unit, Integration and UAT Test plans and Cases and also has experience in generating/executing SQL Test Scripts and Test results.
• Experienced in managing, monitoring and investigating cases such as trouble tickets from customers and fixing the issues.

PROFESSIONAL EXPERIENCE

Confidential, Wellesley, MA

Data Analyst

Responsibilities:

• Support for creation and documentation of the ETL Detailed Design.
• Designed and created required mappings for consistency check to compare like data elements across the files to assure the consistency of data.
• Create various Data Mapping Repository documents as part ofMetadataservices needed to build the Data Warehouse
• Created and tested incremental data movement code (extract, cleanse, validate, transform, and load)
• Handled Source to Target Data Mapping, Technical Specs documentation, and ETL documentations such as Early Data Inventory Designed SSIS Packages to transfer data between servers, load data into database on SQL Server environment and deploy the data.
• Performed Loading Client loads into Data Warehouse using SSIS, SSMS. Operating Meta data for desired output in the Website and modified existing program logic to improve overall system performance.
• Designed and developed matrix and tabular reports with drill down, drill through and drop-down menu option using SSRS.
• Worked with SSIS to load individual table and with SSRS to generate reports.
• Worked on Agile environment for Meta data, ETL client loads, created data modelling on Snowflake and Star scheme.
• Responsible for the development and implementation of HIPAAEDIMap sets 270, 271, 276, 277, 820, 834, 835, 837 and 5010.
• Developed standard mappings and mapplets using various transformations like expression, aggregator, joiner, router and lookups
• Expert in TSQL, creating and using Stored Procedures, Views, User Defined Functions, implementing Business Intelligence solutions using SQL Server.
• Configured SSIS packages to in corporate slowly changing dimensions for tracking historical data
• Extensively used Data stage Enterprise Edition (Parallel Extender) to develop various jobs to extract, cleanse and load the data and also involved in migration from DS to versions.
• Reviewed ETL and Business Objects defects and proposed fix for defects as per the scheduled timeframe.
• Used Data stage Director to schedule, monitor, cleanup resources and run job with several invocation ids.
• Developed Data stage parallel jobs using stages Transformer, Modify, Look-Up, Join, Merge, Aggregator, Remove Duplicate, Column Generator, Change Capture, Change Apply, Dataset, Sequential File stage etc.
• Created Sequence jobs to control the flow of jobs and their dependencies
• Involved in extensive DATA validation by writing SQL queries and Involved in back-end testing and worked with data quality issues.
• Working with the application and Business Analyst team to develop requirements
• Translating process/technical solutions for business during defect analysis
• Worked with HIPAA compliant ANSI X12 837 formats for both professional claims and institutional claims.
• Participate in the scrum meeting and also represented the teamduring the meeting
• Working through the phases of SDLC using the Agile methodology
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Dealt with the EDI transaction 835 claims payments and remittance advice, which deals the payment from payer to provider.
• Worked on Data Stage ETL in development and support of multiple Data warehouse environments.
• Developed PL/SQL packages, stored procedures, functions, alerts for ensuring the warehouse data integrity checks and shell scripts to balance the data between source and target tables after each ETL process

Confidential, Columbus, OH

Sr. Data Analyst

Responsibilities:

• Created views and dashboards based on requirements and published them to Tableau Server for Business and End User teams to be reviewed.
• Designed and developed mock-up Tableau Dashboards to explore options for visualization of data, presentation, and analysis.
• Served as a liaison between the business and the IT department by conducting weekly calls/meetings with stakeholders, developers, QA Team, UAT Team to document any changes and apply them to Tableau reports as needed.
• Created effective Dashboards in Power BI Service and made the reports user friendly and interactive.
• Created database objects like tables, views, Materialized views, procedures, packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions.
• Worked with DBA to extract API data into SQL Server and connected to the same from Tableau for various reporting requirements.
• Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently.
• Scheduled data refresh onTableauServer for weeklyand monthlyincrementsbased on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.
• Created reports using Custom SQL for complex report views.
• Dashboard Visualization through Tableau BI application.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Effectively used data blending, filters, quick filters, data source filters, global filters, context filters, actions, Hierarchies feature in tableau.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Created various types of data visualizations using Python.
• Conversion of BO reports to Tableau
• Worked on Business Intelligence standardization to create database layers with user-friendly views in Oracle that can be used for development of various Tableau reports/ dashboards.
• Extensively developed complex PL/SQL packages for Invoice Processing.
• Wrote various Windows scripts and Python scripts to facilitate the operations of these data stores.
• Designed/developed tables, views, various SQL queries, stored procedures, functions.
• Involved in PL/SQL code review and modification for the development of new requirements.

Confidential, Albany, NY

Sr. Data Analyst

Responsibilities:

• Documented logical, physical, relational and dimensional data models. Designed the Data Marts in dimensional data modeling using star and snowflake schemas.
• Prepared documentation for all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, and glossary evolve and change during the project
• Coordinated with DBA on database build and table normalizations and de-normalizations
• Created, documented and maintained logical & physical database models.
• Identified the entities and relationship between the entities to develop Conceptual Model using ERWIN.
• Creating Data mappings, Tech Design, loading strategies for ETL to load newly created or existing tables.
• Perform in-depth data analysis and load customer details from data warehousing to analyze, generate comprehensive reports to decision makers and other affected by the results.
• Created Schema objects like Indexes, Views, and Sequences, triggers, grants, roles, Snapshots.
• Developed strategies and loading techniques for better loading and faster query performance.
• Extensively worked on documentation of Data Model, Mapping, Transformations and Scheduling batch jobs.
• Developed dimensional model for Data Warehouse/OLAP applications by identifying required facts and dimensions.
• Generated the DDL using forward engineering Worked in merging and complete compare of Physical models.
• Used the Data Warehousing Life Cycle to identify data elements from the source systems, performed data analysis to come up with data cleansing and integration rules for the ETL process.
• Defined Functional Test Cases, documented, Executed test script in Facets system.
• Involved in full HIPAAEDItransactions such as 835, 837 (P, D, I) 276, 277, 278.
• Designed STAR schema for the detailed data marts and plan data marts consisting of confirmed dimensions.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle.
• Hands on experience performing, Data mining and hardcopy or electronic document study to improve and expand the databases in the application.
• Used forward engineering to create a physical data model with DDL that best suits the requirements from the Logical Data Model.
• Created advanced chart visualizations in Tableau using Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Pie Chart, Gantt chart, Histograms.
• Involved in Creation of dashboards, stories and visualizations in Tableau. Created report schedules on Tableau Server.
• Worked on SQL queries in a dimensional data warehouse as well as a relational data warehouse.
• Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Recommend additional methods to analyze collect and manage data to improve data quality and efficiency of the data systems across the application.
• Perform administrative tasks, including creation of database objects such as database, tables, and views, using SQL DCL, DDL, and DML requests.
• Involved in Developing Tableau visualizations and dashboards using Tableau Desktop.
• Involved in extensive data validation by writing several complexes SQL queries and involved in back-end testing and worked with data quality issues.
• Designed and developed database models for the operational data store, data warehouse, and federated databases to support client enterprise Information Management Strategy.
• Flexible to work late hours to coordinate with offshore team.

Confidential - Winston-Salem, NC

Data Analyst -Intern

Responsibilities:

• The responsibilities included analyzing and testing the user interface and constantly redesigning the system to increase its user friendliness for the clients.
• Implemented RUP and followed iterative, Use Case driven process for requirements documentation and deployment.
• Implemented SDLC which included requirements, specifications, design, analysis and testing utilizing RUP methodology.
• Used Python creating graphics, data exchange and business logic implementation.
• Captured Modelling requirements from Senior Stakeholders to Bench functional requirements for SAS/ R Python
• Worked on Map Reduce/Spark Python modules for machine learning & predictive analytics in Hadoop.
• Used Python scripts to update content in the database and manipulate files
• Performed troubleshooting, fixed and deployed many Python bug fixes of the applications and involved in fine tuning of existing processes followed advance patterns and methodologies.
• Created various types of data visualizations using Python.
• Utilized standard Python modules such as csv, robot parser, iterators and pickle for development.
• Adept at quantitative analysis with Python
• Developed Merge jobs in Python to extract and load data into Teradata database.
• Building dashboards for large SQL based processes for risk and regulation monitoring using Java, R (Shiny), Python, and AngularJS in an agile process built on the AWS platform.
• Work on developing Python Scripts to assist in testing trading functionality.
• Experience using Python and R for machine learning algorithms for data mining. Cluster analysis, hidden Markov models, and time series analysis.
• Wrote Python scripts to parse XML documents and load the data in database.
• Used Python to extract weekly information from XML files.
• Developed Python scripts to clean the raw data.
• Involved in creating TDE (Tableau Data Extract) using PYTHON script.
• Identified, analyzed and interpreted trends or patterns in complex data sets using data mining tools (Python, R)
• Carried out segmentation, building predictive models and integrating secondary and primary data using R, python
• Worked on designing regression Algorithms using R and Python.
• Used ad hoc queries and Pandas with Python for querying and analyzing the data, participated in performing data profiling, data analyzing, data validation and data mining.
• Analyze requirements utilizing various methods. (E.g. sample data from SQL queries, Screen Shots, reports, prototype screens, sourcing information, and other data models.)
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).
• As part of a team provided assistance with monthly data extractions and imports utilizing Microsoft Access, SQL and Microsoft Excel.
• Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, information needs and insured that critical requirements are not missed.
• Prepared Business Process Models that includes modeling of all the activities of business from conceptual to procedural level.

Environment: Windows 98 / NT, UNIX, SQL Server, .NET, XML, XSD, MS Office, Business Objects, Oracle, MS Visio, MS Project, Rational Tools, UML