We provide IT Staff Augmentation Services!

Sr Data Analyst / Data Modeler Resume

5.00/5 (Submit Your Rating)

Denver, CO

SUMMARY

  • Over Nine years of Industry experience as a Data Analyst with solid understanding of Data Modeling, Evaluating Data Sources and strong understanding of Data Warehouse/Data Mart Design, ETL, BI, OLAP, Client/Server applications.
  • Expert in writing SQL queries and optimizing the queries in Oracle, SQL Server 2008 and Teradata V2R6 /R12/R13
  • Excellent Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling
  • Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch
  • Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata V2R6/R12/R13
  • Worked in Data warehouseData& ETL Architecture, Oracle Database platform, ErwinData Modeler, Informatica Power center and SSIS, End to End solutions architecting, Implementing for DWBI Engagements
  • Worked on data warehousing, ETL, SQL, scripting and big data (MPP + Hadoop).
  • Good experience in Pig Latin, a Scripting Language for Hadoop Distributed File system.
  • Good knowledge on Hadoop MRV1 and Hadoop MRV2 (or) YARN Architecture.
  • Excellent experience on Teradata SQL queries, Teradata Indexes, Utilities such as Mload, Tpump, Fast load and FastExport
  • Experienced in Data masking using Informatica data masking transformation
  • Strong experience in using Excel and MS Access to dump the data and analyze based on business needs
  • Excellent knowledge on Perl and Unix
  • Experienced working with Excel Pivot and VBA macros for various business scenarios
  • 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 Ab Initio and Informatica Power Center Experience in testing and writing SQL and PL/SQL statements - Stored Procedures, Functions, Triggers and packages
  • Experienced in automating and scheduling the Informatica jobs using UNIX shell scripting configuring Korn-jobs for Informatica sessions
  • Using Tableau server versions (7.0 and 8.2) as a front-end BI tool and MicroSoft SQL Server 2012 as a back end database designed and developed workbooks, dashboards, global filter page, and complex parameters based calculations.
  • Debugging skills inBigDataAnalytics using SQL.
  • Excellent knowledge on creating reports on SAP Business Objects, Webi reports for multiple data providers
  • Proficiency in distributed query-processing tools like Hive, Spark SQL
  • Excellent knowledge in preparing required project documentation and tracking and reporting regularly on the status of projects to all project stakeholders.
  • Profound experience in NoSQL based query-processing - Hbase, DynamoDB, Cassandra
  • Extensive knowledge and experience in producing tables, reports, graphs and listings using various procedures and handling large databases to perform complex data manipulations
  • Excellent experience in Data mining with querying and mining large datasets to discover transition patterns and examine financial data
  • Experienced in testing Business Intelligence reports generated by various BI Tools like Cognos and Business Objects
  • Excellent knowledge on creating DML statements for underlying statements
  • Extensive ETL testing experience using Informatica 8.6.1/8.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager)
  • Have good exposure on working in offshore/onsite model with ability to understand and/or create functional requirements working with client and also have Good experience in requirement analysis and generating test artifacts from requirements docs
  • Excellent in creating various artifacts for projects which include specification documents, data mapping and data analysis documents

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, UNIX shell Scripting, PERL, AWK,SED

BigData: Hadoop, HDFS, MapReduce, Hive, Sqoop, Pig, HBase, MongoDB, Flume, Zookeeper, Oozie

Databases: Oracle 11g/10g/9i, Teradata R12 R13, R14, 14.10 MS SQL Server 2005/2008/2012 , MS Access, Netezza

Tools: MS-Office suite: (Word, Excel, MS Project and Outlook), VSSTesting and defect tracking ToolsHP/Mercury (Quality Center, Win Runner, Quick Test Professional, Performance Center, Requisite, MS Visio & Visual Source Safe

Operating System: Windows, Unix, Sun Solaris

ETL/Data warehouse Tools: Informatica 9.5/9.1/8.6.1/8.1 , SAP Business Objects XIR3.1/XIR2, Web Intelligence, Talend, Tableau, Pentaho

DataModeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Erwin

Tools: & Software: TOAD, MS Office, BTEQ, Teradata SQL Assistant

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Sr Data Analyst / Data Modeler

Responsibilities:

  • Experienced in Designing & Creating Test Cases based on the Business requirements (Also referred Source to Target Detailed mapping document & Transformation rules document)
  • Involved in extensive Data validation using SQL queries and back-end testing
  • Experienced in Using Erwin R9.0, Creating Conceptual, Logical and Physical data models.
  • Experienced in Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
  • Managed and reviewed Hadoop log files.
  • Wrote Hadoop and Pig/Hive scripts for data processing.
  • Importing and exporting data into HDFS usingHadoop shell commands.
  • Moving data efficiently between clusters using Distributed Copy.
  • Experience in Using Sqoop to connect to the DB2 and move the pivoted data to Hive tables or Avro files.
  • Enabled speedy reviews and first mover advantages by using Oozie to automate data loading into the Hadoop Distributed File System and PIG to pre-process the data.
  • Involved analysis of a variety of source system data, coordination with subject matter experts, development of standardized business names and definitions, construction of a non-relational data model using Erwin v9.2 modeling tool, publishing of a data dictionary, review of the model and dictionary with subject matter experts and generation of data definition language.
  • Managed full SDLC processes involving requirements management, workflow analysis, source Data Analysis, data mapping, metadata management, data quality, testing strategy and maintenance of the model.
  • Created ETL Architecture and provided strategy for data cleansing, data quality and data consolidation. Designed various Informatica ETL load patterns which include SCD Type I, Type II, full load, etc.
  • Worked in level understanding of using different databases in combinations for Data extraction and loading, joining data extracted from different databases and loading to a specific database.
  • Worked in importing and cleansing of data from various sources like Teradata, Oracle, flat files, SQL Server 2005 with high volume data
  • Created end-to-end security architecture solution from sources system, warehouse till consumer layers like web portals, BI reports.
  • Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
  • Extracted data from SQL Server 2008 into data marts, views, and/or flat files for Tableau workbook consumption using T-SQL.
  • Designed and published visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making.
  • Performed data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Perl, TOAD, MS Access, Excel and SQL
  • Worked on Naming standards for Table/Column/Index/Constraints names thru Erwin Macros and Master Abbreviations file.
  • 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.
  • Excellent experience inData miningwithquerying and mining large datasetsto discover transition patterns and examine financial reports.
  • Excellent knowledge in preparing requiredproject documentationandtrackingand reportingregularly on the status of projects to all project stakeholders
  • Extensive knowledge and experience inproducing tables, reports, graphsand listings using various procedures and handlinglarge databases to perform complexdata manipulations.
  • Performed Data Reconciliation between integrated systems, Involved in extensive Data Validation with SQL queries, Involved in Regression testing and Investigated Data Quality issues.
  • Worked on Physical design for both SMP and MPP RDBMS, with understanding of RDMBS scaling features
  • Extensively used agile methodology as the Organization Standard to implement the data Models.

Environment: Quality Center 9.2, MS Excel 2007, PL/SQL, Java, Business Objects XIR2, ETL Tools Informatica 8.6/9.1/9.5, SSIS, Oracle 11G, Teradata R13, Teradata SQL Assistant, Hadoop 1x, Hive, Pig, HBASE, Sqoop and Flume, CA ERWIN r8, Subversion, MS-Office, Oracle 10g, 11g RAC, SQL Server 2008/2012,, SQLPLUS, PL/SQL

Confidential, Chicago, IL

Sr Data Analyst / Data Modeler

Responsibilities:

  • Designed Logical & PhysicalDataModel for development teams both offshore and on site
  • Worked extensively using IBM information analyzer for creating various data profiling results.
  • Lead a team of Data Modeler and data analysts and taken the project to closure successfully.
  • Understood source business process anddatamodel and doData Analysis and map the requirement to source system.
  • Developed Hive queries to process the data for visualizing.
  • Implemented Tableau mobile dashboards via Tableau mobile application.
  • Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
  • Assisted with data management, experimental design, data analysis, and statistical advising; provided SAS, SQL and MATLAB programming support.
  • Performed statistical review of data and checked data issues, prepared statistical reporting using tables, listings, and figures using MATLAB.
  • Provided conceptual /functional /business analysis assistance to developers and DBA's using Erwin/ ER - Studio. Validateddatamodels with client developers
  • Designeddatamodels with GE- ERC standards up to 3rd NF (OLTP/ODS) and de normalized (OLAP)datamarts with Star & Snow flake schemas.
  • Experience in using Pig, Hive, Scoop, HBase, ZooKeeper and ClouderaManager.
  • Involved in developing the Hive Reports.
  • Experience in testing Business Intelligence reports generated by various BI Tools like Cognos, Tableau, Micro strategy and Business Objects
  • Extensive experience in developing Dashboards Reports in Cognos 8 and 10
  • Prepares and submit the summarized audit reports and taking corrective actions
  • Experienced in Creating SQL, PL/SQL, SQL Loader control files, functions, procedures, and UNIX Shell scripts.
  • Experienced in Data Analysis, Gap Analysis,dataintegrity,Dataquality,dataprofiling, metadata,datadictionary, Work flow dependency matrix, Work flow, Logicaldatamap.
  • Experienced in Conceptual, logicaldatamodel. Dimension modeling, star schema design fordatamart,Dataflow diagram(DFD)
  • Provided conceptual and technical modeling assistance to developers and DBA's using Erwin and Model Mart. ValidatedDataModels with IT team members and Clients.
  • Experienced in Writing SQL Queries, PL/SQL, DHTML Functions, Procedures, and Packages
  • Experienced in PhysicalDatamodel, Attributes/Definition,DataDictionary, MetaData
  • Experienced in Process Design, Business Rule and integrity Constraint implementation
  • Experienced in ETL Architecture, Backend Architecture,Data warehouse Architecture
  • DatamanagementofDataintegrity,Datastandard,Dataenhancement,Datapublishing,Dataauditing,DataQuality,DataException handling process.,DataRejection Analysis.
  • Experienced in Export /Import, User/Role, Database Privileges, Database Link, ODBC connectivity.

Environment: Oracle 11g, TOAD, DBVisulizer,DataManager (Cognos), ODBC, TOADData Modeler, ER Studio, Cognos Analysis studio/report studio, oracle EBS 11i, Erwin3.5, PL/SQL TOOL KIT, Perl, JDBC, TOAD 3.0, IBM Information Analyzer, Hadoop 1x, Hive, Pig, HBASE, Sqoop

Confidential, Lincoln, AL

Sr. Data Analyst/Modeler

Responsibilities:

  • Designed LDM/ PDM for Coverage Model / On Line Watch List Management usingErwinfor Global Anti Money Laundry & Economic Sanctions.
  • Involved in preparing LogicalDataModels/PhysicalDataModels.
  • Identify source systems, their connectivity, related tables and fields and ensuredatasuitably for mapping.
  • Designed Logical/ PhysicalDataModel for E-Delivery System Using ER-Studio.
  • Created SQL Loader Scripts, table sizing, indexing, table partition, SQL tuning.
  • Created/ Tuned PL/SQL Procedures, SQL queries forDataValidation for ETL Process.
  • Created Validation reports/System integration reports by Oracle Developer Suite 10g.
  • Extracted data from various sources like Oracle, Netezza and flat files and loaded into the target Netezza database
  • Created DDL, DML scripts. Created and worked with X-Reference tables fordatavalidation between differencedatamarts/Databases
  • Created PL/SQL procedures, triggers, generated applicationdata, Created users and privileges, used oracle utilities import/export.
  • Extracted data from various sources like Oracle, Mainframes, flat files and loaded into the target Netezza database.
  • Designeddatamodels with GE- ERC standards up to 3rd NF (OLTP/ODS) and de normalized (OLAP)datamarts with Star & Snow flake schemas.
  • Created more than 20 New Models and with more than 100 tables. Used Star Schema and Snow flake Schema fordatamarts /DataWarehouse.
  • Created DHTML using PL/SQL Tool kits, packages, Dynamic SQL, used Apache
  • Provided conceptual and technical modeling assistance to developers and DBA's usingErwinand Model Mart. ValidatedDataModels with IT team members and Clients.
  • Worked on IBM Information Analyzer to profile the data and generate various reports
  • DataAnalysis and Application testing Tuning using Analyze and Explain plan.
  • Extracted the sourcedatafrom Oracle tables, MS SQL Server, sequential files and excel sheets.
  • Developed mappings in Informatica to load thedatafrom various sources includes SQL server, DB2, Oracle, Flat files into theDataWarehouse, using different transformations like Source Qualifier.

Environment: Oracle 8i, PL/SQL, SQL Loader 8.1, Toad 4.0, UML,Erwin3.5,K-Shell, Erwin3.5, PL/SQL TOOL KIT, Perl, JDBC, Toad 3.0, PL/SQL

Confidential, Herndon, VA

Sr. Data Analyst/Modeler

Responsibilities:

  • Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
  • Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
  • Setting up of environments to be used for testing and the range of functionalities to be tested as per technical specifications.
  • Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
  • Responsible for different Data mapping activities from Source systems to EDW, ODS & data marts.
  • Created the test environment for Staging area, loading the Staging area with data from multiple sources.
  • Responsible for analyzing various data sources such as flat files, ASCII Data, EBCDIC Data, Relational Data (Oracle, DB2 UDB, MS SQL Server) from various heterogeneous data sources.
  • Delivered file in various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.)
  • Executed campaign based on customer requirements
  • Followed company code standardization rule
  • Performed ad hoc analyses, as needed, with the ability to comprehend analysis as needed
  • Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
  • Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.
  • Tested several stored procedures and wrote complex SQL syntax using case, having, connect by etc
  • Involved in Teradata SQL Development, Unit Testing and Performance Tuning and to ensure testing issues are resolved on the basis of using defect reports.
  • Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
  • Experience in creating UNIX scripts for file transfer and file manipulation.
  • Provide support to client with assessing how many virtual user licenses would be needed for performance testing.
  • Ensuring onsite to offshore transition, QA Processes and closure of problems & issues.
  • Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Environment: Informatica 8.1, Data Flux, Oracle 9i, Quality Center 8.2, SQL, TOAD, PL/SQL, Flat Files, Teradata V2R6

Confidential, Bronx, NY

Sr. Data Analyst/Modeler

Responsibilities:

  • Designed & Created Test Cases based on the Business requirements (Also referred Source to Target Detailed mapping document & Transformation rules document).
  • Involved in extensive DATA validation using SQL queries and back-end testing
  • Used SQL for Querying the database in UNIX environment
  • Developed separate test cases for ETL process (Inbound & Outbound) and reporting
  • Involved with Design and Development team to implement the requirements.
  • Developed and Performed execution of Test Scripts manually to verify the expected results
  • Design and development of ETL processes using Informatica ETL tool for dimension and fact file creation
  • Involved in Manual and Automated testing using QTP and Quality Center.
  • Conducted Black Box - Functional, Regression and Data Driven. White box - Unit and Integration Testing (positive and negative scenarios).
  • Defects tracking, review, analyzes and compares results using Quality Center.
  • Participating in the MR/CR review meetings to resolve the issues.
  • Defined the Scope for System and Integration Testing
  • Prepares and submit the summarized audit reports and taking corrective actions
  • Involved in Uploading Master and Transactional data from flat files and preparation of Test cases, Sub System Testing.
  • Document and publish test results, troubleshoot and escalate issues
  • Preparation of various test documents for ETL process in Quality Center.
  • Involved in Test Scheduling and milestones with the dependencies
  • Functionality testing of email notification in ETL job failures, abort or data issue problems.
  • Identify, assess and intimate potential risks associated to testing scope, quality of the product and schedule
  • Created and executed test cases for ETL jobs to upload master data to repository.
  • Responsible to understand and train others on the enhancements or new features developed
  • Conduct load testing and provide input into capacity planning efforts.
  • Provide support to client with assessing how many virtual user licenses would be needed for performance testing, specifically load testing using Load Runner
  • Create and execute test scripts, cases, and scenarios that will determine optimal system performance according to specifications.
  • Modified the automated scripts from time to time to accommodate the changes/upgrades in the application interface.
  • Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Environment: Windows XP, Informatica Power Center 6.1/7.1, QTP 9.2, Test Director 7.x, Load Runner 7.0, Oracle 10g, UNIX AIX 5.2, PERL, Shell Scripting

We'd love your feedback!