SUMMARY

• Experienced Data Analyst/Data Modeler/Business Analyst wif 7+ 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 2008)
• 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 wif 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 11g, 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 noledge of relational and dimensional data modeling techniques wif 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 teh CDM using Visio.
• Extensively used HP QC for reviewing teh data / data quality related issues dat needed escalation to teh governance team / steward.
• Proficient in preparing Presentations, Graphs, Pivot Tables using Microsoft Excel and PowerPoint
• Performed Data profiling and scanning for teh data governance team to set teh data quality criteria using rules engine

TECHNICAL SKILLS

Operating Systems: Microsoft Windows 2000/NT, UNIX, WINDOWS XP/98/95 and LINUX

Databases & Tools: ORACLE, MS SQL Server, DB2, T-SQL, SAP, Teradata, MDM

ETL: Informatica 9, AbInitio, DataStage

BI Reporting Tools: OBIEE, Crystal Reports, Microsoft SSRS, Business Objects, Cognos, SAS

Web Technologies: XML/HTML/DHTML/CSS MS SQL, Servlets

Quality Management: Jira, HP QC

Process Tools: Rational Requisite Pro 2001, Rational ClearcasePackagesMS Office (Word, Access, Excel, PowerPoint, Project, Visio), Macros using VBA

Languages: VBScript, SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, Cranford, NJ

Sr. Data Analyst/Data Modeler/Business Analyst

Responsibilities:

• Identified and prioritized strategic themes of teh business to align them wif IT strategies thereby growing revenue, improving profits through efficient quality of services.
• Collected key data metrics to determine mandatory and discretionary investments based on teh prioritizations and projected teh expected returns using MS Access.
• Created implementation checklist, using MS Excel for turnover to Application Continuity and Production Support.
• Validated and informed teh technical design through data analysis across multiple layers of data warehouses, source systems and B2B channels
• Responsible for data mapping and data mediation between teh source data table and WMO data tables using MS Access and MS Excel.
• Experience
• Created COGNOS impromptu reports and used Stored Procedures for complex reports
• Created SQL queries to pull out data and metrics from teh database.
• Assisted in creating teh Physical database for MDM and teh Data Mart.
• Developed Reports using teh Teradata advanced techniques like Rank, Row number, etc.
• Used Quality Center to resolve data and reported system defects by coordinating between teh SME and development team.
• Designed and developed UNIX shell scripts as part of teh ETL process, automate teh process of loading, pulling teh data.
• Involved in testing teh 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 teh ETL Informatica mappings and other ETL Processes (Data Warehouse)
• Wrote teh SQL queries on data staging tables and data warehouse tables to validate teh 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.
• Checked teh 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 teh 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
• Used Crystal Reports, COGNOS to extract data and develop complex OR reports

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

Confidential, Foster City, CA

Data Analyst

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 teh existing mapping and creating an impact analysis for teh change on Data
• Writing new mappings specification according to teh business data requirements
• Suggested and reviewed Materialized views to store aggregate values
• Prepared Test data preparation strategy and data masking strategy for teh shared test environment
• Created Tabular, matrix and chart reports. Using store procedures, views, functions using Report Writer, SSRS and Crystal Reports.
• Involved in completing data testing before teh UAT.
• Familiar wif using Set, Multiset, Derived, Volatile and Global Temporary tables in Teradata for larger Adhoc SQL requests.
• Using SQL Server 2008 SSRS, generate and maintain five business reports including dashboard report, matrix report, parameter report wif charts and drill down function to monitor project progress
• Loading Flat file Data into Teradata tables using Unix Shell scripts
• Co-ordinate wif development and QA team for handling of defects wif respect to data
• Interact wif clients/business users when issues arise on Data governance
• Created spreadsheet wif all teh production issues/solutions as part of lessons learnt and to halp form FAQ for teh 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 tan 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 teh workflows for batch based on dependency to improve teh time taken for end to end loading.
• Perform Source-to-Target Data Mapping in Informatica. (ETL) and optimized mappings.
• Teh order data thus loaded into SQL Server was used to generate reports using Business Objects.
• Reviewed all artifacts created wif respect to Logical and physical data models including Tables, procedures, indices, synonyms, views, functions, triggers, sequence, constraints

Environment: ETL, SQL Server, Crystal Reports, 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 teh project scope and SDLC methodology.
• Conducted JAD sessions wif SME including business owners, sponsors and analysts.
• Worked wif teh Product Managing team in setting realistic project expectations and in evaluating teh impact of changes on teh organization and plans accordingly.
• Conducted back end email tracking using MySQL to do teh success rate study to measure Email Broadcast campaign success, deliverability and measure marketing response for each of teh campaigns.
• Collected metrics using MySQL like number of emails generated, percentage of who opens, forwards and clicks-through for teh 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 teh metrics wif teh member profile data and also teh attendance and purchasing data to understand teh overall profiles of teh 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 teh website.
• Collected user related visitor-level metrics like frequency of visits, duration and number of unique visits and stickiness to measure teh effectiveness of teh 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 teh Product support team to create and constantly update teh 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 teh 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 teh process flows, data and algorithms for Claims Management module including teh ability to track employee benefit type, out-of-work time period, wages earned etc.
• Subject Matter Expert of teh 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 wif teh client business rules.
• Defined milestones in project plan using MS Visio wif teh halp 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 teh 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 wif cross-functional teams throughout teh project life cycle.

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