SUMMARY

• Experience in application software analysis, design, development, implementation, maintenance, and documentation of commercial applications throughout various phases of project life cycle.
• Experience & knowledge of BI Tools likePower BI, Tableau,Informatica PowerCenter
• Interacting with Business users, gathering and analyzing requirements.
• Experienced in developing conceptual, logical and physical data models for OLTP and OLAP systems.
• Proficient in Oracle Data base design with relational models and very good experience in entity and attribute identification and developing the Entity - Relationships.
• Experience in data transformation, data mapping from source to target database schemas, data cleansing procedures.
• Responsible for documentation of build and maintenance requests specific to orders, procedures, Appointments using Crystal and Caboodle. Used EPIC Hyperspace for validating, importing and exporting repo data from development environment to testing environment.
• Worked on creating a COVID -19 infection dashboard for providers to review day to day test cases
• Well-versed in designing Star and Snowflake Database schemas pertaining to relational and dimensional data modeling
• Enforcing security by creating roles, granting system and object privileges on the tables, stored procedures.
• Provided support & maintenance of Power BI reports to business users.
• Knowledge of database architecture for OLTP and OLAP applications, Data Analysis and ETL processes.
• Implemented Informatica Procedures and Standards while developing and testing the Informatica objects.
• Good in system analysis, ER Dimensional Modeling, Database design and implementing RDBMS specific features.
• Participated in designing and development of software using agile development practices.
• Experienced in generating and documenting Metadata while designing OLTP and OLAP systems environment.
• Experience working on creating models for Teradata master data management.
• Actively involved in capacity planning, creating views, materialized views, partitioning tables and creating indexes etc for optimization process.
• Created basic SSIS packages using excel or text files as source and Insert/Update records into SQL Server table.
• Highly skilled and experienced in Agile Development process for diverse requirements.
• Experience in Design, Development, Implementation and support as Oracle Developer in Production, Development and Test Environments using Oracle Tools like SQL Developer and reporting services using Reports Builder, Crystal Reports and Oracle BI tools.
• Gave a scope for enhancements and Change management in place with agile methodology.
• Have extensively modeled data and created ER Diagrams using CA ERwin and Microsoft Visio.

TECHNICAL SKILLS

Database: Oracle 12c/11g/10g/9i, My SQL Server, DB2,Teradata

Languages: SQL, PL/SQL, UNIX Scripting

Development Tools: SQL Developer, SQL*Plus, TOAD, SQL*Loader, Reports Builder 10g/9i/6i, Forms Builder 6i/9i/10g, MS-Access 2000

Modeling tools: Erwin7.1/4.0,EmbarcaderoER/Studio, MSVisio

Reporting Tools: Crystal Reports, Oracle Reports, XML/BI Reports, MARS application

ETL: Informatica, Data Stage,SSIS

Others: XML, HTML, SVN, IBM Rational Clear case and Clear quest, Quality Center, Microsoft Visual Source Safe(VSS),EPIC,Caboodle,Clarity

Operating Systems: Windows 2003/ XP/7, UNIX, AIX, LINUX, SUN SOLARIS

PROFESSIONAL EXPERIENCE

Confidential, NC

Senior ETL Consultant

Responsibilities:

• Extensively used EPIC Data cube in generating reports for Appointments, HB, PB, Denials, Census
• Design and development of Tableau data sources and dashboards and visualization using different types of charts.
• Lead the Tableau workbooks and data source release management to deploy from Dev to UAT to Prod environment.
• Experience in building Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Services (SSIS).
• Provided SQL Performance optimization for Caboodle ETL, OLAP SlicerDicer reporting clients in SQL Server and Oracle by analyzing the Execution plan, Statistics to find bottle neck in IO/Memory/Sort/Index scans, fixing recursive hash joins
• Performed data analysis and gathered columns metadata of source systems for understanding requirement.
• Worked on End to End Data Analysis for integration of two systems.
• Worked with Clarity Database in creating custom Reports for the Various Providers and validated the same with the INI Files and items
• Create and schedule DMCs for EPIC dashboard data load and configuration of Caboodle Tables
• Responsible for Analyzing new columns and update to any existing new columns as part of migration of Caboodle
• Develop SQL metric queries for the EPIC hyperspace deployment.
• Performedad hoc analyses, as needed, with the ability to comprehend analysis as needed.
• Responsible forAnalyzing report requirements and developing the reports by writing Teradata SQL Queries and using MS Excel, Power Point.
• Developed custom visual reports, dashboards and KPI scorecards using Power BI desktop.
• Provided support & maintenance of Power BI reports to business users.
• Updated Data Inventory based on BRD Reviews.
• Worked with Data Quality team users totweak the existing tests.

Environment: Caboodle, Crystal, Clarity, EPIC Hyperspace, Tableau, Service Now, MSSQL, SSIS,SSRS,SSAS

Confidential, Charlotte, NC

Senior ETL Data Engineer

Responsibilities:

• Worked with various Business users togather reporting requirements and understand the intent of reports and attended meetings to provide updates on status of the projects
• Created new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer. Added and modified Informatica mappings and sessions to improve performance, accuracy, and maintainability of existing ETL functionality.
• Extensively implemented performance tuning of target, source and mapping, used debugger to troubleshoot logical errors.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduling them to run at specified time with required frequency.
• Communicating with the business users to understand business requirements clearly
• Responsible forAnalyzing report requirements and developing the reports by writing Teradata SQL Queries.
• Used Joinslike Inner Joins, Outer joins while creating tables from multiple tables.
• Tuned the queriesto improve the Performance of the existing reports for various functional areas.
• Performedad hoc analyses, as needed, with the ability to comprehend analysis as needed.
• Identifying data discrepancies and data quality issues and working to ensure data consistency and integrity
• Performed data analysis and gathered columns metadata of source systems for understanding requirement.
• Wrote severalTeradata SQL Queries using Teradata SQL Assistant for Ad Hoc Data Pull request.
• Used Joinslike Inner Joins, Outer joins while creating tables from multiple tables.
• Responsible for new Data Quality tests of our operational data.
• Extensively worked on to convertORACLE scripts into Teradata scripts.
• Compared Data in Oracle and Teradata to understand the Synchronizing issues existing between two Databases.
• Used Teradata utilities like Fast Load, Multi Load to load data into temporary tables for analysis.
• Work with the Party Operations on data clean-up efforts.
• Worked with Data Quality team to determine the cause for high data quality errors.
• CreatedMultiset, temporary, derived and volatile tables in Teradata database.
• Responsible for High Level Data Remediation Plans for Data Defects in our Operational data.
• Tuning SQL Queries to overcome spool space errors and improve performance.
• Worked on Teradata Multi-Load, Teradata Fast-Load utility to load data from Oracle and SQL Server to Teradata. Worked on queries using statistics to calculate the mean and average of the sales.
• Tracked the Data issues through JIRA. Creating wireframes and mockups for the presentation of reports to the team.
• Providing production support for bug fixes and enhancements.
• Identifying quality best practices and developing standard quality protocols that can be widely used in our Team.
• Identifies business, operational and technical tasks, scope, time constraints and task interdependencies.

Environment: Teradata Studio, Excel, Ab Initio, MicroStrategy, Agile, Informatica IDQ, Informatica PowerCenter

Confidential, Hartford, CT

ETL-SQL Developer

Responsibilities:

• Requirement Gathering from Business Users.
• Analyzed client systems andBusinessprocesses.
• Created SQL scripts for demonstrating the prototypes and for verifying the result set
• Conducted and Managed JAD sessions with SMEs andBusinessdepartments, for planning and requirement gathering.
• Identifying and fetching the required test data based on thebusinessrules and rebalancing of client portfolios.
• Used Power Designer to develop Use Case diagrams, Activity Diagrams and Sequence Diagrams.
• Closely interacted with the technical team and made sure that the requirements are met.
• Worked closely with the QA team and reviewed test cases.
• Facilitated User Acceptance Testing withbusinessstakeholders to ensure all requirements has been met.
• Assisted the QA team in designing the Test Plan and Test Cases for User Acceptance testing
• Worked on data modeling and produced data mapping and data definition documentation
• Provided Gap Analysis, documentedbusinessprocesses and directed UAT process.
• Extensively used SQL for Data Analysis.
• Follow up and closure of defects identified during the testing cycle with testing team and Development team.
• Conduct high-level analysis in specific areas of expertise, research and trouble shoot production issues, make suggestions to streamline operations.
• Analyzed existing Data Model and accommodated changes according to the business requirements.
• Created Conceptual model based on the business process and identified the entities, attributes and relationships and converted the conceptual model to the logical and physical data models.
• Converted the logical model to Physical Model by giving accurate data types, created indexes on keys and forward engineered the DDL.

Environment: Teradata, TOAD, Rally, Excel, Ms office, Ultra edit, Agile, Tableau, Oracle 11g, Erwin

Confidential, Brooklyn, NYC

BI Engineer

Responsibilities:

• Worked with SME’s and other stakeholders to determine the requirements to identify Entities and Attributes to build Conceptual, Logical and Physical data Models.
• Translated the business requirements into detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling.
• Created a high-level industry standard, generalized data model to convert it into logical and physical model at later stages of the project using Erwin and Visio.
• Extensively used SQL Query, joining tables, SQL function in Queries.
• Created numerous database objects like Tables, Sequences, indexes, views, materialized views, synonyms, etc., as per the business requirement.
• Used forward engineering to create a Physical Data Model with DDL, based on the requirements from the Logical Data Model.
• Wrote Stored Procedures and Triggers.
• Wrote Minus queries between source and target tables to check data integrity.
• Constant interaction with ETL team for the analysis.
• Assisted Business Analysts and Users during the UAT testing by providing the data dumps.
• Used advanced SQL like analytical functions, aggregate functions for mathematical and statistical calculations.
• Reviewed the Business/ Functional/ System Requirement Specs, High Level Design Documents, and Detailed Design Documents.
• Wrote the count validation queries for source and target.
• Extensively used EXCEL and MS office.
• Did unit testing and development testing at ETL level in my mappings
• Used SVN for version controlling and ALM (Application Lifecycle Management) for ticketing system.
• Entering and updating issues using JIRA application.
• Created PL/SQL packages to extract and transform legacy data.
• Developed data mapping documents between Legacy, Production, and User Interface Systems.
• Worked on Metadata exchange among various proprietary systems using XML.
• Conducted Design reviews with the business analysts, content developers and DBAs
• Created database triggers for audit and data validation.
• Involved in creating ETL model (snowflake schema), normalizing and documenting.
• Involved in creating reports on other Tools like Tableau.
• Created summary tables using de-normalization technique to improve complex Join operations
• Created multiple dashboards, adhoc reports, sub-reports and complex master-detail reports using Reports.

Environment: Oracle Database 11g, PL/SQL, Erwin R8.2.5, MS Visio UNIX, Toad, Oracle Forms and Reports 11g, MS Office, ETL Informatica, Tableau, Excel.

Confidential, Redwood shore, CA

ETL Consultant

Responsibilities:

• Gathered the business requirements by conducting a series of meetings with business users.
• Map business needs/requirements to subject area model and to logical enterprise model.
• In order of better understanding the requirement documents, carried out couple of sessions with Management, SME (Subject Matter Expertise), vendors, users, and other stakeholders.
• Worked with Architecture team to get the metadata approved for the new data elements that are added for this project.
• Developed process methodology for the reverse engineering phase of the project.
• Developed project plan with project manager’s assistance for the first two phases of the project.
• Created documentation and test cases, worked with users for new module enhancements and testing.

Environment: Erwin r7.1, Windows 2000/XP, Erwin 7.1, Oracle Database 11g, PL/SQL, Teradata, Sun Solaris, MS Excel 2007, Informatica 7.1.