SUMMARY:

• Over 6+ years of IT experience in the 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.
• Experience in creating Ad - hoc reports, data driven subscription reports by using SQL.
• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design.
• Expert in Data Conversion, Normalization and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema using Erwin Tool.
• In-depth knowledge of RDBMS concepts with expert knowledge of constructing Relational Database according to business requirement.
• 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.
• Proficient in statistical analysis.
• Extensive experience in writing Complex Transact SQL (T-SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.
• 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.
• Good experience in development of reports using Crystal Reports, SSIS, SSRS, and Data Reports.
• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.
• Excellent interpersonal skills and leadership abilities. Fast learner with excellent analytical and communication skills.

TECHNICAL SKILLS:

Languages: T-SQL, PL/SQL

Databases: SQL Server 2012/2008/2005, MS Access, Oracle 11g/10g/9i, Teradata 14.0

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Informatica 9.5, Business Intelligence Development Studio (BIDS), Visual Studio, Crystal Reports

Tools: Erwin, TOAD, MS-Visio, SQL developer, SQL*Loader

Process/Model Tools: MS Office, MS Project, Visio, Rational Rose, RequisitePro, ClearCase, ClearQuest, MS Excel, MS Power Point, MS Word

Operating Systems: Windows Server 2012/2008/2003, Windows 8/7/XP, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Bala Cynwyd, PA

Data Analyst

Responsibilities:

• Gathered business and technical requirements;
• Analyze data stored in the source database to validate the data integrity and flow into the respective entities in the target Database;
• Worked on data transformation, data definition, SCD types, data reference, and defining the business rules;
• Analyzed and performed Data Profiling for reporting requirements;
• Created and altered SQL queries as per the requirements;
• Worked extensively in documenting the Source to Target Mapping documents with data transformation logic;
• Worked with technical leads, architects, subject matter experts and vendors to document technical data specifications in the template designed by Guidewire to deliver the business requirements for ETL developers;
• Re-Created Stored Procedure and performed column mappings as per the requirements;
• Performed Unit Testing to validate the column mapping;
• Worked as part of stabilization with QA and ETL developers to resolve any data quality and design issues;
• Created defects as the issues arises and worked to resolve it;
• Documented the process flow, design flow and different SQL logics for presentation and information in MS Visio;
• Report directly to the Business Analyst Manager with accountability to the Data Architect and Project Manager;

Environment: SQL Server 2012, MS Office 2010, Informatica 9.6.1Business Objects Data Services 4.2 SP6, Sharepoint 2013, Rally, HP ALM

Confidential, South Windsor, CT

Data Analyst

Responsibilities:

• Document the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Define the list codes and code conversions between the source systems and the data mart.
• 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 the source to target data mappings, business rules, business and data definitions.
• Analyze data stored in the data warehouse to validate the data integrity and flow into the respective entities.
• Extracted and analyzed billions of rows data through Teradata SQL, SAS scripts and Excel to solve complex business problems.
• Develop FASTLOAD and MLOAD scripts to load data from legacy system and flat files through Informatica to Teradata data warehouse.
• Building up VBA Macro for Processes which are recurring jobs to pull data for specific requirement.
• Created Daily, Weekly, monthly reports related by using Teradata and MS Excel.
• As per Ad-hoc request created tables, views on the top of the Data mart/ production databases by using Teradata, BTEQ, and UNIX.
• Created different set of tables (Like Set, Multiset, Derived, Volatile), Macros, views, procedures using SQL scripts
• Creating and executing DATA Test Plans and data test strategies for the projects.
• Involved in compiling, analyzing, and formatting data from multiple sources to create reports.
• Analyzed existing data processes to make recommendations for improvements.
• Worked with importing external data files and dealing with missing data and data anomalies in SAS data sets and raw data files.
• Analyze data, writing ETL scripts, designing data structures for efficient report access and creating reports.
• Developed strategy for the data management and best practices.
• Responsible for creating the complicated SQLs to verify the Business logic for the reports.
• Maintain SAS Data by using existing codes and develop new codes if necessary.
• Validation checks on the data warehouse for the Data integrity.
• Interacting with client to capture information on source data for preparing data scenarios for testing.
• Test the data in both testing and production environments to make sure the requirements have been met.
• Responsible for working along with Privacy, compliance & legal team to confirm the Affiliate sharing strategies and metadata.

Environment: SQL Server 2012, MS Office, Teradata 14.0, Informatica, ER Studio, XML, Business Objects, Windows Server 2012

Confidential, Roseville, CA

Data Analyst

Responsibilities:

• Work with the Project Management in the creation of project estimates.
• Worked in a Scrum Agile process & Writing Stories with two week iterations delivering product for each iteration.
• Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.
• Interact with the SME's to analyze the data extracts from Legacy Systems (Mainframes and COBOL Files) and determine the element source, format and its integrity within the system.
• Transformation of requirements into data structures which can be used to efficiently store, manipulate and retrieve information.
• 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.
• Defined accountability procedures governing data access, processing, storage, retention, reporting and auditing measuring contract compliance.
• Developed data stewardship program establishing metadata registry responsibilities.
• Implemented the Slowly changing dimension scheme (Type III) for most of the dimensions.
• Implemented the standard naming conventions for the fact and dimension entities and attributes of logical and physical model.
• Worked with business team to build various MDM rules in MDM repository.
• Involved with DATA governance team in developing the DATA rules to be followed regarding project requirements and designing the rules for MDM field's requirement for business requirements globally.
• Reviewed the logical model with Business users, ETL Team, DBA's and testing team to provide information about the data model and business requirements.
• Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines.
• Involved in defining the source to target data mappings, business rules and data definitions.
• Responsible for defining the key identifiers for each mapping/interface.
• Migrated three critical reporting systems to Business Objects and Web Intelligence on a Teradata platform.
• Created Excel charts and pivot tables for the Ad-hoc data pull.
• Developed large number of standard and customized reports using SSRS for data feeds and for Reports on server.
• Involved in Creating and Testing the SSIS packages developed for security.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Provide support in developing and maintaining ETL processes that extract data from multiple SOR's residing on various technology platforms then transport the data to various delivery points such as data marts or data warehouses.
• Support development teams creating applications against supported databases.
• Provide 24 x 7 problem management support to the development team.

Environment: SQL Server 2008R2, SSIS, MS Excel, MS Access, Oracle 10g, Windows Server 2008, SQL, PL/SQL, Power Designer, Informatica

Confidential, Philadelphia, PA

Data Analyst

Responsibilities:

• Work with users to identify the most appropriate source of record and profile the data required for sales and service.
• Document the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Involved in defining the business/transformation rules applied for sales and service data.
• Define the list codes and code conversions between the source systems and the data mart.
• Worked with internal architects and, assisting in the 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 the source to target data mappings, business rules, business and data definitions.
• Worked with BTEQ to submit SQL statements, import and export data, and generate reports in Teradata.
• Responsible for defining the key identifiers for each mapping/interface.
• Responsible for defining the functional requirement documents for each source to target interface.
• Document, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
• Coordinated meetings with vendors to define requirements and system interaction agreement documentation between client and vendor system.
• 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 the business users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality.
• Remain knowledgeable in all areas of business operations in order to identify systems needs and requirements.
• Responsible for defining the 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 2008, Oracle 9i, MS-Office, Teradata, Informatica, ER Studio, XML, Business Objects