SUMMARY:

• Over 7 years of IT experience in teh field of Data/ Business analysis, ETL Development, Data Modeling, and Project Management.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Governance, Data Integration and Metadata Management Services and Configuration Management.
• Over 2+ years of experience in Data Modeling with expertise in creating Star & Snow - Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin and Embarcadero.
• Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
• Knowledge in Business Intelligence tools like Business Objects, MSBI, Cognos and OBIEE.
• Experience with Teradata as teh target for teh data marts, worked with BTEQ, Fast Load and MultiLoad.
• Strong experience in interacting with stakeholders/customers, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools.
• Experience in various phases of Software Development life cycle (Analysis, Requirements gathering, Designing) with expertise in documenting various requirement specifications, functional specifications, Test Plans, Source to Target mappings, SQL Joins.
• Experience in conducting Joint Application Development (JAD) sessions for requirements gathering, analysis, design and Rapid Application Development (RAD) sessions to converge early toward a design acceptable to teh customer and feasible for teh developers and to limit a project’s exposure to teh forces of change.
• Worked in Agile Methodologies for teh implementation of teh project.
• Experience in coding SQL/PL SQL using Procedures, Triggers and Packages.
• Good understanding of Relational Database Design, Data Warehouse/OLAP concepts and methodologies.
• Worked on different platforms such as Windows 95/windows/98/NT and UNIX, Sun Solaris, AIX, HP
• Experience in Working with different industries like Financial, Media, Retail and Banking.
• Implemented Optimization techniques for better performance on teh ETL side and also on teh database side.
• Experience in creating functional/technical specifications, data design documents based on teh requirements.
• Excellent Communication, interpersonal, analytical skills and strong ability to perform in a team as well as individually.

TECHNICAL SKILLS:

Languages: T-SQL, Pl/SQL, R, Python

Data Visualization: Tableau

Data Analysis: SAS, R

Modeling Technique: Predictive Modeling/ANOVAs/Linear Regression, Logistics Regression/Cluster analysis

Web Technologies: HTML, DHTML, JAVA Script, XML

Databases: MS SQL Server (2012/2008, 2005/ 2000/ 7.0 ), MS-Access, Oracle 10g

Reporting: Server Reporting Services (SSRS), Tableau

Process/Model Tools: MS Office,MS Project,Visio,Rational Rose,Requisite

PROFESSIONAL EXPERIENCE:

Confidential, Plano,TX

Senior Data Analyst

Responsibilities:

• Worked with users to identify teh most appropriate source of record and profile teh data required for sales and service.
• Documenting teh complete process flow using Visio to describe program development, logic, testing, and implementation, application integration, coding.
• Responsible for defining teh key identifiers for each mapping/interface.
• Involved in defining teh source to target data mappings, business rules, and business and data definitions.
• Responsible for defining teh key identifiers for each mapping/interface
• Responsible for defining teh functional requirement documents for each source to target interface.
• Document, clarify, and communicate requests for change requests with teh requestor and coordinate with teh development and testing team.
• Coordinated meetings with vendors to define requirements and system interaction agreement documentation between client and vendor system.
• Remain knowledgeable in all areas of business operations in order to identify systems needs and requirements.
• Establish standards of procedures.
• Worked with internal architects and, assisting in teh development of current and target state data architectures
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines
• Generate weekly and monthly asset inventory reports.
• Document data quality and traceability documents for each source interface
• Consolidatingdatafrom multiple sources in support of campus wide decision making and related information needs such as reporting, analysis, and planning (EDW).
• Created SQL server Analysis Projects and created Multi-dimensional databases and OLAP Cubes and dimensions for teh analysis of sales in specific areas using SSAS.
• Experience with Vertica as teh target for teh data marts (tables), worked with Postgres SQL for creating sample data, and created process flow diagrams using Visio.
• Support development teams creating applications against supported databases.
• Provide 24 x 7 problem management support to teh development team.
• Document various Data Quality mapping document, audit and security compliance adherence.
• Work with teh business and teh ETL developers in teh analysis and resolution of data related problem tickets.
• Experience in Microstrategy for pulling out teh reports during mapping analysis and also assisted in building reports for inventory and sales/polling.
• Deployed analysis projects using SSAS based on data volume, as well as developed of KPI’s which helped teh Business users for easy understanding.
• Experience in designing and developing Data Warehouse applications using ETL and Business Intelligence tools like Informatica Power Center (9.x/8.1/7.x/6.x/5.x) /Power Mart 4.7, Datastage, Mainframes SAS, SSAS, SSIS, OLTP,OLAP, Business Objects.
• Experience in coding SQL/PL SQLusing Procedures, Triggers and Packages.
• Worked on Advanced Excel for Data Mapping and Data Analysis Reports.
• Involved in testing teh code generated by teh developers and executed/evaluated manual or automated test cases and reported test results.

Environment: Erwin r9, PostgreSQL, Server 2008, Unix AIX version 6,HP Vertica Analytics Platform 6.1.x, MicroStratagy desktop V 9.3.1, OBIEE, MS Excel, MS Visio 2013, TOAD, SQL, PL/SQL, Rally, Quickbase, Windows.

Confidential, Deloitte

Sr. Data Analyst

Responsibilities:

• Work with users to identify teh most appropriate source of record and profile teh data required for sales and service.
• Document teh complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Involved in defining teh business/transformation rules applied for sales and service data.
• Define teh list codes and code conversions between teh source systems and teh data mart.
• Worked with internal architects and, assisting in teh development of current and target state data architectures
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines
• Involved in defining teh source to target data mappings, business rules, business and data definitions
• Responsible for defining teh key identifiers for each mapping/interface
• Responsible for defining teh functional requirement documents for each source to target interface.
• Document, clarify, and communicate requests for change requests with teh requestor and coordinate with teh development and testing team.
• Coordinated meetings with vendors to define requirements and system interaction agreement documentation between client and vendor system. teh Enterprise Metadata Library with any changes or updates
• Document data quality and traceability documents for each source interface
• Establish standards of procedures.
• Generate weekly and monthly asset inventory reports.
• Experience with Teradata as teh target for teh data marts, worked with BTEQ, Fast Load and MultiLoad.
• Evaluated data profiling, cleansing, integration and extraction tools(e.g. Informatica)
• Coordinate with teh business users in providing appropriate, effective and efficient way to design teh new reporting needs based on teh user with teh existing functionality
• Remain knowledgeable in all areas of business operations in order to identify systems needs and requirements.
• Consolidatingdatafrom multiple sources in support of campus wide decision making and related information needs such as reporting, analysis, and planning (EDW).
• ProducedPL/SQL statement and stored procedures inDB2for extracting as well as writingdata
• Developed PL/SQL stored procedures for teh end-user report requirements
• Responsible for defining teh key identifiers for each mapping/interface
• Implementation of Metadata Repository, Maintaining Data Quality, Data Cleanup procedures, Transformations, Data Standards, Data Governance program, Scripts, Stored Procedures, triggers and execution of test plans
• Performed data quality in Talend Open Studio

Environment: SQL/Server, PL/SQL, Oracle 9i, MS-Office, Teradata, Informatica, ER Studio, XML, Business Objects

Confidential

Sr. Data Analyst

Responsibilities:

• Work with teh Project Management in teh creation of project estimates.
• Analysis of teh data identifying source of data and data mappings of HCFG.
• Worked extensively in documenting teh Source to Target Mapping documents with data transformation logic.
• Interact with teh SME’s to analyze teh data extracts from Legacy Systems (Mainframes and COBOL Files) and determine teh element source, format and its integrity within teh system
• Transformation of requirements into data structures which can be used to efficiently store, manipulate and retrieve information
• Collaborate with data modelers, ETL developers in teh creating teh Data Functional Design documents.
• Ensure that models conform to established best practices (including normalization rules) and accommodate change in a cost-effective and timely manner.
• Enforce standards to ensure that teh data elements and attributes are properly named,
• Work with teh business and teh ETL developers in teh analysis and resolution of data related problem tickets.
• Support development teams creating applications against supported databases.
• Provide 24 x 7 problem management support to teh development team.
• Document various Data Quality mapping document, audit and security compliance adherence.
• Perform small enhancements (SOR element additions, data cleansing/data quality).
• Create various Data Mapping Repository documents as part of Metadata services (EMR).
• Provide inputs to development team in performing extraction, transformation and load for data marts and data warehouses.
• Developed large number of standard and customized reports usingSSRSfor data feeds and for Reports on server.
• Involved in Creating and Testing theSSISpackages developed for security.
• ModifiedPL/SQLscripts to validate and loaddatainto interface tables. Teh backend was inOracleand database operations were handled using storedprocedures
• Developed PL/SQL stored procedures for teh end-user report requirements
• Actively involved in developing ComplexSSRSReports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs
• ProducedPL/SQL statement and stored procedures inDB2for extracting as well as writingdata
• Ensure that models conform to established best practices (including normalization rules) and accommodate change in a cost-effective and timely manner.
• Enforce standards to ensure that teh data elements and attributes are properly named,
• Work with teh business and teh ETL developers in teh analysis and resolution of data related problem tickets.
• Consolidatingdatafrom multiple sources for EDW.
• Support development teams creating applications against supported databases.
• Provide 24 x 7 problem management support to teh development team.
• Document various Data Quality mapping document, audit and security compliance adherence.
• Perform small enhancements (SOR element additions, data cleansing/data quality).
• Create various Data Mapping Repository documents as part of Metadata services (EMR).
• Provide inputs to development team in performing extraction, transformation and load for data marts and data warehouses.
• Provide support in developing and maintaining ETL processes that extract data from multiple SOR’s residing on various technology platforms then transport teh data to various delivery points such as data marts or data warehouses.

Environment: SQL Server 2005/2008 Enterprise Edition, SSIS 2005, MS Excel, MS Access, Oracle 10g, UNIX, Windows XP, SQL, PL/SQL, Power Designer, Informatica

Confidential, Minneapolis, MN

Sr. Data Analyst

Responsibilities:

• Work with users to identify teh most appropriate source of record and profile teh data required for sales and service.
• Document teh complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Involved in defining teh business/transformation rules applied for sales and service data.
• Define teh list codes and code conversions between teh source systems and teh data mart.
• Consolidatingdatafrom multiple sources in support of campus wide decision making and related information needs such as reporting, analysis, and planning (EDW).
• Worked with internal architects and, assisting in teh development of current and target state data architectures
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines
• Experience with Teradata as teh target for teh data marts, worked with BTEQ, Fast Load and MultiLoad.
• Involved in defining teh source to target data mappings, business rules, business and data definitions
• Worked with BTEQ to submitSQLstatements, import and export data, and generate reports in Terra-data.
• Responsible for defining teh key identifiers for each mapping/interface
• Collaborate with data modelers, ETL developers in teh creating teh Data Functional Design documents.
• Responsible for defining teh functional requirement documents for each source to target interface.
• Document, clarify, and communicate requests for change requests with teh requestor and coordinate with teh development and testing team.
• Coordinated meetings with vendors to define requirements and system interaction agreement documentation between client and vendor system.
• Work with teh business and teh ETL developers in teh analysis and resolution of data related problem tickets.
• Enterprise Metadata Library with any changes or updates
• Document data quality and traceability documents for each source interface
• Establish standards of procedures.
• Generate weekly and monthly asset inventory reports.
• Evaluated data profiling, cleansing, integration and extraction tools(e.g. Informatica)
• Coordinate with teh business users in providing appropriate, effective and efficient way to design teh new reporting needs based on teh user with teh existing functionality
• Remain knowledgeable in all areas of business operations in order to identify systems needs and requirements.
• Responsible for defining teh key identifiers for each mapping/interface
• Implementation of Metadata Repository, Maintaining Data Quality, Data Cleanup procedures, Transformations, Data Standards, Data Governance program, Scripts, Stored Procedures, triggers and execution of test plans
• Performed data quality in Talend Open Studio

Environment: SQL/Server, Oracle 9i, MS-Office, Teradata, Informatica, ER Studio, XML, Business Objects

Confidential

Responsibilities:

• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Created ad-hoc reports for teh upper level management using Stored Procedures and MS SQL Server 2005 Reporting Services (SSRS) following teh business requirements.
• Created reports by dragging data from cube and wrote mdx scripts.
• Created reports by extracting data from cube.
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Provide database coding to support business applications using Sybase T-SQL.
• Perform quality assurance and testing of SQL server environment.
• Develop new processes to facilitate import and normalization, including data file for counterparties.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.

Environment: SQL Server 2005 Enterprise Edition, T-SQL, Enterprise manager, VBS.