SUMMARY

• Around 9 years of experience in IT as Data Analyst in Banking, Financial and health care industry.
• Experience in OLTP, OLAP Data warehouse and Business Intelligence modeling.
• Expertise in creating Conceptual, Logical and Physical data models in OLTP and dimensional models, star schemas data marts and cubes for data warehouse.
• Experience in working with Logical and Physical data mapping from source to target.
• Experience in gathering and validating reporting requirements and designed optimized reports.
• Experience in working on the testing and condition of data and validation of the data.
• Experience in gathering business requirements and writing business and functional requirement documents
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution
• Good Data Warehousing concepts including Meta data and Data Marts.
• Experience in conducting Joint Application Development (JAD) sessions with end-users, Subject Matter Experts (SME's), Development and QA teams.
• Extensive experience in project management best practices, processes, & methodologies including Agile, Rational Unified Process (RUP) and SDLC
• Experience in managing Alerts and Jobs through SQL Server Agent in SQL Server.
• Experience in Deploying DTS/SSIS packages in SQL Server Integration services (SSIS).
• Worked on the data architecture framework implementation for Netezza ELT environment.
• Experience in Gap analysis and Gap Resolution process succeeding the Logical data mapping.
• Experience in creating Stored Procedures, Packages, Functions, Triggers, Materialized Views, and Cursors and other database objects using SQL, PL/SQL.
• Experience in SQL Tuning/Performance tuning of SQL queries/stored procedures using partitioning, Explain Plan, SQL Trace.
• Expert in writing SQL queries and analysis of the data patterns.
• Experience in Data Augmentation, Data Scrubbing, Data Quality, Data Profiling and Data Cleansing.
• Experience in the implementation of the Data Management Standards for the projects.
• Facilitated the model walkthrough sessions with Business users and Developers.
• Experience with data modeling tools like ER Studio, Power designer and Erwin.
• Possess excellent communication skills and team player.
• Extensive experience on Excel, Word, PowerPoint, MS Project, MS Visio, Rational Suite and SQL.

TECHNICAL SKILLS

Modeling Tools: ER win, Power Designer ER Studio

ETL Tools: Informatica, SAS 9.1.3, AB Initio GDE 1.15

Reporting Tools: Business Objects, Micro Strategy, Cognos

Databases: Oracle, MS Access, SQL Server, DB2,Teradata, Netezza 6.0.5, Sybase 12.5

Methodologies: RUP, UML, Waterfall, Agile, SOA

Process Modeling: MS Visio, Rational Rose

Operating Systems: Windows 10, 7, XP,2007, Windows NT/ 2000/2005/2008

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Senior Business/ Data Analyst

Responsibilities:

• Involved in the projects from requirement analysis to better understand the requirements and support the development team with the better understanding of thedata.
• Interacted with business users to understand their business requirements, and Liaised with business and functional owners during project scoping and planning to identify the high-level requirements for the project.
• Involved in gathering complete requirements by organizing and managing meetings with Business Analysts, Data Stewards and subject matter experts on a regular basis.
• Performed gap analysis of business rules, business and system process flows, user administration, and requirements. Worked with the functional owners to bridge the gaps.
• Reverse-Engineered numerous existing database schemas to get an understanding of existing database architecture.
• Involved in the data profiling activities for the column assessment and natural key study.
• Performed complex data analysis in support of ad-hoc, standard, and project related requests.
• Identified and resolved data related issues.
• Performed Data Mining to analyze the patterns of the data sets.
• Developing data validation and file validation rules for application.
• Developed Data quality completeness and policy rules for the application and ETL team to cleanse and transform the data.
• Created logical data models based on requirement and captured metadata
• Worked with the business to gather reporting requirements to support dashboards, canned reports and Adhoc query ability for the users
• Worked on Gap analysis and Gap Resolution process succeeding the Logical data mapping.
• Designed Logical and Physical data models for Business Intelligence Enterprise Data Warehousing team using ER Studio.
• Worked on source to target mapping between source and target data model for ETL team
• Conducted data model review meetings with development, and data team to communicate business requirements.
• Worked closely with the Business Stakeholders in identifying complex requirements and converted them into immediate data driven (OLAP Cube) C suite dashboards/scorecards in Tableau /MicroStrategy visual insights.
• Work with offshore team to handle data warehouse, ETL and Business Intelligent development.
• Created and updated metadata in the data model repository.
• Used Metadata to prepare the Data layouts, Data Mapping (STM) Source to Target Mapping - different layers of mapping.
• Prepared data lineage and data mapping documents
• Analyze the integrated metadata to get information on data usage, end-to-end change impact analysis, and report-to-source data lineage.
• Create new metadata objects to integrate the existing ETL data transformation code into Data Integration Studio using the source, target and process designers to perform various data transformations and store the datasets into the data warehouse and a DataMart.
• Connected to various different data bases by SQL and wrote SQL Queries for viewing and extracting the Metadata and analyzing data.
• Developed PL/SQL programs, stored procedures for data loading and data validations.
• Extensively used SQL to verify that data has been moved from transactional system to Data warehouse reporting system in accordance with requirements.
• Provided support to the development and testing teams during the lifecycle of the project.
• Created Microstrategy based canned and ad-hoc reports.
• Trained Business Users and Business Analysts on the MicroStrategy functionalities like creating web reports, derived metrics, thresholds, derived attributes, derived elements and scheduling reports.
• Involved in streamlined functional testing of the reports and dashboards to make sure that the data being reflected in the reports match with the ones in the database.
• Educated the business users on the usage of tool like creating their own reports.Provided Adhoc reporting for the users.
• Performed testing of all reports for the final deployment.
• Generated the technical Documentation for the MicroStrategy projects.

Environment: Oracle 11i/10g, PL SQL, Erwin, Teradata, Ab Initio GDE 1.15, Cognos, HP quality center10.0, UNIX, QTP 10.00, MicroStrategy 9.0, Netezza 6.0.5, Business Objects Enterprise XI R3.1 Designer, Spotfire, MicroStrategy 9.4.1, WEBI, Ask.Net, Xcelsius 2008, SQL Developer, MS SQL 2008, MS Visio, Tableau, Qlik, Word, Excel, PowerPoint

Confidential

Business/ Data Analyst

Responsibilities:

• Creating & delivering data structures via logical & physical designs for IT Project teams based on a through understanding of application requirements, business requirements and database constraints.
• Creation of the logical & physical database design for small & complex application across multiple projects and applications.
• Worked on the Consolidation data of the Call center specific for all the call center applications
• Developed the Customer Global data stores to share among the different applications across the company that focus on the customer specific data.
• Responsible for identifying, and negotiating of the corporate wide technologies to purchase, deploy, and Implementation.
• Used SQL for Clarify data manipulation in the custom application.
• Review test cases for accuracy. Validate User Acceptance results confirm to requirements.
• Manage project plans and the deliverables including all artifacts for SDLC.
• Involved in the creation of the Crud matrix.
• Working directly with System Analysts, Application Analysts and Database administrators to ensure data efficiency and integrity.
• Capture and document detailed data requirements for the strategic Initiatives and Projects.
• Facilitating the model walk thru sessions for the business and application users.

Environment: Oracle 8.1.7, Erwin 4.1, Power Designer 9.5, Business Objects, Siebel. UNIX