SUMMARY

• 8+ years of professional experience in the Information Technology (IT) Industry serving as a Data Analyst.
• Experience in Data analysis, Business Process Analysis/Modeling, Business Requirements Gathering, Database Design, Data Analysis, Data warehousing, Data Mapping, Development of Web Based, and Client/Server Applications with domain of Banking, finance and Insurance.
• Hands on experience on Full life cycle of the project using methodologies like Agile, Waterfall, RUP and hybrid methods.
• Extensive experience on interaction with system users in gathering business requirements and involved in developing projects. Chaired and conducted JAD sessions with business and technical teams.
• Expert in analyzing/troubleshooting and providing technical support for Oracle/Unix applications and their interfaces.
• Extensive experience on business intelligence (and BI technologies) tools such as OLAP, Data warehousing, reporting and querying tools, Data mining and Spreadsheets.
• Experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using data modeling tool like ERWIN.
• Extensively involved in MDM to help the organization with strategic decision making and process improvements. (Streamline data sharing among personnel and departments)
• Vast experience of working in the area data management including data analysis, gap analysis and data mapping.
• Experience in Data Transformation, Metadata, Data dictionary, Data Loading, Modeling and Performance Tuning.
• Experience in DBMS/RDBMS implementation using object - oriented concept and database toolkit.
• Experienced in creating documentation, providing production support, development and enhancements on oracle (SQL, PLSQL), UNIX and Cognos/QlikView (BI Tools) projects.
• Extensive experience in Data Analysis and ETL Techniques for loading high volumes of data and smooth structural flow of the data.
• Adept at writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary and Interface requirements documents.
• Worked on integration and implementation of projects and products, database creations, modeling, calculation of object sizes, table spaces and database sizes.
• Experience with creating reports using Business Objects.
• Well versed in system analysis, ER/Dimensional Modeling, Database design and implementing RDBMS specific features
• Involved in testing the complex COGNOS reports developed, supporting the Testing Team, writing the Test cases and creating the Test Data.
• Created and executed Test Plan, Test Scripts, and Test Cases based on Design document and User Requirement document for testing purposes.
• Extensive experience in the testing environment, which included User Acceptance Testing (UAT), functional testing and system testing and defect tracking using ClearQuest.
• Coordinated and prioritized outstanding defects and system requests based on business requirements. Acted as a liaison between the development team and the management team to resolve any conflicts in terms of requirements.
• Experience with Star schema modeling and knowledge of Snowflake dimensional modeling.
• Experience with SQL, PL/SQL objects. Involved in creating Packages, writing Procedures and Functions. Tuning using various types of Partitioning and Indexes.
• Interacted with all levels of the project development team, from end users to Software Architects, Technical Lead, Database Administrators, and System Administrator
• Excellent knowledge in Database Creation and maintenance of physical data models with Oracle, Netezza, DB2 and SQL Server databases.
• Experience in Data Integrity constraints, Performance Tuning, Repairing dead locks, Query Optimization and Validation issues.
• Good experience with hive meta store database and logs and configure the proxy user groups to access and override the control and security management.
• Experienced in creating documentation, providing production support, development and enhancements on oracle
• (SQL, PLSQL), UNIX and Cognos/QlikView (BI Tools) projects.
• Possess strong Documentation skills and knowledge sharing among team, conducted data modeling review sessions for different user groups, participated in sessions to identify requirement feasibility
• Excellent communication and interpersonal skills with a clear view of business process flow.

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, Texas

Sr. Data analyst

Responsibilities:

• Worked closely with data mapping SME and QA team to understand the business rules for acceptable data quality standards.
• Performed data profiling on datasets with millions of rows on Teradata environment, validating key gen elements, ensuring correctness of codes and identifiers, and recommending mapping changes.
• Wrote complex SQL queries to identify granularity issues and relationships between data sets and created recommended solutions based on analysis of the query results
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Delivered Enterprise Data Governance, Data Quality, Metadata, and ETL Informatica solution
• Maintained Excel workbooks, such as development of pivot tables, exporting data from external SQL databases, producing reports and updating spreadsheet information.
• Interfaced with business users to verify business rules and communicated changes to ETL development team.
• Creating and executing SQL queries to perform Data Integrity testing on a Teradata Database to validate and test data using TOAD.
• Performed troubleshooting, fixed and deployed many Python bug fixes of the two main applications that were a main source of data for both customers and internal customer service team.
• Developed Python scripts/solutions that will connect to snowflake and execute queries and generate reports in CSV/Xlsx formats.
• Participates in the creation of data standards, policies and procedure to ensure future data quality.
• Build Data Quality projects/solutions using Trillium Software System for customers.
• Analyzed SQL performance using Teradata viewpoint
• Performed ETL process and extracted the data from different source systems like Teradata, Sales force, MS SQL Server, Flat files, XML.
• Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
• Worked with data architects’ team to make appropriate changes to the data models.
• Worked on the ETL Informatica mappings and other ETL Processes (Data Warehouse)
• Met with stakeholders and users to review / manage expectations and identify opportunities to improve ROI.
• Performed extensive data modeling to differentiate between the OLTP and Data Warehouse data models
• Analyzing andminingbusiness data to identify patterns and correlations among the various data points.
• Provided multiple demonstrations of Tableau functionalities and efficient datavisualizations approaches using Tableau to the senior management at the client as part of the BRD.
• Involved indatavalidation of the results in Tableau by validating the numbers against the datain the database tables by querying on the database
• Acquire data from primary or secondary data sources like RedShift, FTP, and external or internal files; extract and analyze data to generate reports.
• Participated in initial MDM implementations and future rollouts. Involved in creating, monitoring, modifying, & communicating the project plan with other team members.
• Involved in creating logical and physicaldatamodeling with STAR and SNOWFLAKE schema techniques using ErwininDatawarehouse as well as inDataMart.
• Worked in database objects like tables, views, materialized views, procedures and packages using Oracle tools like Toad, PL/SQLDeveloper andSQLplus.
• Involved in physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, and Dimensions), Entities, Attributes, OLAP, OLTP, Cardinality, and ER Diagrams.
• Developed control files forSQLLoader and PL/SQLprograms for loading and validating thedatainto the Database.
• Created Stored Procedures in bothSQLServer and DB2 and involved in several DTS.
• Created various transformation procedures by using SAS, ETL and SAS Enterprise guide.
• Involved inDataModeling of both Logical Design and Physical Design ofDataWarehouse andDataMarts in Star Schema and Snow Flake Schema methodology.
• Involved in Informatica MDM processes including batch based and real-time processing.
• Responsible for reviewingdatamodel, database physical design, ETL design, and Presentation layer design.

Confidential, Lafayette, Louisiana

Data analyst

RESPONSIBILITIES:

• Collaborated with cross-functional team in support of business case development and identifying modeling method(s) to provide business solutions. Determines the appropriate statistical and analytical methodologies to solve business problems within specific areas of expertise.
• Built models and solves complex business problems where analyses of situations and/or data require in-depth evaluation of variable factors.
• Generated Data Models using Erwin and developed relational database system and involved in Logical modeling using the Dimensional Modeling techniques such as Star Schema and Snow Flake Schema.
• Participated in documenting the data governance framework including processes for governing the identification, collection, and use of data to assure accuracy and validity.
• Performed Metrics reporting, data mining and trends in helpdesk environment using Access
• Involved in creating Informatica mapping to populate staging tables and data warehouse tables from various sources like flat files DB2, Netezza and oracle sources.
• Involved in loading the data from the flat files submitted by vendors into the Oracle12c External tables, extensively used ETL to load data from Oracle database, XML files, and Flat files data and also used import data from IBM Mainframes.
• Involved with ETL team to develop Informatica mappings for data extraction and loading the data from source to MDM Hub Landing tables.
• Involved in MDM Process including data modeling, ETL process, and prepared data mapping documents based on graph requirements.
• Used Pivot tables, VLOOKUP’s and conditional formatting to verify data uploaded to proprietary database and online reporting.
• Coordinated with Data Architects and Data Modelers to create new schemas and view in Netezza for to improve reports execution time, worked on creating optimized Data-Mart reports.
• Used both Kimball and Bill Inman methodologies for creating data warehouse and transformed data from different OLTP systems.
• Worked on Rapid SQL to get access to Sybase Data base to see impacted table and column that is affected by upgrade
• Facilitated on Release session among customers to check as to what is the functionality, they would like to enhance which are available in Facets.
• Created conceptual diagram using MS. Visio of the business process to find out the impacted area and to fix the problem.
• Independently worked on owning IT support tasks related to Tableau Reports on Server.
• Primary subject matter expert in implementing Oracle's self-service OBIEE reporting system. This system allows for real-time data to be accessible at all HR locations throughout the company.
• Evaluate, identify, and solve process and system issues utilizing business analysis, design best practices and recommended enterprise and Tableau solutions.
• Used advanced functions like VLOOKUP’s, Pivots, graphs, and analytical and statistical tool packs in Excel.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Extensively used SQL Server2014 tools to develop Oracle stored packages, functions and procedures for Oracle database back-end validations and Web application development.
• Perform analyses such as regression analysis, logistic regression, discriminant analysis, cluster analysis using SAS programming.

Confidential, Atlanta, Georgia

Data analyst

Responsibilities:

• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• Executed ETL operations for Business Intelligence reporting solutions using Excel.
• Develop and maintain sales reporting using in MS Excel queries, SQL in MS Access.
• Produce performance reports and implement changes for improved reporting. These reports that were created in Business Objects were tested by running the SQL statements.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Designed Excel templates, created Pivot Tables and utilized VLOOKUPs with complex formulas.
• Provided weekly, monthly & ad hoc web analytics reports using Adobe Site Catalyst & Google Analytics.
• Analyzed, evaluated, and compared website analytics packages to create a gap analysis and action plan for IT department's migration process from Site Catalyst (Adobe Analytics) and Google Analytics.
• Involved in Tableau data visualization using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, and Density Chart.
• Evaluate, identify, and solve process and system issues utilizing business analysis, design best practices and recommended enterprise and Tableau solutions.
• Substantial report development experience utilizing SQL Server Reporting Services (SSRS), Cognos Impromptu, and Microsoft Excel.
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Writing PL/SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance.
• Utilize complex Excel functions such as pivot tables and VLOOKUP’s to manage large data sets and make information readable for other teams.
• Developed SQL-based data warehouse environments and created multiple custom database applications for data archiving, analysis, and reporting purposes.
• Data mapping, logical data modelling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Worked in creating dashboard analysis using Tableau Desktop, including information of car rental records, analysis covered customers, days of rental, service region, travel type and etc.
• Performed extensive requirement analysis including Data analysis and Gap analysis.
• Analyzed business requirements and segregated them into high level and low-level Use Cases, activity diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
• Used extracts to better analyze the data, extracted data source was stored in Tableau Server, updated on a daily basis.

Confidential, Jersey City, NJ

Data analyst

Responsibilities:

• Liaison between the client, finance team and development team to support the client’s data analysis and reporting needs, and business requirement gatherings for the client’s need.
• Elicited the requirements for the implementation of a web-based application, documented all the requirements and shared in the SharePoint for stakeholders and PMO’s.
• Worked as a Team player in the Business consolidation process, preparing scope documents, writing Blueprints, functional specification documents and preparing MOM (Minutes of Meeting).
• Met with users and stakeholders designed the business requirement collection approach based on the project scope and prepared BRD’s, FRD’s, CR to meet the business needs and conducted interviews (group and one to one) along with JAD sessions.
• Used SDLC (System Development Life Cycle) methodologies agile methodology to work in an application consolidation project.
• Used SQL queries for organizing and abstracting data from SQL databases, validating and verifying reports provided to the users through the web-based applications.
• Involved in the OLTP and OLAP process and involved in designing data warehouse, familiar with the Top down and bottom-up approach of data warehousing and data modeling concepts.
• Familiar with the MSBI tools like ETL tool SSIS and reporting tool COGNOS.
• Worked on SQL Server database, wrote scripts, analyze the stored procedures as well as supervise development team to develop stored procedures based on business logics.
• Supervised the Application integration and consolidation project, prepared BOW (Book of Work), and providing regular status on the meetings with the senior management, development teams and users.
• Owned the entire business elicitation process and interacted with the technical team, developer(s), and management to get the requirements, document them, design templates, and write specifications.
• Working and coordinating with the SL1 (Service Level 1) and SL2 (Service Level 2) team in order to provide production support to the Users to deliver regulatory reports, revenue reports through reporting tool SAS and web developed applications.
• Good knowledge in AUM (Assets Under management), funds, shares, stocks, FX rates, benchmark rates, equities and securities.
• Performed manual front-end testing to check all functionalities of different modules and Facilitated user acceptance testing and test strategies for the Users as well as worked with QA to prepare Test cases, Test plan etc.
• Analyzing the stored procedures, validating the flow of data from the staging tables to the Main tables and verifying data in the reports and solving the bugs and issues with the data.
• Involved in preparing data mapping documents as well as business Meta data and technical Meta data with the data dictionary for the database.

Confidential, Phoenix, AZ

Data analyst

Responsibilities:

• Extensively involved in every phase of the RUP process starting from Inception to Transition
• Used Data warehousing for Data Profiling to examine the data available in an existing database.
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation.
• Identified and drafted the calculations used for various regions, using their source SQLs for standardization purpose.
• Run the SQL queries using TOAD and SQL Navigator and wrote scripts on PL/SQL and BI tools like COGNOS.
• Used the ODBC/SQL to migrate all data to one database before uploading it into the Knowledge Base.
• 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. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them.
• Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion of the task using agile process.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Writing data mapping documents, data transformation rules and maintaining data dictionary, data migration and interface requirements documents.
• Developed backend calculations required to produce volatility and correlation matrix using SAS.
• Generated server-side SQL scripts for data manipulation and validation and created various Snapshots and materialized views for remote instances.
• Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio.
• Worked on agile/iterative methodology to accomplish the project.
• Configured the Data mapping between Oracle and SQL Server 2005.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements
• 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.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules