SUMMARY:

• 8 years of IT experience in the field of Business/Data analysis, ETL/Report Development, Data Modeling, and Project Management.
• Experience in SQL queries, Stored Procedures, Triggers and Packages using SQL/T - SQL.
• Extensive experience in Data warehousing projects developing ETL in SSIS/DTS and Reports in SSRS.
• Good understanding of Relational Database Design, Data Warehouse/OLAP concepts and methodologies.
• Experience in Working with different industries like Financial, Insurance and Banking.
• Implemented Optimization techniques for better performance on the ETL side and also on the database side.
• 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 and design.
• Extensive experience in using various data visualization tools like Tableau, BO, Crystal Reports, Power BI etc.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services and Configuration Management
• Hands on experience in logical, physical, and dimensional data modeling, data mapping, and data normalization, well versed in ERWIN.
• Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
• Extensive experience in performing current state process assessment, gap analysis and proposing improvements
• 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.
• Holds strong ability to handle multiple priorities and work load and also has ability to understand and adapt to new technologies and environments faster

TECHNICAL SKILLS:

Languages: SQL, T-SQL, PL/SQL

Databases: MS SQL Server, DB2, Oracle, MS Access, Teradata

Data Modelling: Erwin 4.0, Power Designer, Microsoft Visio 2003

ETL Tools: SSIS, SQL * Loader

Operating Systems: Windows NT/95/98/2000/XP/Vista/Windows 7/ Windows 8

Reporting/Analysis: SSRS, Business Objects 5.0, Crystal Reports, Tableau

Tools: SSMS, DTS, BIDS, Visual Studio, Toad, AQT, TFS, Quality Center

PROFESSIONAL EXPERIENCE:

Confidential, Frederick, MD

Sr. Data Analyst

Responsibilities:

• Documenting Business, Functional, and Non-functional requirements for Agency and District Growth Model.
• Involved in current state project assessment and Gap Analysis.
• Creating high level Data flow diagrams using Microsoft Visio.
• Propose the effort estimate for the changes as they come in. Manage and deliver changes as discussed
• Ad hoc reporting utilizing such languages and applications as EXCEL, SQL, COGNOS
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema, star schema and database objects.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Design and develop (ETL) packages for loading data from DB2, Oracle 10g and Flat files to SQL Server 2008 R2/2012 Data base
• Involved in creating Table Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services 2008R2/2012.
• Used SSRS, Tableau, Qlikview for Ad-Hoc reporting.
• Produced routine and ad hoc reports, to respond to immediate customer request.
• Written T-SQL statements for retrieval of data and also involved in performance tuning of TSQL queries
• Utilized Quality Center to track Defects/Change requests.
• Utilized Share Point as a document repository.
• Involved in Production support and Data Certification activities.
• Responsible for independently investigating/researching issues, determining impact, and providing solutions.

Environment: SQL/Server, PL/SQL, Oracle 9i, MS-Office, Teradata, ER Studio, XML, Business Objects, 2012/2014 SQL Server, Cognos, Tableau, Qlikview

Confidential, Los Angeles, CA

Sr. Data Analyst

Responsibilities:

• Worked in a Scrum Agile process & Writing Stories with two week iterations delivering product for each iteration
• Created data governance and privacy policies specifying WMS (Warehouse Management System implementation
• Defined accountability procedures governing data access, processing, storage, retention, reporting and auditing measuring contract compliance
• Documenting the requirements, functional specs, technical specs for Facing Fill rate process.
• Created Data flow and Process flow swim lane diagrams.
• Participated in all steps SDLC Life cycle (Analysis, design, development, and implementation) of the project.
• Track project status and participate in meeting with clients to give project status update and gather details on changes.
• Propose the effort estimate for the changes as they come in. Manage and deliver changes as discussed.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Developed physical data models and created DDL scripts to create database schema and database objects
• Design and develop SSIS (ETL) packages for loading data from DB2, Oracle 10g and Flat files to SQL Server 2008 R2 Data base
• Involved in creating Table Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services 2008.
• Built the SSRS reports from Different Databases like Oracle, DB2 and SQL Server
• Written T-SQL statements for retrieval of data and also involved in performance tuning of TSQL queries
• Effectively used SQL Profiler, Trace Analysis and Execution plans as part of troubleshooting and performance tuning.
• Involved in writing and executing Test Cases to evaluate the ETL packages.
• Develop and maintain the programs in SQL Server Integration Services and T SQL.
• Used data analysis techniques to validate business rules and identify low quality missing data in the existing WMS data warehouse.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.

Environment: Teradata 13.1, Informatica 6.2.1, Ab Initio, Business Objects, Cognos, Oracle 9i, PL/SQL, Microsoft Office Suite (Excel, Vlookup, Pivot, Access, Power Point), Visio, UNIX, Erwin.

Confidential, Woodlawn, MD

Sr. Data Analyst

Responsibilities:

• Met Customers to determine User requirements and Business Goals.
• Blended technical and business knowledge with communication skills to bridge the gap between internal business and technical objectives and serve as an IT liaison with the business user constituents.
• Worked closely with the claims processing team to obtain patterns in filing of fraudulent claims.
• Conducted JAD sessions to gather requirements, performed Use Case and work flow analysis, outlined business rules, and developed domain object models.
• Involved in migrating data from data warehouses on Oracle/DB2 to SQL Server.
• Responsible for management of data, duplicating the data and storing the data in to specific data warehouse using Talend Platform for Data Management and MDM.
• Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.
• Interacted 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
• Transformations of requirements into data structures, which can be used to efficiently store, manipulate and retrieve information.
• Collaborated with data modelers, ETL developers in the creating the Data Functional Design documents.
• Worked with internal architects and, assisting in the development of current and target state enterprise 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.

Environment: Oracle 10g, Sql-2008, PL/SQL, Teradata, Microsoft Excel, Microstrategy, MS Visio, MS Project, Informatica.

Confidential

Data Analyst

Responsibilities:

• Sourcing the data from multiple sources and merging and cleansing the obtained data.
• Involved in defining the trumping rules applied by Master Data Repository
• Extracting and gathering the requirements in coordination with Line of Business.
• Applying transformation logic to the data to obtain data in the required format and data structure and ensure the data aligns to the format set by the Federal Reserve.
• Implementing the requirements using SSIS, T-SQL, and SSMS.
• Writing the requirements and dropping the code for ETL for implementation.
• Assist ETL developers in creating and populating the database tables.
• Enforcing consistent naming standards for the data elements across all the data being reported.
• Responsible for creating test cases to check for failures based on the Federal Reserve Guidelines, thus ensuring quality
• Supporting the QA team with any issues and was responsible for mitigation of the errors using the Quality Center.
• Coordinating with Lines of Business to solve unusual issues.
• Responsible for validation and verification of final data.
• Supporting end to end testing of the data from source to target based on the requirements and mapping documents.
• Diagnosis of the bugs found during testing and resolving the issues based on the priority.

Environment: Oracle 10g, Sql-2008, PL/SQL, Teradata, Microsoft Excel, Microstrategy, MS Visio, MS Project, Informatica.

Confidential

SQL Developer

Responsibilities:

• Involved in the design of the overall database using Entity Relationship diagrams.
• Wrote triggers, menus and stored procedures in T-SQL/PL-SQL.
• Gather requirements for interactive forms and customization of screens.
• Involved in debugging and running forms/screens.
• Involved in Data loading and Extracting functions using SQL*Loader and DTS.
• Designed and developed all the tables, views.
• Designing and developing forms validation procedures for query and update of data.

Environment: Oracle 8.0, SQL*plus, SQL*Loader, PL/SQL, Forms 4.5, Reports 2.5