Sr. Data Modeler/data Analyst Resume
Irving, TX
SUMMARY
- 6 years of Experience in Data Analysis, Data Modeling, Data Warehouse & Business intelligence professional wif applied information Technology.
- Experience in Design, Development, Testing and Maintenance of various Data Warehousing and Business Intelligence (BI) applications in complex business environments.
- Well versed in Conceptual, Logical/Physical, Relational and Multi - dimensional modeling, Data analysis for Decision Support Systems (DSS), Data Transformation (ETL) and Reporting.
- Proficient in developing Entity-Relationship diagrams, Star/Snow Flake Schema Designs, and expert in modeling Transactional Databases and Data Warehouse.
- Efficient in all phases of teh development lifecycle, coherent wif Data Cleansing, Data Conversion, Data Profiling, Data Mapping, Performance Tuning and System Testing.
- Proficient in Normalization/De-normalization techniques in relational/dimensional database environments and have done normalizations up to 3NF.
- Efficient in Dimensional Data Modeling for Data Mart design, identifying Facts and Dimensions, creation of cubes.
- Experienced in Technical consulting and end-to-end delivery wif architecture, data modeling, data governance and design - development - implementation of solutions.
- Hands on experience in SQL, PL/SQL programming, performed End-to-End ETL validations and supported Ad-hoc business requests. Developed Stored Procedures and Triggers and extensively used Quest tools like TOAD.
- Good understanding of Ralph Kimball (Dimensional) & Bill Inmon (Relational) model Methodologies.
- Designed and implementedAzureStream Analytics (ASA) jobs and PowerBI reports for an IoT Analytics platform using
- 3 years ofAzureDeveloper andAzureadmin experience. Experience in managingAzureSQL wif DBA activities.
- Experience wif Teradata utilities such as Fast Export, MLOAD for handling various tasks.
- Strong experience in Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration and Metadata Management Services and Configuration management.
- Efficient in all phases of teh development lifecycle, coherent wif Data Cleansing, Data Conversion, Performance Tuning and System Testing.
- Strong Experience in working wif Excel Pivot and VBA Macros for various business scenarios.
- Experience in generating DDL (Data Definition Language) Scripts and creating Indexing strategies.
- Developed solution to copy on-premisesdatawarehouse toAzureusingDataFactory, Logic Apps, andAzureSQL
- Hand on Experience working wifAWSRDS, Creating, updating and backups of Databases
- Excellent SQL Programming skills and developed Stored Procedures, Triggers, Functions, Packages using SQL/PL SQL, Performance tuning and query optimization techniques in transactional and data warehouse environments.
- Experience in Data analysis and Data profiling using complex SQL on various sources systems including Oracle and Teradata.
- Experience in dashboard reports using SQL Server reporting services (SSRS).
- Expert in Agile/Scrum and waterfall methodologies.
- Working wifAWSInfrastructure, wif numerous services such as S3, EC2, RDS,CloudWatch, IAM, VPC and Route 53 etc.
- Experienced wif event-driven and scheduledAWSLambda functions to trigger variousAWSresources.
- Experience in developing Entity Relationship diagrams and modeling Transactional Databases and Data Warehouse using tools like ERWIN, ER/Studio and Power Designer.
- Strong experience in using Excel and MS Access to dump teh data and analyze based on business needs.
- Good understanding of Access queries, V-Lookup, formulas, Pivot Tables, etc.
- Working knowledge of CRM Automation Salesforce.com, SAP.
- Hands on experience in analyzing data using Hadoop Ecosystem including HDFS, Hive, Streaming, Elastic Search, Kibana, Kafka, HBase, Zookeeper, PIG, Sqoop, and Flume.
- Experience in developing Map Reduce Programs using Apache Hadoop for analyzing teh big data as per teh requirement.
TECHNICAL SKILLS
Data Modeling Tools: Erwin Data Modeler 9.7/9.6, ER Studio v17, and Power Designer.
Big Data technologies: HBase 1.2, HDFS, Sqoop 1.4, Spark, Hadoop 3.0, Hive 2.3
AWS tools: EC2, S3 Bucket, AMI, RDS, Redshift
ETL/Data warehouse Tools: Informatica 9.6/9.1, SAP Business Objects XIR3.1/XIR2, Talend and Pentaho.
Reporting Tools: SSRS, Power BI, Tableau, SSAS, MS-Excel, SAS BI Platform.
Languages: UNIX Shell Scripting, HTML, T-SQL, Data Structure, Algorithms.
OLAP Tools: Tableau 7, SAP BO, SSAS, Business Objects, and Crystal Reports 9
Databases: Oracle 12c/11g, Teradata R15/R14, MS SQL Server 2016/2014, DB2.
Operating System: Windows, Unix, Sun Solaris
Other tools: SQL PLUS, SQL LOADER, MS Project, MS Visio, UNIX, PL/SQL etc
Methodologies: RAD, JAD, RUP, UML, System Development Life Cycle (SDLC), Agile, Waterfall Model.
PROFESSIONAL EXPERIENCE
Sr. Data Modeler/Data Analyst
Confidential, Irving, TX
Responsibilities:
- Developed full life cycle software including defining requirements, prototyping, designing, coding, testing and maintaining software.
- Created Logical & Physical Data Model on Relational (OLTP) on Star schema for Fact and Dimension tables using Erwin.
- Performed GAP analysis to analyze teh difference between teh system capabilities and business requirements.
- Developing SSIS packages to integrate them intoAzureDataFactoryV2.
- Used Agile Method for daily scrum to discuss teh project related information.
- Prepared ETL technical Mapping Documents along wif test cases for each Mapping for future developments to maintain Software Development Life Cycle (SDLC).
- Involved in Data flow analysis, Data modeling, Physical database design, forms design and development, data conversion, performance analysis and tuning.
- Created sampling specification, performed quality assurance, created multiple datasets to communicate wif Medicare Advantage plans and analyzed Medicare plans response.
- Created and maintained data model standards, including master data management (MDM) and Involved in extracting teh data from various sources like Oracle, SQL, Teradata, and XML.
- Designed teh data marts using teh Ralph Kimball's Dimensional Data Mart modeling methodology using Erwin.
- UsedAWSCloudWatch, Nagios as a performance monitoring and analytics tools.
- Worked on Master data Management (MDM) Hub and interacted wif multiple stakeholders.
- Worked wif medical claim data in teh Oracle database for Inpatient/Outpatient data validation, trend and comparative analysis.
- Design and implementation of an Azuredatalake
- Design and development of thedatawarehousedataETL Jobs usingazuredatafactoryandazuredatabricks.
- Proficient in developing Entity-Relationship diagrams, Star/Snow Flake Schema Designs, and expert in modeling Transactional Databases and Data Warehouse.
- Worked on normalization techniques, normalized teh data into 3rd Normal Form (3NF).
- Worked Normalization and De-normalization concepts and design methodologies like Ralph Kimball and Bill Inmon approaches and implemented Slowly Changing Dimensions.
- Implemented Forward engineering to create tables, views and SQL scripts and mapping documents.
- Responsible for all BI TeamAzurebased solutions along wif developing strategy on implementation
- Used reverse engineering to connect to existing database and create graphical representation (E-R diagram).
- Designed and developed architecture for data services ecosystem spanning Relational, NoSQL, and Big Data technologies under guidance of several Data Architect.
- Azurelogic app development to trigger teh workflow onAzureSQL DB
- Performance tuning and stress-testing of NoSQL database environments in order to ensure acceptable database performance in production mode.
- Developed Data Mapping, Data Governance, and Transformation and cleansing rules for teh Master Data Management Architecture involving OLTP, ODS.
- Assisted in defining business requirements and created BRD (Business Requirements Document) and functional specifications documents.
- Developed automated data pipelines from various external data sources (web pages, API etc) to internal data warehouse (SQL server) tan export to reporting tools like Datorama by Python.
- Connected to AWS Redshift through Tableau to extract live data for real time analysis.
- Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Netezza
- Monitored teh Data quality and integrity of data was maintained to ensure effective functioning of department.
- Managed database design and implemented a comprehensive Star-Schema wif shared dimensions.
- Analyzed teh data which is using teh maximum number of resources and made changes in teh back-end code using PL/SQL stored procedures and triggers
- Developed and maintained stored procedures, implemented changes to database design including tables and views and Documented Source to Target mappings as per teh business rules.
- Conducted Design reviews wif teh business analysts and teh developers to create a proof of concept for teh reports.
- Performed detailed data analysis to analyze teh duration of claim processes and created teh cubes wif Star Schemas using facts and dimensions through SQL Server Analysis Services (SSAS).
- Deployed SSRS reports to Report Manager and created linked reports, snapshots, and subscriptions for teh reports and worked on scheduling of teh reports.
- Generated parameterized queries for generating tabular reports using global variables, expressions, functions, and stored procedures using SSRS.
- Developed, and scheduled variety of reports like cross-tab, parameterized, drill through and sub reports wif SSRS.
- Directing and overseeing data quality tests, including providing input to quality assurance team members.
Environment: Erwin v9.7, Agile, NoSQL, Big Data, Azure, Redshift, MDM, Oracle 12c, SQL, Teradata r15, XML, Python 3.6, PL/SQL, Tableau, SSRS.
Sr. Data Analyst/ Modeler
Confidential, Dorchester, MA
Responsibilities:
- Used SQL extensively to query Databases
- Sales data analysis and teh maintenance of pricing tables that feed live website
- Conducted data assessments of legacy data
- Used Excel, Access and VBA in teh development of robust and flexible reporting systems
- Retrieved data from data warehouse and generated a series of meaningful business reports using SSRS and Cognos.
- Deploying and maintaining production environment usingAWSEC2 instances and Elastic Container Services wif Docker
- Monitoring resources and Applications usingAWSCloudWatch, including creating alarms to monitor metrics such as EBS, EC2, ELB, RDS, S3, SNS and configured notifications for teh alarms generated based on events defined
- Perform troubleshooting and monitoring of teh Linux server onAWS.
- Maintaining teh user accounts (IAM), RDS, Route 53, SES and SNS services inAWScloud
- Validated and tested reports, tan published teh reports to teh report server.
- Performed and conducted complex custom analytics as needed by clients.
- Designed and developed specific databases for collection, tracking and reporting of data.
- Established, maintained and distributed daily, weekly and monthly reports
- Created financial models using Excel Pivot Tables and formulas to develop best and worst case scenarios
- Creation of user accounts, policies and roles on Amazon Web Services (AWS) using IAM
- Data auditing, creating data reports & monitoring all data for accuracy
- Data cleansing - checking for data redundancy, duplicates and reporting on all findings
- Assisted in teh development of Metrics to measure teh business data cleansing progress
- Performed and conducted complex custom analytics as needed by clients.
Environment: Erwin9.0, AWS, Redshift, Oracle11g, Sql Server 2010, Teradata14, XML, OLTP, PL/Sql, Linux, UNIX, Mload, BTEQ, UNIX shell scripting
Data Analyst
Confidential
Responsibilities:
- Played an active and lead role in gathering, analyzing and documenting teh Business Requirements, teh business rules and technical requirements from teh Business Group and teh Technology Group.
- Drafted enterprise security standards and guidelines
- Performed and created procedures for system security audits
- Assisted in teh development of database access controls and separation of duties
- Assisted in incident response and disaster recovery
- Responsible for teh documentation and execution of remediation plans
- Performed periodic security review of privileged accounts
- Performed a thorough analysis on teh Sales Order Entry process to eliminate bottleneck
- Captured As-Is Process, designed TO-BE Process and performed Gap Analysis
- Gatheird Requirements from different sources like Stakeholders, Existing Systems, and Subject Matter Experts by conducting Workshops, Interviews, Use Cases, Prototypes
- Created Functional Requirement Specification documents - which include UML Use case diagrams, scenarios, activity, work Flow diagrams and data mapping. Process and Data modelling wif MS VISIO.
- Worked wif teh DW, ETL teams to create Order entry systems Business Objects reports.
- Worked in a cross functional team of Business Analysts, Architects and Developers to implement new features in various custom applications.
- Developed and maintained various User Manuals and Application Documentation Manuals on Share Point tool.
- Created Test Plans and Test Strategies to define teh Objective and Approach of testing.
- Used Quality Center to track and report system defects and bug fixes, wrote modification requests for teh bugs in teh application and halped developers to track and resolve teh problems.
- Developed and Executed Manual, Automated Functional, GUI, Regression, UAT Test cases using QTP.
- Gatheird, documented and executed Requirements-based, Business process (workflow/user scenario), Data driven test cases for User Acceptance Testing.
- Created Test Matrix, Used Quality Center for Test Management, track & report system defects and bug fixes.
- Performed Load, stress testing and analyzed performance/response Times.
- Created / developed SQL Queries wif several parameters for Backend Database testing.
Environment: Erwin 8.0, MS Excel, MS Access, UNIX, T-Sql, MS Sql 2008, Excel, SSIS, SSRS, MS Visio.
