SUMMARY

• Over 7 years of IT experience in the field of Data analysis, Data Modeling, ETL Development, and Project Management.
• Strong experience in Data Analysis, Data Modeling, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Governance, Data Integration and Metadata Management Services and Configuration Management.
• 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.
• 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 translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML).
• Over 3 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 .
• Strong experience in transforming requirements into a “logical” solution, physical data model, detailed data flow between tables and/or views.
• Extensively worked on Oracle 10g/11g, and MySQL Databases.
• Experience working with XML/Database Mapping, writing SQL queries and joins.
• Experience in coding SQL/PL SQL using Procedures, Triggers and Packages.
• Experience in performing Unit Testing, System Integration Testing.
• Experience in creating test cases to validate the business requirements implemented correctly
• Ability to collaborate with peers in both business and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
• Good understanding of Relational Database Design, Data Warehouse/OLAP concepts and methodologies.
• Experience in creating dimensional and relational data model for banking and healthcare domain using ERWIN.
• Good understanding of Teradata models and in depth knowledge of subject areas in banking and healthcare models.
• Experience in Teradata as the target for the data marts, worked with BTEQ, Fast Load and MultiLoad.
• Knowledge in Business Intelligence tools like Business Objects, MSBI, Tableau, QlikView.
• Good experience with Metadata Management, Data Migration, Data Conversions, and validation for Data consistencies.
• Experience in implementing normalization/ denormalization techniques for optimum performance in OLAP/OLTP database environments.
• 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 the customer and feasible for the developers and to limit a project’s exposure to the forces of change.
• Worked in Agile Methodologies for the implementation of the project.
• Worked on different platforms such as Windows 95/windows/98/NT and UNIX, Sun Solaris, AIX, HP
• Experience in working with different industries like Banking, Healthcare, Media and Housing Finance.
• Implemented Optimization techniques for better performance on the ETL side and also on the database side.
• Experience in creating functional/technical specifications, data design documents based on the requirements.
• Excellent Communication, interpersonal, analytical skills and strong ability to perform in a team as well as individually.

TECHNICAL SKILLS

Languages: Confidential -SQL, PL/SQL, R, BTEQ

Data Visualization: Tableau, QlikView

Data Analysis: SQL, Informatica Analyst, MS Excel

Modeling Technique: Relational Modeling, Dimensional Modeling

Web Technologies: HTML, DHTML, JAVA Script, XML

Database: MS SQL Server (2012/2008, 2005/ 2000/ 7.0 ), MS-Access, Toad Oracle 10g/11c, Teradata.

Reporting: SQL Server Reporting Services (SSRS), Tableau, QlikView

Process/Model Tools-: ERWIN, MS Word, MS Excel, MS PowerPoint

PROFESSIONAL EXPERIENCE

Confidential, Buffalo, NY

Sr. Data Analyst

Responsibilities:

• Working on Teradata, MS SQL Server 2008/2012, Informatica.
• Conducting meetings to understand business requirements and translate those in technical language.
• Conducted meetings with business to understand data warehouse and data migration of a newly acquired bank.
• Coordinated meetings with vendors to define requirements and system interaction agreement documentation between client and vendor system.
• Responsible for defining the key identifiers for each mapping/interface.
• Performing data profiling using Informatica Analyst.
• Develop Confidential -SQL queries to ensure business requirements are implemented correctly.
• Wrote complex queries in Confidential -SQL to manipulate the data as per the mapping specifications.
• Writing complex SQL queries to perform data analysis.
• Analyzing the data, identifying source of data and data mapping.
• Writing test scripts to perform SCD (Slowly Changing Dimension), CDC (Change Data Capture), Data De-duplication.
• Worked with business team to make sure test scripts are run with no defect.
• Performing impact analysis of system upgrade on data warehouse and downstream application.
• Involved in checking data lineage from source to target.
• Develop source to target mapping document to ensure data flows correctly from source system to target system using business transformation logic.
• Understanding business requirements and developing trust rank, match, and merge rules.
• Review business rules with data governance team and provided mock-up for data simulation and business review.
• Collaborate with data modelers, ETL developers in creating the Data Functional Design Document.
• Work with business people and ETL developers in the analysis and resolution of data related problems.
• Document the complete process flow to describe program development, logic, testing, and implementation, application integration.
• Worked with data modelers to create logical and physical data models using ERWIN.
• Worked with modeling and development team for inbound mapping to get the data needed and move from stage to base.

Environment: Teradata, Microsoft SQL server 2008, Microsoft SQL Server 2012, Confidential -SQL, Informatica MDM, MS Excel, Informatica 9.5.0, Windows 7, Tableau.

Confidential, Boston, MA

Sr. Data Analyst

Responsibilities:

• Led requirements gathering activities and JAD sessions to determine, analyze, and document business processes and fundamentals, and strategic data needs.
• Scheduled meetings with developers, system analyst and testers to collaborate resource allocation and project completion using MS Project.
• Designed and implemented basic PL/SQL queries for testing and report/data validation.
• Used Data warehousing for Data Profiling to examine the data available in an existing database and also created Data Mart.
• Developed and tested PL/SQL scripts and stored procedures designed and written to find specific data.
• Participated in the requirements analysis and the data definition for the Oracle based system.
• Worked with business users to translate requirements, process flows, and business rules into data models and GUI designs.
• Responsible for understanding the design and structure of different databases and writing ad-hoc queries for data mining using different data mining tools
• Extensive PL/SQL querying on Staging, Data warehouse and Data Marts.
• Identified and documented data sources and transformation rules required populating and maintaining data warehouse content.
• Performed data analysis using SQL queries on source systems to identify data discrepancies and determine data quality.
• Assisted in migration of data models from Oracle Designer to Erwin and updating the data models to correspond to the existing database structures.
• Ensured Error logs and audit tables are generated and populated properly.
• Analyzed and designed the business rules for data cleansing that are required by the staging and OLAP & OLTP database.
• Was responsible for indexing the tables in the data warehouse.
• Implemented the Data Cleansing using various transformations.
• Gathered and documented the Audit trail and traceability of extracted information for data quality.

Environment: SQL/Server, Toad Oracle, AQT (Advanced Query Tool), MS-Office, Informatica, ERWIN, XML, Business Objects.

Confidential, Lexington, KY

Data Analyst

Responsibilities:

• Interacted with end client and business analysts to gather requirements.
• Worked on designing star schema for detailed data marts and plan data marts involving conformed dimensions.
• Conducted logical data analysis and data modeling JAD sessions, communicated data standards.
• Involved in capturing all business entities, logical and physical data model designs to demonstrate business process flow, DDL scripts for database objects using Erwin.
• Establish and maintain data standards.
• Identified opportunities for standardizing data description, integration and archiving and elimination of unnecessary redundancy.
• Creation of enterprise metadata that can be used across all line of businesses in Confidential .
• Created technical documentation for data architecture team, ETL mappings, Source-to-Target mapping, Data model design and capture change artifacts.
• Analyzed data results from use of business processing software and provides conceptual solutions to system design work.
• Created data mapping documents to capture source of data, business rule to be applied to meet customer needs and target for data.
• Performed data analysis at source level and determined key attributes fro designing Fact and Dimension tables using star schema for an effective data warehouse.
• Created stored procedures, functions and packages as per business needs for developing ad hoc and robust reports.
• Handled the entire testing process including test data creation, developing test cases, execution, and data validation.
• Prepared test data and compared the expected results with the actual results.
• Documented the test requirements and set the traceability between different requirements.
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines

Environment: SQL/Server, Oracle 9i, MS-Office, Teradata, Informatica, ERWIN, XML, Tableau

Confidential, California, LA

Data Analyst

Responsibilities:

• Work with users to identify the most appropriate source of record and profile the data required for sales and service.
• 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
• Involved in defining the source to target data mappings, business rules, business and data definitions
• 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.
• 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.
• 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.

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 the upper level management using Stored Procedures and MS SQL Server 2005 Reporting Services (SSRS) following the 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 Confidential -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, Confidential -SQL, Enterprise manager, VBS, Qlikview