SUMMARY

• Overt 8+ years of extensive Information Technology experience in all phases of Software development life cycle including System Analysis, Design,DataModeling, Dimensional Modeling, implementation and Support of various applications in OLTP and Data Warehousing.
• Highly proficient inDataModeling retaining concepts of RDBMS, Logical and PhysicalData Modeling including 3NormalForm (3NF) and MultidimensionalDataModeling Schema (Star schema, Snow - Flake Modeling, Facts and dimensions).
• DataModelerwith strong Conceptual, Logical and PhysicalDataModeling skills,DataProfiling skills, MaintainingDataQuality, experience with JAD sessions for requirements gathering, creating datamapping documents, writing functional specifications, queries.
• Expert in theDataAnalysis, Design, Development, Implementation and Testing usingData Conversions, Extraction, Transformation and Loading (ETL) and SQL Server, ORACLE and other relational and non-relational databases.
• Expertise inDatawarehouseData& ETL Architecture, Oracle Database platform, ErwinData modeler, Informatica Power center, Talend and Pentaho, End to End solutions architecting, Implementing for DWBI Engagements.
• Worked with variousdatasources such as Oracle, SQL Server, Teradata & Netezza
• Management of Data integrity, Data standard, Data enhancement, Data publishing, data capture,data migration, Data auditing, Data Quality, Data Exception Handling process, Data Rejection process, Meta data workflow
• Handled all oracle database development, PL/SQL,SQL programming, ETL, OLAP reporting, job automation, query tuning, replication, migration, conversion, performance tuning, backup
• Having experience in writing complex SQL queries to perform end-to-end ETL validations and support Ad-hoc business requests. Also good in developed Stored Procedures, Triggers, Functions, Packages using SQL/PLSQL.
• Excellent knowledge on creating reports on Tableau, Tibco Spotfire, SAP Business Objects, Webi reports for multipledata providers.
• Strong Database experience using Oracle 10g/9i, XML, DB2, Teradata, SQL server.
• Used Teradata Fast Export utility to export large volumes ofdatafrom Teradata tables and views for processing and reporting needs.
• Experience in testing Business Intelligence reports generated by various BI Tools like Cognos, Tableau, Micro strategy and Business Objects
• An excellent team player& technically strong person who has capability to work with business users, project managers, team leads, architects and peers, thus maintaining healthy environment in the project.

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, UNIX shell Scripting, PERL, AWK, SED

Databases: Oracle 11g/10g/9i, Teradata R12 R13, R14 MS SQL Server 2005/2008/2012 , MS Access, Netezza

Tools: MS-Office suite: (Word, Excel, MS Project and Outlook), VSSTesting and defect tracking ToolsHP/Mercury (Quality Center, Win Runner, Quick Test Professional, Performance Center, Requisite, MS Visio & Visual Source Safe

Operating System: Windows, Unix, Sun Solaris

ETL/Datawarehouse Tools: Informatica 9.5/9.1/8.6.1 , SAP Business Objects XIR3.1/XIR2, Web Intelligence, Talend, Tableau, Pentaho

DataModeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Erwin

Tools: & Software: TOAD, MS Office, BTEQ, Teradata SQL Assistant

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Sr. Data Modeler /Data Analyst

Responsibilities:

• Worked on discovering entities, attributes, relationships and business rules from functional requirements
• Used Erwin R9.0, created Conceptual, Logical and Physicaldatamodels.
• Performed Data Analysis and Data Profiling and worked on data transformations and data quality rules.
• Designed both 3NFdatamodels for ODS, OLTP systems and dimensionaldatamodels using star and snow flake Schemas
• Indulge in Power designer tool, Informatica 9.5/9.1/8.6.1 /8.1 (Repository Manager, Designer and Workflow Manager.
• Worked in importing and cleansing ofdatafrom various sources like Teradata, Oracle, flat files, SQL Server 2005 with high volumedata
• Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Generated the DDL Scripts by forward engineering the physical model and Interacted with the DBA to implement the physical database.
• Developed source to target mapping documents to support ETL design.
• Involved with design of ETL processes using Informatica ETL tool for dimension and fact file creation
• Created and executed test scripts, cases, and scenarios that will determine optimal system performance according to specifications.
• Reverse Engineered DB2 databases and then forward engineered them to Teradata using Erwin.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.
• Created an enterprisedatadictionary and maintained standards documentation.
• Worked with metadata management to maintain metadata for the project.

Environment: DB2, Teradata SQL Assistant, SQL Server 2008, MS Visio, MS Excel, Word and Access, Informatica 9.5,DataFlux, Oracle 9i, Quality Center 8.2, SQL, TOAD, PL/SQL, Flat Files, Erwin 9.0

Confidential, Bellevue, WA

Sr. Data Modeler/Data Analyst

Responsibilities:

• Involved inDatamapping specifications to create and execute detailed system test plans. Thedata mapping specifies whatdatawill be extracted from an internaldatawarehouse, transformed and sent to an external entity.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to loaddatafrom source flat files and RDBMS tables to target tables.
• Responsible for analyzing variousdatasources such as flat files, ASCIIData, EBCDICData, RelationalData(Oracle, DB2 UDB, MS SQL Server) from various heterogeneousdatasources.
• Tested the ETL process for both beforedatavalidation and afterdatavalidation process. Tested the messages published by ETL tool anddataloaded into various databases
• Involved in Manual and Automated testing using QTP and Quality Center.
• Involved in Uploading Master and Transactionaldatafrom flat files and preparation of Test cases, Sub System Testing.
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Identify, assess and intimate potential risks associated to testing scope, quality of the product and schedule
• Worked with ETL teams and used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups and their privileges.
• Create and execute test scripts, cases, and scenarios that will determine optimal system performance according to specifications.
• Generated comprehensive analytical reports by running SQL queries against current databases to conductdataanalysis.
• Modified the automated scripts from time to time to accommodate the changes/upgrades in the application interface.
• Produced PL/SQL statement and stored procedures in DB2 for extracting as well as writingdata.
• Ensured productiondatabeing replicated intodatawarehouse without anydataanomalies from the processing databases.
• Used Tableau for database reporting on various data sources.
• Discussed theDatamodel,dataflow anddatamapping with the application development team.
• Integrated with developers in utilizing necessary PL/SQL scripting to perform various tasks such as validating and analyzing health care informaticsdata, to ensure nodataanomalies pertaining to validity, content, format, presentation, etc. existed.
• Helped developing PL/SQL packages, Coordinated the production deployment and resolved Post implementation issues. Participated Business Acumen Work for Controlling Payroll issues.

Environment: Erwin r9, SQL Server 2008, SQL Server Analysis Services 2008, SSIS 2008, SSRS 2008, Oracle 10g, Business Objects XI, Rational Rose,Datastage, MS Office, MS Visio, SQL, SQL Server 2000/2005, Rational Rose, Crystal Reports 9, Windows XP, Oracle 8i, Windows XP/NT/2000.

Confidential, Las Vegas, NV

Sr. Data Analyst/Data Modeler

Responsibilities:

• Designed Logical & PhysicalDataModel /Metadata/datadictionary using Erwin for development teams both offshore and on site
• Understand source business process anddatamodel and dodataanalysis and map the requirement to source system.
• Provided conceptual /functional /business analysis assistance to developers and DBA's using Erwin/ ER - Studio. Validateddatamodels with client developers
• Designeddatamodels with standards up to 3rd NF (OLTP/ODS) and de normalized (OLAP)datamarts with Star & Snow flake schemas.
• Created SQL, PL/SQL, SQL Loader control files, functions, procedures, and UNIX Shell scripts.
• Dataanalysis, Gap Analysis,dataintegrity,Dataquality,dataprofiling, metadata,datadictionary, Work flow dependency matrix, Work flow, Logicaldatamap.
• Conceptual, logicaldatamodel. Dimension modeling, star schema design fordatamart,Dataflow diagram(DFD)
• Provided conceptual and technical modeling assistance to developers and DBA's using Erwin and Model Mart. ValidatedDataModels with IT team members and Clients.
• Wrote SQL Queries, PL/SQL, DHTML Functions, Procedures, and Packages
• PhysicalDatamodel, Attributes/Definition,DataDictionary, MetaData
• Process Design, Business Rule and integrity Constraint implementation
• DataChange and Impact Analysis and Process for changingdata.
• ETL Architecture, Backend Architecture,Datawarehouse Architecture
• DatamanagementofDataintegrity,Datastandard,Dataenhancement,Datapublishing,Dataauditing,DataQuality,DataException handling process., DataRejection Analysis.
• Export /Import, User/Role, Database Privileges, Database Link, ODBC connectivity.

Environment: Oracle 9i, TOAD, DBVisulizer 5.1.1,DataManager (Cognos), ODBC, ToadData Modeler, ER Studio, Cognos Analysis studio/report studio, oracle EBS 11i, Erwin3.5, PL/SQL TOOL KIT, Perl, JDBC, Toad 3.0

Confidential

Data Analyst / Data Modeler

Responsibilities:

• Worked on interviewing business users to gather requirements and documenting the requirements.
• Used Erwin to create Conceptual, Logical and Physicaldatamodels.
• Designed theDataModel/Dataexchange Metadata Model for All Interfaces andDataExchanges
• Designed and MaintainedDataModel for OLTP systems and OLAP systems, ODS andDataMarts using 3NF, Dimensional Design
• Worked on Physical design for both SMP and MPP RDBMS, with understanding of RDMBS scaling features
• Managed full SDLC processes involving requirements management, workflow analysis, source dataanalysis,datamapping, metadata management,dataquality, testing strategy and maintenance of the model.
• Helped the BI, ETL Developers, Project Manager and end users in understanding theDataModel, dataflow and the expected output for each model created
• Created and executed test cases for ETL jobs to upload masterdatato repository.
• Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Extensively used MS Access to pull thedatafrom variousdatabases and integrate thedata.
• Wrote complex SQL queries for validating thedataagainst different kinds of reports generated by Business Objects XIR2.
• Extensively used ETL methodology for supportingdataextraction, transformations and loading processing, in a complex EDW using Informatica.
• Analysis on Mainframedatato generate reports for business users.
• Extensively used Erwin as the main tool for modeling along with Visio
• Used SQL on a wide scale for analysis, performance tuning and testing

Environment: SQL, ERWIN r7.3, INFORMATICA, VISIO, Oracle, MS-Excel, Powerpoint, MS-Word, SAP, JD Edwards, Teradata 13.10, Microsoft SQL Server 2012, SQL Manager, SAP Logon, Erwin 8.0, Visio, Informatica, Business Objects XI, Teradata SQL Assistant

Confidential

Data Analyst

Responsibilities:

• Worked inDataWarehousing project and obtained experience in design and implementation ofData Warehousing solutions especially design & development ofDataWarehousing,DataModeling, and Relational Database Systems.
• LearntDatamodeling using DimensionalDatamodeling, Star Schema modeling, Snowflake modeling, and FACT and Dimensions tables in Erwin.
• Experience working withDataModelersand Experience in running Jobs in Mainframe/Control M/Unix Environment.
• Work closely withDataAnalysts, BI Developers and key business users to review, design and develop the solution for LRM.
• Generate DDL scripts for implementingDataModeling changes in database
• Experienced at Creating effective Testdataand development thorough Unit test cases to ensure successful execution of thedata.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintaindataefficiently.
• Published Reports, workbooks &datasource to server and exporting the reports in different Formats.
• Enhanced the Previous ETL process with new features by exploring areas of improvements like dataquality,datamasking, slowly changing dimensions and performance enhancements.
• Performing Analysis like Column Analysis, Table Analysis and Redundancy Analysis necessary for theData.

Environment: Informatica Powercenter 8.1, ERWin, Oracle10g, SQL, PL/SQL, Toad, Autosys, ClearCase, ClearQuest (EBT), Remedy, Unix, Shell Scripts, Putty, Textpad, Winscp