SUMMARY:

• 8+ years of strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Governance, Data Integration, MDM, NoSQL and Metadata Management Services and Configuration Management.
• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design.
• Expert in the Data Analysis, Design, Development, Implementation and Testing using Data Conversions, Extraction, Transformation and Loading (ETL) and SQL Server, ORACLE and other relational and non - relational databases.
• Strong experience in using Excel and MS Access to dump the data and analyze based on business needs.
• Focus on Organization, Client Relations and Process Improvements
• Proficient in Gathering Requirements, Business Case Development to Rollout, Production and Maintenance with a solid understanding of Business Processes and analyzing them and documenting.
• 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.
• Understanding in development of Conceptual, Logical and Physical Models for Online Transaction Processing and Online Analytical Processing (OLTP & OLAP).
• Skillful in Data Analysis using SQL on Oracle, MS SQL Server, DB2 & Teradata
• Experience in logical/physical database design and review sessions to determine and describe data flow and data mapping from source to target databases coordinating with End Users, Business Analysts, DBAs and Application Architects.
• Ability to learn technical information and keep self updated with technology.
• Expertise in scheduling JAD (Joint Application Development) with End Users, stake Holders, Subject Matter Experts, Developers and Testers.
• Experienced in designing and developing project document templates based on SDLC methodology.
• Expert in Visio, Process Flow Diagrams, Activity Diagrams, Cross Functional Diagram, Swim Lane Diagrams, Use Case Diagrams.
• Experienced in developing testing strategies plans, writing test cases and UAT.
• Collaborative and decisive with strong communication and interpersonal abilities.
• Analytical and Customer-oriented with strategic planning and Quality leadership.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.
• Quick learner and good performer both in team and independent job environments.

TECHNICAL SKILLS:

Programming Languages: (SSIS, SSRS, SSAS), SAP ABAP, C Lang, DS through C

Tools: OBIE 10g/11g, SAP ECC6 EHP5, Gotomeeting, Docusign, Insidesales.com, Sharepoint, Mat-lab

Database Tools: Microsoft SQL Server12.0, Teradata 15.0, Oracle 12c/9i, and MS Access, Netezza.

Design and Development: Visual Studio 2008/2005/2003, Visual Studio 6.0, Agile

Platforms: MAC OS X, Windows 98/2000/2003/XP Professional, Windows 7 & 8, Linux

Office: Office 365, Google Forms, MS Project, MS Word, MS Excel (Formulas, Pivot tables), MS PowerPoint, Outlook, Visio, MS Access

Operating Systems: Windows 10/7/ XP, Linux, Unix.

Methodologies: RAD, JAD, RUP, UML, System Development Life Cycle (SDLC), Waterfall Model.

PROFESSIONAL EXPERIENCE

Confidential, Long Island, NY

Sr. Data Analyst/Data Modeler

Responsibilities:

• Generated DDL scripts using Forward Engineering technique to create objects and deploy them into the databases.
• Reverse engineered existing database schemas in order to implement changes and updates for existing tables and views.
• Experienced in Designing Database with prominent activities like maintaining sequences, index, and primary key, foreign key, manipulating columns and tables.
• Translated business requirements into working logical and physical data models for Data warehouse, Data marts and OLAP applications.
• Developed SQL, BTEQ (Teradata) queries for Extracting data from production database and built data structures, reports.
• Performed Data modeling using TOAD Data Modeler. Identified objects and relationships and how those all fit together as logical entities, these are then translated into physical design using forward engineering TOAD Data Modeler tool.
• Worked with BTEQ to submit SQL statements, import and export data, and generate reports in Teradata.
• Designed and documented Use Cases, Activity Diagrams, Sequence Diagrams, OOD (Object Oriented Design) using UML and Visio.
• Performeddatacleaning anddatamanipulation activities using NZSQL utility.
• Excellent knowledge and experience in Technical Design and Documentation.
• Designed and Developed Oracle PL/SQL Procedures and UNIX Shell Scripts for Data Import/Export and Data Conversions.
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2
• In depth analyses of data report was prepared weekly, biweekly, monthly using MS Excel, SQL & UNIX.
• Performance Tuning (Database Tuning, SQL Tuning, Application/ETL Tuning)
• Create and alter SQL statements before sending database change request to DBA team.
• Maintained and documented all create and alter SQL statements for all release.

Environment: UNIX, Sybase, Business objects, DB2, SQL server, PL/SQL, ERWIN 9.6, Teradata 15.0, Oracle 9i/12c, DB2, SQL server2014, MS Visio 2010, MS Outlook, MS Office Suite, MS Project, MS Excel, MS Word, Windows Server 2010

Confidential, Colorado Springs, CO

Sr. Data Analyst/Data Modeler

Responsibilities:

• Designed the conceptualdatamodel and worked with the Business analysts and technical teams to design and update the logicaldatamodel in various iterations.
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2
• Worked in importing and cleansing of data from various sources like Teradata, Oracle, flat files, SQL Server 2014 with high volume data
• Involved in extensive data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Created SQL Prototypes to load sampledata, and also to test the business rules/logic prior to development.
• Worked on building thedatamodel using Erwin as per the requirements, discussion and approval of the model from business users.
• Involved with teradata utilities like Fastload, BTEQ, Multiload and Teradata SQL Assistant.
• Used ErwinDataModelerand Erwin Model Manager to create Conceptual, Logical and Physical datamodels and maintain the model versions in Model Manager for further enhancements.
• Analyzed the objectives and scope of each stage of testing process from the Test plan.
• Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
• Involved in fixing invalid mappings, testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Refining the logical design so that it can be translated into a specific data model.
• 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.
• Involved in the validation of the OLAP Unit testing and System Testing of the OLAP Report Functionality and data displayed in the reports.

Environment: Teradata 14.x, PL/SQL, SAS, MS Visio 2010, MS Office Suite, MS Project, MS Excel, MS Word, Agile techs, SQL Server 2012, Share Point, Oracle 10g/11g, Windows Server 2010

Confidential, Ann Arbor, MI

Sr. Data Analyst/Data Modeler

Responsibilities:

• Performeddataanalysis and profiling of sourcedatato better understand the sources.
• Map business needs/requirements to subject area model and to logical enterprise model.
• Worked with DBA's to create a best fit physicaldatamodel from the logicaldatamodel
• Experience working on creating models for Teradata masterdatamanagement.
• Involved in extensiveDataAnalysis on the Teradata and Oracle Systems querying and writing in SQL and TOAD.
• Created logicaldatamodel from the conceptual model and it's conversion into the physical database design using ERWIN.
• Involved in Performance Tuning of the database which included creating indexes, optimizing SQL statements & monitoring the server.
• Developed the logicaldatamodels and physicaldatamodels that confine existing condition/potential statusdatafundamentals anddataflows using ER-Studio.
• Developed regression test scripts for the application and Involved in metrics gathering, analysis and reporting to concerned team and Tested the testing programs
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Toad, MS Access, Excel, XLS and SQL.
• 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 as per business requirements using Erwin 9.5
• Redefined many attributes and relationships in the model and cleansed unwanted tables/columns as part ofDataAnalysis responsibilities.
• Assist developers, ETL, BI team and end users to understand thedatamodel.

Environment: SQL Server 2005/2008, DB2, Microsoft Transaction Server, Erwin r8.2, Teradata 14, Crystal Reports, MS-SQL server manager, Microsoft Access, Requisite Pro, MS Excel, MS Visio, Rational Rose, MS Office Suite, Agile techs, SQL Server 2008, Oracle 10g/9i

Confidential, Denver, CO

Analyst/Data Modeler

Responsibilities:

• DataAnalysis primarily IdentifyingDataSets, SourceData, Source MetaData,DataDefinitions and DataFormats.
• Identified the entities and relationship between the entities to develop Conceptual Model using ERWIN.
• Performeddataanalysis anddataprofiling using complex SQL on various sources systems including Oracle and Netezza
• Developed ER and Dimensional Models using Power Designer advanced features. Created physical and logicaldatamodels using Power Designer.
• Managed full SDLC processes involving requirements management, workflow analysis, source data analysis,datamapping, metadata management,dataquality,
• PerformedDataprofiling to identifydataissues upfront, provided SQL prototypes to confirm the business logic provided prior to the development.
• Responsible for the development and maintenance of Logical and Physical data models, along with corresponding metadata, to support Applications.
• Resolved thedatatype inconsistencies between the source systems and the target system using the Mapping Documents.
• Experience inDataTransformation andDataMapping from source to target database schemas and alsodatacleansing.
• Analyzed business requirements, system requirements, data mapping requirement specifications with power designing, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Applieddatacleansing/datascrubbing techniques to ensure consistency amongstdatasets.
• Analyzed the physicaldatamodel to understand the relationship between existing tables. Cleansed the unwanted tables and columns as per the requirements as part of the duty being aDataAnalyst.
• Worked on two sources to bring in requireddataneeded for reporting for a project by writing SQL extracts.

Environment: Teradata 13.x, Erwin 7.2, Unix, Angile, PL/SQL, MS-Access, Oracle 10g/9i, Sql Server 2008/2005,, MS Office, MS Visio, Crystal Reports, Quality Center 9.2, MS Excel 2007, Informatica.

Confidential, Phoenix, AZ

Data Analyst/Data Modeler

Responsibilities:

• Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and metric dashboards in SAP Business Objects
• 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.
• Involved in Migrating thedatamodel from one database to Teradata database and prepared a Teradata staging model.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning and to ensure testing issues are resolved on the basis of using defect reports.
• Wrote and executed SQL queries to verify thatdatahas been moved from transactional system to DSS,Datawarehouse,datamart reporting system in accordance with requirements.
• Identified and Defined entities, relationships and attributes in thedatamodel as per new specifications in Erwin after analyzing the database systems currently in use. Identified source elements and done mapping with the target systems.
• Resolveddataissues and updates for multiple applications using SQL queries/scripts
• Analysis of functional and non-functional categorizeddataelements fordataprofiling and mapping from source to targetdataenvironment. Developed working documents to support findings and assign specific tasks
• Conducted theDataAnalysis and identified theDataquality issues usingDataprofiling methodologies.
• Involved withDataAnalysis primarily IdentifyingDataSets, SourceData, Source MetaData,Data Definitions andDataFormats
• Developed the requireddatawarehouse model using Star schema for the generalized model.
• Createddatamasking mappings to mask the sensitivedatabetween production and test environment.

Environment: Teradata, Linux, Oracle9i/10g, PL/SQL, SQL Server 2005/2000, MS Access, Perl, Metadata, NZSQL,Erwin6.0, Toad 7.6, Informatica 7.0, DB2 V7.1