SUMMARY

• Over 8 years of IT experience in the field of Business/Data analysis, ETL Development, Data Modeling, and Project Management.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services and Configuration Management
• Experienced in all phases of Software Development Life Cycle (SDLC).
• Efficient in analyzing and documenting business requirements and functional requirements.
• Experienced in conducting Joint Application Development (JAD) sessions with the stakeholders, business users, and SME’s to obtain domain level information of projects.
• Experienced in developing Conceptual, Logical and Physical models using ERWIN and E - R Studio.
• Expertise in the development of Physical Data Model for multiple platforms - SQL Server/ DB2/ Oracle/ Teradata.
• Well versed with the concepts of Forward and Reverse Engineering.
• Proficient in Dimensional Modeling including concepts like Star and Snowflake Schema modeling and creating Fact and Dimension tables.
• Implemented Slowly Changing Dimensions - Type I & II in the dimension tables.
• Comprehensive knowledge on Normalization and De-normalization techniques.
• Proficient with using the Ralph Kimball’s and Bill Inmon methodologies.
• Strong working experience in Extract/Transform/Load (ETL) design.
• Experienced in writing Data Transformation and Data Cleansing rules for Data Mapping documents in Data Warehouse projects.
• Involved in the maintenance of models, loading models to Metadata Repository
• Good Knowledge in SQL for Data Analysis and Data Profiling.
• Experienced in writing data quality rules to ensure quality, consistency and accuracy of data.
• Experienced in design review and validation of final data models.
• Experienced in using TABLEAU to create and manage reports.
• Extensive knowledge and experience in generating tables, reports, graphs and listings using various procedures and handling large databases to perform complex data manipulations.
• Excellent problem solving and analytical skills with exceptional ability to learn and master new technologies efficiently.

TECHNICAL SKILLS

Operating Systems: Windows XP/2000/NT/Vista/7, UNIX, MS DOS, UBUNTU, Sun Solaris.

Databases: Oracle11g/10g, SQL Server 2000/2005/2008/2012 , Teradata, Sybase12.5/11, MSAccess2003/2000, DB2

Modeling Tools: ERWIN r 9.1/ 8.2/7.3/7.0 , ER/Studio 6/6.6/7, MS Visio

Reporting Tools: Tableau

ETL Tools: SSIS

Release Management Tools: HP QC, JIRA, SVN

PROFESSIONAL EXPERIENCE

Confidential, Overland Park, Kansas

Data Analyst / Tableau Developer

Responsibilities:

• Work closely with the Business Analyst to develop the visual analytics for the given data and make it available online and on mobile products.
• CreateTableauworksheets, design, develop dashboards and publish.
• Involved in creating dashboards by extracting data from different sources.
• Working with large volumes of datasets and loading delimited files intotableau.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Develop Scripts to load data intotableauand work with multiple data connections by data blending.
• Created drill through reports in dashboard.
• Involved in creating a dual-axis bar chart with multiple measures.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Extensively used data blending inTableau.
• PerformedTableautype conversion functions when connected to relational data sources.
• Maintained and InstalledTableauServer in all the environments.
• Worked with string functions, date calculations and swapping dimensions with parameters.
• Design and develop layout themes, develop field groups and cyclic displays.
• Created incremental refreshes for data sources onTableauserver.
• Ability to authoring onTableauserver by changing mark types and adding filters directly in a web browser.
• Created report schedules, data connections, projects, groups inTableauserver.
• Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Forecasting demand and consumption patterns. Fixing bugs and updating the software periodically.
• Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.

Environment: SQL Server 2008/2012, DB2, Erwin r9.5, Crystal Reports, Tableau Desktop, Informatica Data Quality 9.5, MS-SQL server manager, HP ALM Defect tracking tool

Confidential, St. Louis, MO

Data Analyst/ETL developer

Responsibilities:

• Worked with business and IT teams in various areas of retail banking to develop or maintained reports and addressed data needs to provide reporting solutions.
• Created a SSIS package and windows services to monitor FTP.
• Created complex Stored Procedures, Triggers, Tables, Views, SQL Joins and other statements to maintained referential integrity and implemented complex business logic.
• Created SSIS package to check XML file validation and data validation to match the requirements.
• Used joins and sub queries to simplify complex queries involving multiple tables.
• Provided technical support to move databases from development to test and production for multiple applications.
• Experienced in slowly changing dimension in SSIS packages.
• Created SSIS packages to transfer XML file data into SQL server database.
• Used SSIS and extract transform loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Worked with SQL server profiler to generate traces. Designed Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
• Studied the existing OLTP system(s) and involved in creating facts, dimensions and star schema representation for the data mart.
• Worked with Star and snowflake schema designs for the financial data mart.
• Creating SSIS packages to clean and load data-to-data warehouse.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Independently worked on owning IT support tasks related to Tableau Reports on Server.
• Built and maintained many dashboards.
• Conducted Knowledge transfer session to the employees on Tableau Software.
• Created dataflow diagram and documented the whole data movement process.
• Responsible for writing complete requirement document by interacting with the business directly to ascertain the business rules and logic.
• Writing high level and detail design documents.
• Worked on the requirement gathering of the reports
• Analyzed the database tables and created database views based on the columns needed.
• Created dashboards displaying sales, variance of sales between planned and actual values.
• Implemented calculations and parameters wherever needed.
• Published dashboards to Tableau server.
• Created Users, Adding Users to a Site, Adding Users to a Group Viewing, Editing & Deleting Users and Activating their Licenses, Distributed Environments, Installing Worker Servers, Maintaining a Distributed Environment, High Availability.
• Impersonating with a Run as User Account, Impersonating with Embedded SQL Credentials.
• Good Knowledge and Worked on TABCMD & TABADMIN, Database Maintenance and Troubleshooting

Environment: Tableau Server v8/v7, Windows Server Standard R2, Excel, SQL Server management studio, MS SQL Server, MS SQL Server 2008/2012, SSIS/SSRS/SSAS

Confidential, Boston, MA

Data Modeler/ Data Analyst

Responsibilities:

• Altered the non-incremental jobs to incremental, using various stages such as SCD, changedatacapture and others based on the complexity of the job anddata.
• Analyzed the sourcedataand worked with theDataArchitect in designing and developing the logical and physicaldatamodels for the EnterpriseDataWarehouse.
• Used Lookup, Join and Merge stages for joining various information and also used Parallel Transformer, Column Generator, Funnel, Filter, Switch, Modify, Pivot, Row Generator.
• Responsible for performance tuning of the ETL process and upgrading the ETL best practices document.
• Performed the Unit testing for jobs developed to ensure that it meets the requirements
• Used Parallel Extender Development/Debugging stages like Row generator, Column Generator, Head, Tail and Peek for debugging of the jobs.
• Used Information Analyzer for profiling anddataquality monitoring.
• Used Quality stages like Investigation, Standardization, Match Frequency, Induplicate Match and DataSurvive.
• Used FastTrack to automate creation of ETL DataStage jobs, to leverage published profiling results from Information Analyzer and to create and link Business Glossary terms and their relationships.
• Developed multiple jobs using OCI, hashed file, aggregator, sequential file stages, shared containers.
• Define process to create source package and deployment to different server (pretest, test, and production)
• Designed parallel jobs and server jobs involving complex business logic using various stages like ODBC, Oracle EE, dataset, sort, Join, Merge, Look up, Pivot, Filter, Aggregator, Hash file, Transformer, SCD and Change capture stages
• Extensively used import/export utilities, generated . dsx files for migrating code between different environments. Also the exported code is checked-in/out of CSV for version control purposes.
• Generated Surrogate Keys for composite attributes while loading thedataintoDataWarehouse, for the dimensions in the fact table for indexed and faster access ofdata.
• Used Parallel Extender for splitting thedatainto subsets and to loaddata, utilized the available processors to achieve job performance, configuration management of system resources in Orchestrate environment.
• Developed Job Sequencer to execute jobs in proper sequence.
• Also automated email messaging was implemented using Sequencer to notify the operations team of anydataload issues such as job failure, dropped rows, rejected rows etc.
• Understood functional documents for business source systems and applications and their integration into the existing DWH. Documented changes made in the jobs following company norms.

Environment: Oracle 11g, SQL Server 2005/2008, DB2, Talend 5.6, Erwin r9.1, Crystal Reports, SSIS/SSRS, MS-SQL server manager, Microsoft Access.

Confidential, Buffalo, NY

Business Data Analyst

Responsibilities:

• Business and Data Requirements Analysis Interface with customers to understand and refine data requirements.
• Responsible for handling FEDdatarequests, FIU (Investigation unit)datarequests, support investigation withdata,datavalidation, testing, consultation & documentation
• Wrote and executed unit, system, integration and UAT scripts in the data warehouse.
• Extensively used ETL methodology for supporting data extraction, transformations and load processing, in a complex EDW.
• Perform data reconciliation between integrated systems.
• Written SQL scripts to test the mappings and developed traceability matrix of Business Requirements mapped to test scripts to ensure any changes in requirements leads to test case update.
• Attributes and relationships in the model were redefined.
• Also unwanted tables and columns were cleaned as part of Data Analysis.
• Enhanced existing Conceptual and Physical data models.
• Organized sessions with architects, business and development teams to understand the Change Requests (CR’s).
• Reviewed Logical and Physical design along with Business Analysts, developers and DBA’s and determined data rules.
• CreatedEntity Relationships diagrams, data flowdiagrams and implemented referential integrity using ERWIN.
• Star schema was developed for proposed central model and normalized star schema to snow flake schema.
• Created mapping documentation for data extraction, transformation, and loading.
• Recommended architectural improvements, design solutions and integration solutions.
• Developed data architecture design to enable analysts to perform targeted customer analysis.
• Working along with ETL team for documentation of transformation rules for data migration from OLTP to warehouse for purpose of reporting.
• Metadata repository was maintained and updated based on change requests.
• Developed operational data store to design data marts and enterprise data warehouses.
• Conducted meetings with business and development teams for data validation and end-to-end data mapping.
• Reverse Engineered databases and then forward engineered using Erwin.

Environment: Erwin r7.2, SQL Server 2008, Crystal reports, PL/SQL, MS Excel, Word and Access, Windows, Informatica Power Center, SSRS, Power designer.

Confidential, Keene, NH

Data Analyst

Responsibilities:

• Gathered analyzed, documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
• Performed Requirement Analysis and developed Use Cases, Activity Diagrams using Rational Rose
• PerformedDatamapping, logicaldatamodeling, created class diagrams and ER diagrams and used SQL queries to filterdata.
• DefinedDataQuality goals, requirements, quality rules and profiling needs
• Participated in identifying and proposingdatagovernance solutions
• Wrote test cases and test scripts for the User Acceptance Testing
• Performed extensivedatamodelling to differentiate between the OLTP andDataWarehousedatamodels
• Identified/documenteddatasources and transformation rules required populating and maintainingdatawarehouse content.
• Maintained benchmark controls to policies, company standards and contracts, performed vendor sourcing, pricing and contract negotiation, performed procurement, ensured compliance with service/joint interest contracts.
• Queried database using SQL for backend testing
• Identified source systems, connectivity, tables and fields, ensuredatasuitability for mapping.
• Strong Knowledge in ETL and Reporting design/implementation with expertise.
• Tested thedataintegrity and gap analysis among various sources and targets.
• Implementeddatacleanup transformations, scripts and testing scenarios to unit and system test the deliverables.
• Designeddatavalidation anddataverification criteria fordatawarehouse.
• Worked with the ETL, QA and the BI team to help them understand thedatamodel and helped them in preparation ofDataElement Mapping (Source to Target Mapping)
• Created the best fit physical model from the logical model and helped Informatica ETL team in the implementation of the model.
• Managed Extracts from the source systems.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writingdata.
• Worked in OBIEE for building answers, Dashboards and custom business reports.
• Worked on reporting requirement from the user and the legacy database - to look for a standard report from Oracle or create and tag custom report for BI reports
• Analyzed user requirements, attended Change Request meetings to document changes and implemented procedures to test changes.
• Partnered with the technical areas in the research, resolution of system and User Acceptance Testing (UAT).
• Assisted in developing project timelines/deliverables/strategies for effective project management.
• Evaluated existing practices of storing and handling important financialdatafor compliance.
• Maintained the Requirements Traceability Matrix (RTM) across the deliverables of a project.

Environment: Oracle8i, Windows 2003 server/XP, Unix, SQL, PL/SQL, Informatica 7.x OBIEE, Visio, TOAD, SQL DEVELOPER, SQLDATAMODELER, Unix, Linux, Shell Scripts,DataLineage,DataMapping, Erwin, Power Designer,DataQuality,DataGovernance

Confidential

Data Analyst

Responsibilities:

• Gathered high level requirements and converted into business requirements.
• Strong understanding of data quality assurance process and procedures.
• Created and maintained the data dictionaries.
• Created Entity Relationship Diagrams (ERD), Functional diagrams, Data flow diagrams and enforced referential integrity constraints.
• Created logical and physical models using Erwin.
• Expertise in the Forward Engineering of the logical models to generate the physical model using Erwin.
• Worked very closely with developers, business analyst and end users to generate various reports and troubleshoot their query problems.
• Created data base objects like indexes, views, stored procedures and synonyms.
• Created database connections for the sources and targets.
• Maintained security and data integrity of the database.
• Involved in the maintenance of the database

Environment: Erwin 7.0, SQL server Management studio 2005, MS Access 2003, SQL Navigator, Microsoft office 2003.