SUMMARY

• Over 8 years of experience in the data field working as a Data Analyst/Data Modeler designing and developing OLTP systems, Enterprise Data Warehouse, Data Mart and OLAP systems.
• Experience in SDLC & Agile/SCRUM project methodologies in Analysis, Design, Development, Testing and Implementation of Client/Server - based applications.
• Experience in Data analysis, profiling, migration and conversion. Broad knowledge of Data Governance and Integration.
• Experience in creating data mapping specifications and interface documents.
• Experience in writing T-SQL queries, dynamic queries, sub-queries and complex joins for generating complex Stored Procedures, Triggers, User-Defined Functions, Views, Constraints (Primary key, Foreign key, Unique key) and cursors.
• Excellent understanding of Data Warehousing Concepts - Star and Snowflake schema, slowly changing dimensions types, Normalization (1NF, 2NF, 3NF and BCNF)/De-Normalization, Dimension and Fact tables.
• Strong Experience in implementing Data warehouse solutions in Redshift. Worked on various projects to migrate data from on premise databases to Redshift, RDS and S3.
• Experience in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in SQL.
• Experience in modeling Transactional Databases and Data Warehouse using tools like Erwin, Oracle Designer, Power Designer and ER/Studio.
• Good knowledge on AWS EC2, ELB, EMR, AWS Redshift, DMS, AWS S3, AWS EBS and AWS Lambda
• Solid understanding of Relational Database Systems, Normalization, Star and Snowflake logical and physical data modeling using ERWIN data modeler and MS Visio.
• Experience in Extraction, Transformation and Loading (ETL) processes to acquire and load data from internal and external sources, Import Export and Bulk Insert.
• Experience in performance tuning in tuning stored procedures, Queries using tools like SQL Profiler, Database Tuning Advisor, Execution Plans and Efficient coding standards.
• Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and involved in preparing Test Scenarios, Test Plans, Test Cases, and Test Data.
• Experience in Data Modeling for OLTP and OLAP systems.
• Experience in gathering, managing and documenting Business Requirement Document (BRD) and Functional Requirement Document (FRD).
• Experience in conducting Joint Application Development (JAD) sessions.
• Proficient in using UML for Business Process Modeling, Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Collaboration Diagrams, Class Diagrams, Wireframe Prototypes and documenting them using MS Visio.
• Experience in ETL tools like Informatica, SSIS and reporting tools such as Tableau, MicroStrategy.
• Proficient in Tableau, data visualization tool to analyze and obtain insights into large datasets, create visually compelling and actionable interactive reports and dashboards.
• Creative, self-motivated, quick learner and excellent team player, ability to meet deadlines and work under pressure.

TECHNICAL SKILLS

Databases: SQL Server, Oracle, MySQL, Teradata, PostgreSQL

BI tools: Tableau, MicroStrategy

Tools: and Software: Oracle SQL Developer, SQL Server Management Studio, Control-M (Automation and Scheduling), Teradata SQL Assistant, TOAD for oracle, MS Office Suite, MS Visio.

Operating Systems: Windows, Linux, UNIX

Analysis/Modeling Tools: Erwin, ER Studio, Informatica Data Quality, Informatica Data Explorer

Cloud: AWS, Snowflake, Redshift

ETL: Informatica, SSIS

Quality Management: HP ALM, Quality Center

Programming Languages: SQL, PL/SQL, R

PROFESSIONAL EXPERIENCE

Confidential, Lowell, AR

Senior Data Analyst/ Senior Data Modeler

Responsibilities:

• Responsible for the strategic direction of the technical environment, analyzing Data requirements, logical and physical modeling (using Erwin Data Modeling tool), and establishing data relationship with business.
• Generating weekly, monthly reports for various business users according to the business requirements.
• Worked withdatasets of varying degrees of size and complexity including both structured and unstructureddata.
• Successfully used Agile/Scrum Method for gathering requirements and facilitated user stories workshop. Followed Agile Methodology to analyze and design business needs in an iterative manner.
• Involved in creating snow SQL to extract data from S3 buckets tosnowflaketables and transforming the data according to business requirements.
• Conducted meticulous GAP analysis while successfully reengineering keybusiness processes to increase operational efficiency and alignment ofbusinessunit objectives
• Provided visual/graphic analysis based ondatacontent. Responsible fordatavalidation.
• Upgraded, performed source-to-target mappings, storage capacity planning and developingETL.
• Worked on development ofdatawarehouse and ETL systems using relational and non-relational tools like SQL. Developed and maintained ETL mappings to extract thedatafrom multiple source systems like Oracle, SQL server.
• ConductedDataMining andDataModelling. Collecting, cleansing and providing data modelling and analyzing the structured and unstructureddata.
• Responsible for Analyzing, review, modify and develop ETL packages using Informatica.
• Designeddataflows that (ETL) extract, transform, and loaddataby optimizing performance.
• WroteSQLscripts to extractdatafrom the tables to validatedataflow. Performed numerousdatapulling requests usingSQLfor analysis.MigratedNoSQLclusters for one datacenter to another without downtime
• Involved in writing Test Cases, procedures, reports and approval of software release.
• Defined relationships, created actions, filters, Level-of-Detail expressions parameters,data blending, hierarchies, calculated fields, sorting, groupings, live connections, in-memory in both tableau and excel. Created Tables, Views, Indexes and otherSQLjoins.

Confidential, Newport Beach, CA

Data Analyst/Business Analyst

Responsibilities:

• Created dimensional model for the reporting system by identifying required dimensions and facts using ER Studio. Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model
• Conducted interviews, meetings and JAD sessions during the process of Requirement Gathering.
• Planned and documented procedures for data processing and prepared data flow diagrams for the application.
• Translated business requirements into conceptual, logical and physical data models. DDLs are then generated from CA ERWIN Data Modeling Tool and provided to DBA to apply in the physical database
• Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Data Stage.
• Designed the data flow process to extract the data from Data Warehouse and load it into Redshift.
• Documented all data mapping and transformation processes in the Functional Design documents based on the business requirements.
• Performed SSIS ETL packages validation, reference Data Management and testing master data match groups, match results based on match scores.
• Worked on AWS Data Pipeline to configure data loads from S3 to into Redshift.
• Performed numerousdatapulling requests using SQL server and Tableau for analysis.
• Responsible for designing logical and physical data modeling for various data sources on Redshift.
• Cleaned, processed and loaded data through ETL and SSIS systems and queries in SQL Server, presented in MS Excel, Tableau report or PDF.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views
• Used the BPMN (Business Process Model and Notation) in GAP Analysis to bridge the gap between business processes (BR's and FR's).
• Analyzed business requirements and segregated them into Use Cases.
• Created Use case diagrams and documented Use case specifications.
• Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems.
• Verified and analyzed data mapping issues to find effective fixes
• Utilized SQL Server Integration Services for daily data extractions from vendors and load into SQL Server database
• Worked closely with Business Intelligence Analyst to complete reporting tasks, monitor automated SSIS jobs, and analyze data
• Gathered, analyzed, and documented data requirements for projects of medium to high complexity and moderate to high risk, performed source system data quality analysis.

Confidential, Denver, CO

Senior Data Modeler

Responsibilities:

• Developed the logical data models and physical data models that capture current state/future state data elements and data flows using ER Studio.
• Designed the ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) for Oracle and Teradata
• Used efficientDataSteps to access and manipulatedatafrom different sources and used proc step to generate report out of them.
• UsedInformatica to extractdatafrom different databases like Teradata, Oracle, MS ACCESS, SQL Server.
• Involved in maintaining and updating Metadata Repository with details on the nature and use of applications/data transformations to facilitate impact analysis. Created DDL scripts using ER Studio and source to target mappings to bring the data from source to the warehouse.
• Worked in importing and cleansing of data from various sources like Teradata, Oracle, flat files, MS SQL Server with high volume data
• Designed Logical & Physical Data Model /Metadata/ data dictionary using Erwin for both OLTP and OLAP based systems.
• Involved in meetings with SME (subject matter experts) for analyzing the multiple sources.
• Involved in SQL queries and optimizing the queries in Teradata.
• Created DDL scripts using ER Studio and source to target mappings to bring the data from source to the warehouse.
• Developed data Mart for the base data in Star Schema, Snow-Flake Schema involved in developing the data warehouse for the database.
• Worked on data mapping process from source system to target system. Created dimensional model for the reporting system by identifying required facts and dimensions using Erwin.
• Resolved the data inconsistencies between the source systems and the target system using the Mapping Documents and analyzing the database using SQL queries

Confidential

Data Analyst/Data Modeler

Responsibilities:

• Created Business requirement document (BRD), functional requirements specifications (FRS), and technical requirement specification along with Use Case for application development.
• Conducted Interviews, brainstorming and focus groups to identify requirements and then documented them in a format that can be reviewed and understood by both business and developers.
• Facilitated (JAD) Joint Application Development sessions to resolve issues relating to difference between business requirements and developers.
• Performed Data Analysis and Data validation by writing complex SQL queries.
• Created Business Requirements and converted them into detailed Use Cases, Report Specifications and Non-Functional Requirements.
• Analyzed Requirements and created Use Cases, Use Case Diagrams, Activity Diagrams, sequence diagram using MS-Visio.
• Provided primary liaison between business/operations and development.
• Created data models and data flow diagrams for the to-be process.
• Researched upstream data sources and ensured all source data sources were attested by its owners.
• Created and executed SQL queries to validate data movement and generate expected results for UAT.
• Conducted UAT to verify whether all the Requirements were provided to by the application.
• Worked with the developers on resolving the reported bugs and various technical issues.
• Interacted with the end users to identify and gather business requirements and transform them into technical requirements.
• Identified and prepared Use Cases, BPM, and Activity Diagrams using Rational Rose according to UML methodology.