SUMMARY:

• Experienced Data Analyst/Data Modeler/Business Analyst with 8+ years’ experience in IT, Ecommerce, Banking, Hi - Tech and insurance industry.
• Adept at analyzing and modeling business processes, requirements gathering and expectation management.
• Skilled at developing a deep understanding of an organizations business and culture and building collaborative environments receptive to views of divergent stakeholders.
• Experienced in data mapping, data modeling and collecting various data metrics for marketing, performance return of investments and customer-level engagement projects.
• Extensive experience in Process/Data Modeling, Quality Assurance/Testing of both client and server side and data warehousing applications.
• Skilled in eliciting stakeholder demands and translating them to data, functional, quality and usability requirements.
• Delivered a number of successful implementations in areas of Transactional Database Applications, Data Management and Data Warehousing ETL/Business Intelligence.
• Experience in full Software Development Life Cycle (Waterfall, Spiral, Agile & other SDLC implementation) and Project Management Life Cycle (PMLC).
• Developed Adhoc queries and Reports using Oracle, SQL, PL/SQL, Teradata and UNIX to fulfill business analysts, Operations Analysts and Financial analysts’ data requests.
• Created and Designed logical database schema layout structure to prepare for ETL processes, data mining, extraction, Analysis and Reporting System utilizing SSIS, SSRS, for data warehouse (SQL Server)
• Business Intelligence experience including requirements, data analysis, designing /mode ling relational DB, data warehousing, transformation and conversion, report development and prototyping, root-cause analysis, reverse engineering and data reconciliation
• Worked with data validation, adhoc report, report validation using excel, VBA Macro, SSRS, crystal Reports, Business Objects, Cognos and OBIEE.
• Excellent SQL and PL/SQL skills for creating queries, procedures, database triggers to collect profile and scan data.
• Proficient in Oracle, Hadoop, MySQL, MongoDB, Teradata, SQL Server, PL/SQL on UNIX and Windows platforms. Provided support to Data Architect and Data Modeler in Designing and Implementing Databases for MDM using ERWIN Data Modeler Tool and MS Access.
• Strong knowledge of relational and dimensional data modeling techniques with solid experience in Transactional/ER and Data warehouse/Dimensional & OLAP.
• Experienced in creating and review data models PDM using ErWin and ERstudio. And reverse engineering documentation and understanding the CDM using Visio.
• Extensively used HP QC/ALM, JIRA, Bugzilla for reviewing the data / data quality related issues that needed escalation to the governance team / steward.
• Proficient in preparing Presentations, Graphs, Pivot Tables using Microsoft Excel and PowerPoint
• Performed Data profiling and scanning for the data governance team to set the data quality criteria using rules engine

PROFESSIONAL EXPERIENCE:

Confidential, Cranford, NJ

Sr. Data Analyst/Data Modeler

Responsibilities:

• Identified and prioritized strategic themes of the business to align them with IT strategies thereby growing revenue, improving profits through efficient quality of services.
• Collected key data metrics to determine mandatory and discretionary investments based on the prioritizations and projected the expected returns using MS Access.
• Created implementation checklist, using MS Excel for turnover to Application Continuity and Production Support.
• Validated and informed the technical design through data analysis across multiple layers of data warehouses, source systems and B2B channels
• Responsible for data mapping and data mediation between the source data table and WMO data tables using MS Access and MS Excel.
• Experience in designing complex Drill-Down & Drill-Through Reports using Business Objects.
• Created SQL queries to pull out data and metrics from the database.
• Assisted in creating the Physical database for MDM and the Data Mart.
• Developed Reports using the Teradata advanced techniques like Rank, Row number, etc.
• Used Quality Center to resolve data and reported system defects by coordinating between the SME and development team.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data. • Involved in completing data testing before the UAT.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Exploited power of Teradata to solve complex business problems by data analysis on a large set of data.
• Created and Designed logical database schema layout structure to prepare for ETL processes, data mining, extraction, Analysis and Reporting System
• Worked on the ETL Informatica mappings and other ETL Processes (Data Warehouse)
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results. Experience in creating UNIX scripts for file transfer and file validation.
• Created and Designed logical database schema for data warehouse (Teradata) environment to prepare for ETL Informatica.
• Checked the naming standards, data integrity and referential integrity.
• Wrote complex SQL queries to identify granularity issues and relationships between data sets and created recommended solutions based on analysis of the query results
• Identified, suggested and managed improvements in process to meet data quality criteria.
• Used Erwin Data Modeler to create, enhance, and maintain logical and physical models.
• Created adhoc reports and pivot tables in Excel 2013 using VBA and macros. using
• Analyze the Business Object reports/extracts and submit to the Risk manager after the proper validation.

Environment: DWH ETL Informatica, Business Objects, SQL, PL/SQL, Quality Center/ALM, SSRS, Oracle 10g/11g, Unix IBM AIX 5.5, T- XML Files, XSLT, XML Spy 2010,SAS, Pivot Tables, MDM, Macro, Erwin, Agile, SQL Server, SQL, T-SQL, SSIS,, Requisite Pro, Excel, UAT, Teradata.

Confidential, Foster City, CA

Data Analyst /Data Modeler

Responsibilities:

• Review Mapping Documents formula and rule engine.
• Involved in Logical and Physical modeling of various Data marts as well as data warehouse
• Analyzing change request for the existing mapping and creating an impact analysis for the change on Data
• Writing new mappings specification according to the business data requirements
• Suggested and reviewed Materialized views to store aggregate values
• Prepared Test data preparation strategy and data masking strategy for the shared test environment
• Created Tabular, matrix and chart reports. Using store procedures, views, functions using Report Writer, SSRS and Crystal Reports.
• Familiar with using Set, Multiset, Derived, Volatile and Global Temporary tables in Teradata for larger Adhoc SQL requests.
• Loading Flat file Data into Teradata tables using Unix Shell scripts
• Co-ordinate with development and QA team for handling of defects with respect to data
• Interact with clients/business users when issues arise on Data governance
• Created spreadsheet with all the production issues/solutions as part of lessons learnt and to help form FAQ for the maintenance team.
• Used Pivot tables, vlookups and conditional formatting to verify telemarketing data against data uploaded to proprietary database and online reporting.
• Created ETL mapping documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Intensive data mining practice for data manipulation/extraction in Teradata environment for data integration
• Created data rules to handle SCD Type II data using PL SQL.
• Helped sequence the workflows for batch based on dependency to improve the time taken for end to end loading.
• Perform Source-to-Target Data Mapping in Informatica. (ETL) and optimized mappings.
• The order data thus loaded into SQL Server was used to generate reports using Business Objects.
• Reviewed all artifacts created with respect to Logical and physical data models including Tables, procedures, indices, synonyms, views, functions, triggers, sequence, constraints

Environment: ETL, SQL Server, Business Objects, Quality Center 10.0, Agile, Java, .NET, XML, HTML, Windows and Unix, Shell Scripting, SQL, PL/SQL, TOAD for Oracle 9.1, Requisite Pro, Oracle 10g,Pivot Tables, MS Office, Erwin, Teradata, COGNOS,SAS.

Confidential, San Jose, CA

Data Analyst

Responsibilities:

• Gathered Business requirements based on the project scope and SDLC methodology.
• Conducted JAD sessions with SME including business owners, sponsors and analysts.
• Worked with the Product Managing team in setting realistic project expectations and in evaluating the impact of changes on the organization and plans accordingly.
• Conducted back end email tracking using MySQL to do the success rate study to measure Email Broadcast campaign success, deliverability and measure marketing response for each of the campaigns.
• Collected metrics using MySQL like number of emails generated, percentage of who opens, forwards and clicks-through for the campaign.
• • Designs and distributes reports using Reporting Services based on technical and sometimes non-technical requirements. (Transitioned archaic reports to SSRS)
• Analyzed and conducted data mapping of the metrics with the member profile data and also the attendance and purchasing data to understand the overall profiles of the members.
• Designed and developed Use Cases and Activity Diagrams using UML in rational rose and Visio.
• Created MySQL queries to pull out user-level activity data and various other metrics defining popularity of products on the website.
• Collected user related visitor-level metrics like frequency of visits, duration and number of unique visits and stickiness to measure the effectiveness of the recommendations available.
• Extensively used MySQL Toad for querying underlying database tables and resolving data issues.
• Worked on enhancing and monitoring SQL Queries using TOAD
• Assisted the Product support team to create and constantly update the FAQ section by actively researching issues and addressing customer questions.

Environment: MS SQL Server, MS Access, Excel, Excel Data Analysis features, Teradata, SSRS, Erwin, Excel VBA, MS Word, UML, ETL, SQL, TOAD, SAS, Agile, Unix, Visio.

Confidential, Roseville, CA

Data Analyst

Responsibilities:

• Created workflow diagrams for the Claims Management module including, track, record and calculate lost work time.
• Provided business cycle time and cost metrics to suggest re-engineering of processes to reduce them and increase output for customer satisfaction.
• Understood the process flows, data and algorithms for Claims Management module including the ability to track employee benefit type, out-of-work time period, wages earned etc.
• Subject Matter Expert of the National Council on Compensation Insurance NCCI and EDI-IAIABC Reporting requirements and reports generation using MS Excel and advanced use of VBA and macros.
• Created SQL queries and database triggers for state mandated reports and data elements.
• Conducted data modeling and data mapping for reporting data elements.
• Analyzed data discrepancies and validated them with the client business rules.
• Defined milestones in project plan using MS Visio with the help of WBS and network diagram.
• Produced documentation including detailed Business Requirements, Functional Requirements and assisted to produce Technical Specification and Operations Manual.
• Identified Use cases from the Functional requirements and wrote Use Case Specifications and created business process workflow diagrams in MS Visio.
• Assisted Developers in Data Modeling using Entity Relationship Diagrams (ERD).
• Collaborated with cross-functional teams throughout the project life cycle.

Environment: MS SQL Server 2008 SSRS, SSIS, MS Access, Teradata, UNIX, Excel, Agile, Excel Data Analysis features, Excel VBA, MS Word