SUMMARY

• Years of professional experience as a Data Analyst in Retail, Healthcare and Banking Domain
• Expertise level experience in numerousData warehouse, Data mart, Client - Server Applications.
• Developed and Created Logical and Physical Database Architecture using ERWIN.
• Designed STAR Schemas for the detaileddataMarts and planDataMarts involving Shared Dimensions.
• Coordinated with different users in UAT process.
• Experience as Database Analyst on source to target mapping, gathering business requirements from business/user, creating source to target mapping document, creating process flows, and DFD.
• Experience in understanding business requirements and translating them to ETL code by working along with business analysts to identify and study the requirements.
• Worked in challenging environments understanding OLAP concepts with largedatasets.
• Experience with large ETL mappings, analysis and documentation of OLAP reports.
• Capable hands on knowledge of usingDataAnalytics Tools QlikView, Power BI, Micro Strategy.
• Experience withDataExtraction, Transforming and Loading (ETL) using various tools such asData Transformation Service (DTS), SSIS.
• Experience with procedural SQL languages such as T-SQL or PL/SQL.
• Experienced in creation/enhancement Interactive Dashboards and Stories in Tableau including creation different visualizations with Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables
• Experience in reusable transformation (joiner, sorter, aggregator, expression, look up, router, filter, update, strategy, sequence generator, normalizer and rank) to movedatafrom multiple sources to target.
• Experience in all phases of Software development life cycle including System Analysis, Design,DataModeling,
• Implementation and Support of various applications in OLTP,DataWarehousing, and OLAP applications.
• Expertise in Tableau BI reporting tools &Tableau Dashboards Developments & Server Administration.
• Experience in De-duping, cleansing and address correction for improvingdataquality
• Conduct Design reviews with the business analysts and content developers to create a proof of concept for the reports.
• Ensured the feasibility of the logical and physical design models.
• Conducted the required GAP analysis between their AS-IS submission process and TO-BE.
• EncounterDataSubmission Process. Professional experience of most advanced SQL Server 2011
• Database server installation, login and user creation, role and permission configuration.
• Experience on high performancedataintegration solutions- including extraction, transformation, and load (ETL) packages fordatawarehousing.
• Extract thedatafrom database and providedataanalysis using SQL to the business user based on the requirements.
• Strong Teradata SQL, ANSI SQL coding skills.
• Create pivots and charts in excel sheet to reportdatain the format requested

TECHNICAL SKILLS

Software/Hardware: C, C++, HTML, XML, SQL, MS Access, Oracle (SQL Series), DB2, Crystal Reports 8.0, MS Office Suite (Word, Excel, Access, PowerPoint & Outlook), MS Visio, Rational Rose, Rational Requisite Pro, Adobe Acrobat, MS Office FrontPage, Lotus Notes, Cognos. SSIS, Autosys and Control-M, Virtual User Generator, Load Runner

PROFESSIONAL EXPERIENCE

Confidential, Florence, NJ

Data Analyst

Responsibilities:

• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Conductdatamining,datamodeling, statistical analysis, business intelligence gathering, trending and benchmarking.
• Dataanalytics supports decisions for high-priority, enterprise initiatives involving product development, customer service improvement, organizational realignment and process re-engineering.
• Created SQL queries to check the updates in Oracle database and executed SQL queries in Oracle to check the redundancy ofdata.
• Developed tables, Views, Stored Procedures and Triggers using SQL Scripting.
• Performed Requirement Analysis and developed Use Cases, Activity Diagrams using Rational Rose
• Documented requirements associated change requests with requirements and connected requirements with Use cases.
• Worked on Teradata insert, Update, Upsert and Dynamic SQL to transform and Load Summary tables built on Core Data Warehouse using BTEQ.VBA/VB Script
• Database fundamentals (relationships, architecture, read/write logic)
• Data analysis (error checking, set validations, troubleshooting, data flows)
• Data visualization (charts, graphs, dashboards, interactive controls)
• Write queries and stored procedures for front-end applications, as well as, back end data warehouse systems
• Develop new ETL processes to integrate a variety of systems throughout the company
• Work both individually and as part of a team
• Performed dailydataqueries and prepared reports on daily, weekly, monthly, and quarterly basis.
• Developed source to target mapping document for Item Master and Item Branch tables
• Use SQL queries on Microsoft Access/SQL Server in a regular basis.

Environment: CA ERWIN, Oracle 10g, SQL Server 2005, PL/SQL, PeopleSoft V8, Toad, Informatica, Power Centre.

Confidential, Hartford, CT

Data Analyst

Responsibilities:

• Developed normalizedLogicalandPhysicaldatabase models to design OLTP system for insurance applications
• Created dimensional model for the reporting system by identifying required dimensions and facts usingErwin r7.1
• Created draftdatamodels for understanding and to helpDataModeler.
• Resolved thedatarelated issues such as: assessingdataquality,dataconsolidation, evaluating existing datasources.
• Manipulating, cleansing & processingdatausing Excel, Access and SQL.
• Responsible for loading, extracting and validation of clientdata.
• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into thedata.
• Participated in requirements definition, analysis and the design of logical and physicaldatamodels
• Leadingdatadiscovery discussions with Business in JAD sessions and map the business requirements to logical and physicalmodelingsolutions.
• Used facilitation in business and organizational settings to ensure the designing and running of successful meetings and workshops
• Conducteddatamodel reviews with project team members
• Captured technical metadata throughdatamodelingtools
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives
• Collaborated with ETL teams to createdatalanding and staging structures as well as source to target mapping documents
• Ensuredatawarehouse database designs efficiently support BI and end user requirements
• Extracted data from the databases (Oracle and SQL Server, DB2, FLAT FILES) using Informatica to load it into a single data warehouse repository.
• Create Maps, Bar and line charts, heat maps extensively by usingTableau.
• Used ETL for efficient mapping and transformation techniques.
• Developed aConceptual modelusing Erwin based on requirements analysis
• DevelopedData Mapping, Data Governance, TransformationandCleansingrules for the Master Data Management Architecture involving OLTP, ODS and OLAP
• Responsible for keeping development, testing (PY), data validation (DV) / construction (DC) and production (PD) environment in sync
• Responsible for leading MDM initiative in JDE E1 system and migrating data out of JDE World

Environment: MS SQL Server, Microsoft Access 2010, Oracle Database Expression 11g,Oracle SQL Developer, Microsoft SQL Server 2008, Sybase Central 6.1.0,Toad, PostgreSQL, Visual Studio, Eclipse IDE, PowerBuilder 12.5, NetBeans IDE, JIRA, Android Studio, iDashboards, SQL, TSQL, Java, C++, C#, HTML, MAC, Windows, Android, Linux - Ubuntu, HTML, SQL, PLSQL, XML, MySQL

Confidential, NY

Data Analyst

Responsibilities:

• Extracteddatareports that include fico scores, transactions, and client information
• Collected and cleaned raw funddata, used R/SAS to processdata, and implemented Morningstar’s fund evaluation system
• Generated reports for large datasets using UNIX shell scripting and SQL.
• Created OLTP, ODS and OLAP architectures
• Develop new processes using PRO*C, PL-SQL and Unix Shell Script as per business needs.
• Designed and developed weekly, monthly by using SQL,PL/SQL, MS Excel, MS Access, Teradata.
• Setting up SAS execution platform on UNIX system.
• Maintained and enhanced and determined impact to the Enterprise Data Model EDM, ODS Operational Data Source ODS and DSS Decision Support System and refined the EDM as needed as new applications or products were added.
• Load 835/837 EDIdatafiles received from clients.
• Programmed a web-based (ASP.Net/VB.Net)datamodelingtoolkit to supportdataanalytics efforts.
• Metadata Management,DataMigration,DataConversions, and validation forDataconsistencies.
• Designed Star and SnowflakeDataModels for EnterpriseDataWarehouse using ERWIN
• DataArchitect,DataModeling,DataMigration,DataProfiling,DataCleansing,Transformation,Integration,DataImport, andDataExport through the use of multiple ETL tools such as Informatica Power Centre.
• Collaborated with the DBA anddataanalysts to perform analysis anddatacleansing by using a series of created SQL scripts and queries and performeddatamappings.
• Demonstrated excellence when migrating customer and CRMdatafrom legacy system to SAP using SAP BODS 3.1 by creating jobs and loadingdatavia LSMW's.
• Created KPI Dasboard to show the progress of the project to management.
• In depth analysis on VSAM files to understand thedataanomaly and for draftingdatacleansing requirements.
• In depth analysis on VSAM files to understand thedataanomaly and for draftingdatacleansing requirements.
• Acquiredatafrom primary or secondarydatasources and maintain databases/datasystems (SAP and Oracle)

Environment: Informatica Power Center 8.6/8.1.1, Workflow Designer, Power center Designer, Repository Manager, COGNOS Power play 6.6, XML,SQL server, DB2, Oracle 9i, SQL,PL/SQL, SQL Loader, UNIX Shell Scripting, Windows NT/2000/XP, Visio, Erwin 3.5.2,Quality Center