SUMMARY:

• Experienced Sr. Data Modeler/ Data Analyst/ Data Modeler/Systems Analyst with 8 + years in Data analysis and Modelling process which includes analyzing and modeling business processes, requirements gathering and expectation management.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN, ER Studio and Visio.
• Proficient at translating strategic IT user requirements into specific database capabilities
• Ability to write clear documentation of procedures, and ability to write specifications for data models to be developed.
• Proficient in writing requirements for ETL Data warehousing, database profiling.
• Experience in Agile, Scrum and waterfall methodology and dimensional data modeling
• Excellent SQL, PL/SQL skills with both DML, DDL commands and demonstrated ability to write complex queries for purpose of analyzing data and/or evaluating how information needs might be translated into back end database structures
• Experience working with various relational database management systems such as MS Access, MS SQL Server, Oracle and Teradata
• Have actively involved in design impact analysis, Data modeling and project design), development (analysis, programming, and testing), implementation, maintenance and administration
• Extensive experience in Process/Data Modeling, Quality Assurance/Testing of both client and server side and data warehousing applications.
• Expertise and complete understanding of QA Life Cycle, which includes Designing, Developing, Execution and Documentation of the Test Cases, Automated Test Scripts and Test Plans.
• Have performed several roles and have been part of full SDLC of several Development Projects
• Quickly learn and effectively utilize third party or proprietary tools to reduce the product delivery time
• Experience in creation of data source and transform them into custom created DataMart’s.
• Extensive experience in visualizing the design of the system using UML diagrams, Activity diagrams, and Web page mock - ups.
• Efficient in VBA for MS Excel for planning/status reporting and creating test data.
• Solid understanding of master data management (MDM). Worked with data architects team to create the data model
• Possesses excellent communication skills and an active team player.

WORK EXPERIENCE:

Confidential, Goodlettsville, TN

Sr. Data Analyst/Business Analyst/Data Modeler/SQL Analyst

Responsibilities:

• Coordinated with Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Created Logical/physical Data Model in ERwin and have worked on loading the tables in the Data Warehouse
• Wrote complex SQL queries to identify granularity issues and relationships between data sets and created recommended solutions based on analysis of the query results
• Designed ETL architecture to Process large no of files and created High-level design, low-level design documents.
• Created reports and graphs using Business objects to meet the business requirements of the project.
• Worked closely with BA to determine feasibility and determine LOEs. Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
• Created and complete testing of repository, reports, dashboards and analytics to ensure they meet documented business requirements
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Collaborate with data modelers, ETL developers in the creating the Data mapping document.
• Participated in user meetings, gathered Business requirements & specifications for the Data-warehouse design. Translated the user inputs into ETL design docs.
• Created SQL queries and database triggers for state mandated reports and data elements.
• Involved in the designing of the Data Model in deriving Conceptual, Logical and Physical model’s using Erwin with Architect teams.
• Defined, and documented the technical architecture of the Data Warehouse, including the physical components and their functionality.
• Wrote complex SQL queries to identify granularity issues and relationships between data sets and created recommended solutions based on analysis of the query results
• Data SME to the project team and business customers through documentation, drive-by questions, research, Visio, Excel pivot tables, and SQL queries
• Responsible for SQL tuning and optimization using Analyze, Explain Plan and optimizer hints.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Configure DAC execution plans for scheduling to run ETL processes.

Environment: Erwin, Visio, SQL, PL/SQL, Excel, Agile, JIRA, ETL Informatica, Microsoft Office Suite, Microsoft Visio, Oracle, XML Files, Excel, Flat files, Java SQL Server, Teradata, Sharepoint, UNIX, Business Objects.

Sr. Data Analyst/Business Analyst/Data Modeler/SQL Analyst

Responsibilities:

• Extensively involved in every phase of the SDLC process starting from Inception to Transition
• Interviewed Business Users to gather reporting / data requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Created Logical/physical Data Model in ERwin and have worked on loading the tables in the Data Warehouse
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work.
• Wrote complex SQL to identify granularity issues and relationships between data sets and created recommended solutions based on analysis of the query results
• Created Data mapping, logical data modeling coordinating with data architects, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Created implementation checklist, using MS Excel for turnover to Application Continuity and Production Support.
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation
• Created and Designed logical database schema layout structure to prepare for ETL processes, data mining, extraction, Analysis and Reporting System
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements
• Conducted Joint Application Development (JAD) sessions with IT groups
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Created adhoc reports and pivot tables in Excel using VBA and macros.
• Worked on Documentum for Version Controlling, to maintain up to date changes in the Documents
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Analyze the Business Object reports/extracts and submit to the Risk manager after the proper validation.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Environment: SQL, PL/SQL, ETL Informatica, AGILE, JIRA, Erwin, HP QC /ALM, Agile, XML, Teradata, Visio, Erwin, Windows and UNIX, TOAD for Oracle 10g, MS SQL Server 2008R2, Excel, Access, MS PowerPoint, MySQL, MS Excel, BI Business Objects

Data Analyst/Business Analyst/Data Modeler/SQL Analyst

Responsibilities:

• Experience in all phases of the Data warehouse life cycle involving Analysis, Design, Development and Testing as a part of Data Quality Design framework. Development of Extraction and Loading using Informatica.
• Prepared SQL & PL/SQL Queries to validate the data in both source and target databases.
• Applied data cleansing/data scrubbing techniques to ensure consistency amongst data sets. Developed process for capturing and maintaining metadata from all data repository components.
• Solely responsible for designing and migrating the Data quality framework from composite to Informatica.
• Used various transformations like Source Qualifier, Expression, Normalizer, Aggregator, Filter for Designing and optimizing the Mapping.
• Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Profiled various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.). Followed company code standardization rule. Created various tasks like Session, Command, and email task.
• Worked on SQL Developer to develop queries in Oracle. Interaction with the offshore team on a daily basis and Analyzed the business requirements and functional specifications.
• Developed complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards. Perform small enhancements (data cleansing/data quality).
• Extracted data from oracle database and Teradata, applied business logic to load them in the Teradata database. Parameterized the mappings and increased the re-usability.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
• Followed Informatica recommendations, methodologies and best practices on the development activities.
• Extensively worked on Mapping Variables, Mapping Parameters and Session Parameters.
• Developed process for capturing and maintaining metadata from all data repository components.
• Created Generated Complex reports in Cognos report studio including Drill Down reports from DMR modeled Frame work model.
• Experience in using Informatica command line utilities like PMCMD to control workflows in non-windows environments. Automated the Informatica jobs using UNIX shell scripting.
• Closely worked with the reporting team to ensure that correct data is presented in the attached reports, which was automatically being sent once DQ process is completed.
• Prepared Low level design document through interaction with team lead and manager
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Independently perform complex troubleshooting, root-cause analysis and solution development.

Environment: ETL Informatica, Cognos, SQL, PL/SQL, UNIX, Erwin, Excel, Access, Oracle, Teradata, Java, .Net, HP Quality Center and Microsoft Office.

Data Modeler/Data Analyst

Responsibilities:

• Analyzed Data sources and requirements and business rules to perform logical and physical Data Modeling.
• Played an active role as a member of Project team to provide business data requirements analysis services, producing conceptual and logical data models.
• Designed the DataMart's using Ralf Kimball's Dimension DataMart modeling methodologies using ERWIN.
• Worked with the DBA to convert logical Data models to physical Data models for implementation
• Extensively used Normalization techniques (upto3NF)
• Created database objects like Tables, Stored Procedures, Indexes, Sequences, Views, and Rules etc.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and Bulk collects.
• Created a Data Mapping document after each assignment and wrote the transformation rules for each field as applicable

Environment: SQL, PL/SQL, MS Visio, MS Excel, Oracle 9i

Business Analyst/Data Analyst

Responsibilities:

• Responsibilities included gathering and preparation of requirements, functional specifications, technical specifications, and the design of the database.
• Involved in gathering user requirements along with the Business Analyst. Part of the team responsible for the analysis, design, and implementation of the business solutions.
• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Prepared business case for the data mart and then developed and deployed it. Used Star schema methodology in building and designing the logical data model in the dimensional Models.
• Mapped the data between Source and Targets.
• Co-ordinated with QA team to test and validate the reporting system and its data. Suggested effective implementation of the applications, which are being developed.
• Documented data quality and traceability documents for each source interface.
• Documented, clarified, and communicated change requests with the requestor and coordinated with the development and testing team.

Environment: Oracle 10g/11g, PL/SQL, SQL Server 2005, Toad, Unix