PROFESSIONAL SUMMARY:

• Around 6 + years of professional experience working as a Data Engineer,Analyst, business system analyst with diverse industry verticals.
• Data/Business Analyst track record in requirements gathering, performing gap analysis, data analysis and document between 'As - is' and 'To-be' processes.
• Extensive experience in developing logical and physical data models for both transaction as well as analytical systems.
• Proficient in Enterprise Data Warehouse. Worked extensively in several projects in both Forward Engineering as well as Reverse Engineering using data modeling tools.
• Expert in writingSQL queries and optimizing the queriesin Oracle, SQL Server, Netezza andTeradata.
• Experience in creating SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleansed data.
• Excellent knowledgein Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Experience in Automating ETL processes for dynamic, automated data migration and validation by using Informatica, SSIS and Alteryx.
• Experience in Azure Cloud, Azure Data Factory, Azure Data Lake Storage, Azure Synapse Analytics, Azure Analytical services, Azure Cosmos NO SQL DB, and Data bricks.
• Performeddata analysisanddata profilingusing complexSQLon various sources systems including Oracle andTeradata.
• Experience with Business Process Modeling, Process Flow Modeling, Data flow modeling.
• Experience in analyzing the business requirements and creating Business Requirement Document (BRD). Expertise in interacting with stakeholders, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools.
• Hands on experience with modeling using Erwin in developing Entity-Relationship, modeling Transactional Databases and Data Warehousing, Dimensional Data Modeling for Data Marts and Fact & Dimensional Tables.
• Hands-on knowledge of enterprise repository tools, data modeling tools, data mapping and data profiling tools.
• Extensive Experience working on SQL Queries along with good experience in development of T-SQL, Oracle PL/SQL Scripts, Stored Procedures and Triggers for business logic implementation.
• Good Understanding and Knowledge with Agile and Waterfall Environments.
• Having excellent communication, organizational and presentation skills, inter-personal relationship and ability to be part of team.
• Liaison between the cross-functional teams, top management clients, users and any stakeholder involved in the project.
• Involved in performance optimization of DWH solutions, both on ETL as well as Database side.
• Experience in preparing project cutover plan, test plan with test cases for unit test, regression test and User Acceptance Testing (UAT).
• Excellent in verbal and written communication, organizational skills combined with the ability to work in a fast-paced environment as an individual and/or as a team member.

TECHNICAL SKILLS:

Data Modeling Tools: Erwin 7.1/7.2/7.3, System Architect 11.3, MS Visio 2000/2007/2010, ER/Studio, Power Designer 11.0/12.0/12.5/15.

Databases & Database Tools: MS & SQL server, Oracle 9i/10g/11g, MS Access 2003/2007/2010, Teradata, My SQL.

Reporting Tools: Tableau, Power BI, Cognos 11/8, MicroStrategy

Operating Systems: Linux, Unix, DOS, Win Server 2003/2008, WIN 98/NT4/0/2000/XP/VISTA,WIN.

Languages: MY SQL, PL/SQL, SQL.

ETL Tools & Others: Informatica Power Center 8.x, Tools Include Source Analyzer, Target Designer, Mapping Designer, Workflow Manager, MS Office, Rational Requisite Pro, SharePoint.

WORK EXPERIENCE:

Confidential, Dallas, TX

Sr. Data Analyst/Engineer

Responsibilities:

• Analysis of functional and non-functional categorized data elements fordata profilingand mapping from source to target data environment. Developed working documents to support findings and assign specific tasks.
• Demonstrated experience of Column / Advanced Data Profiling and its best practices as a part of Data Quality Assessments.
• Worked on SSIS Control Flow items (for each Loop, execute package/SQL tasks, script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Union all).
• Designed and implemented ETL processes based in SQL, T-SQL, stored procedures, triggers, views, tables, user defined functions and security using SQL SERVER 2012, SQL Server Integration Service (SSIS).
• Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems.
• Analyze, design, and build Modern data solutions using Azure PaaS service to support visualization of data.
• Designed and Configured Azure Cloud relational servers and databases analyzing current and future business requirements.
• Worked on migration of data from On-prem SQL server to Cloud databases (Azure Synapse Analytics (DW) & Azure SQL DB
• 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
• Performeddata analysisanddata profilingusing complexSQLon various sources systems including Oracle andTeradata.
• Provided multiple demonstrations of Tableau functionalities and efficient data visualizations approaches using Tableau to the senior management at the client as part of the BRD.
• Involved in extensive DATA validation by writing several complexSQLqueries and Involved in back-end testing and worked with data quality issues.
• Worked with end users to gain an understanding of information andcore dataconcepts behind their business.
• Assisted in defining business requirements for the IT team and createdBRD and functional specificationsdocuments along with mapping documents to assist the developers in their coding.
• Utilized Alteryx analytics software to process sophisticated cost models and SQL data conversions.
• Performed Data Profiling, Data Cleansing, Data Quality by importing Data from both Relational and NO Relational databases using Alteryx.
• Identify & record defects with required information for issue to be reproduced by development team.
• Involved in data validation of the results in Tableau by validating the numbers against the data in the database tables by querying on the database.
• Dashboards from Tabular Models to help managers to identify critical KPIs and facilitate strategic planning in the organization.

Environment: Tableau Desktop 2020.1/2019/1, Alteryx 11.0 & 11.3, SQL Server, Informatica, Oracle, SQL developer, Teradata, SQL Server 2012, Oracle 11g.

Confidential, Pittsburgh, PA

Data Modeler/Analyst

Responsibilities:

• Working with the Business Analyst and DBA, conducting team meetings and JAD Sessions for technical requirements gathering, business analysis, testing and project coordination.
• Analyze and evaluate existing system for assessing how it supported functions from the Use Case diagrams and UML diagrams.
• Developed Logical data model using ERwin 7.2 and created physical data models using forward engineering.
• Performed reverse engineering for a wide variety of relational DBMS, including Microsoft Access, Oracle and Teradata, to connect to existing database and create graphical representation (E-R diagram) using Erwin 7.2.
• Used Teradata utilities such as Fast Export, MLOAD for handling various tasks.
• Participate in updating the dimensional model and identify the Facts and Dimensions.
• Employed process and data analysis to model a Customer Information Business System.
• Design complex Dashboards like Executive, KPI and Strategic by using Tableau.
• Involved in design and development of standard and ad-hoc reporting using SQL.
• Design and developments of the changes and enhancements. The existing submission and refining programs were enhanced to in corporate the new calculations.
• Involved in overall data mart testing and different team review meetings.

Environment: DB2, Teradata16, SQL, Cognos 8, Cognos Impromptu, ERwin 7.2, XML, Microsoft Access, Microsoft Excel.

Confidential, Danville, PA

Data Analyst

Responsibilities:

• Worked as a liaison among business client and development team for the implementation of transition in compliance with HIPAA standards.
• Identified the business functions and processes and prepare system scope and objectives based on user needs and industry regulations.
• Defined terms, conducted stakeholder analysis, elicited business needs, conducted business process modeling work, facilitated work sessions (JAD), elicited requirements, wrote requirements and use cases, analyzed requirements, validate & prioritize requirements, trace requirements to related project documentation (process models, designs, test scenarios & scripts).
• Gathered requirements by using interviews, observation, JAD, brainstorming sessions, and documents analysis.
• Responsible for the analysis, design, development, testing, and support of data extract, transform, and load processes within the enterprise data warehouse.
• Created Data Dictionary, Data Governance and privacy policies specifying contract implementation.
• Involved in installation and configuration of SQL server 2005 on Database Servers.
• Created Database Objects like Tables, Indexes, Views, Stored Procedures, triggers and User defined functions according to the requirements of the project..
• Data conversions and data loads from various databases and file structures.
• Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance.

Environment: s: MS SQL Server 2005 SSRS/SSAS/SSIS, T-SQL, Windows XP.