SUMMARY

• Having 7+ years of professional experience in Data Analysis and Data Modeling as a Proficient in gathering business requirements and handling requirements management.
• Strong experienced in customer communication, requirement analysis,data profiling,datamodeling, understanding technical architecture, ETL architecture anddataanalysis.
• Worked in Conceptual Data Modeling, Enterprise Data Modeling, Logical/Physical Data Modelling, EnterpriseData Warehouse Design, Datamart Design, Metadata,Data Quality, Master Data Management and Data Governance.
• Worked expansively on forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes. Created ERWIN reports in HTML, RTF format depending upon the requirement, publishedDatamodel in model mart, created naming convention files, co - coordinated with DBAs to apply thedatamodel changes.
• Strong experienced in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export through the use of multiple ETL tools such as Ab Initio and Informatica Power Center Experience in testing and writing SQL and PL/SQL statements - Stored Procedures, Functions, Triggers and packages.
• Experienced in automating and scheduling the Informatica jobs using UNIX shell scripting configuring Korn-jobs for Informatica sessions.
• Excellent knowledge on creating reports on SAP Business Objects, Webi reports for multiple data providers.
• Excellent knowledge in preparing required project documentation and tracking and reporting regularly on the status of projects to all project stakeholders
• Excellent experience indatawarehousing technologies and implemented end-to-end architecture of the ETL solution, including liaising with System Architect and Database Architect for ETL model as an ETL Architect/Lead.
• Extensive scripting knowledge of SQL, PL/SQL, BTEQs, MLOADs, Fast Loads, etc. and tuning techniques.
• Experienced in Supported ETL team in building SSIS mappings, enabling the extract, transform loading of thedata into target tables and also involved in transformation ofdatafrom old database to new database using MS SQL Server.
• Performed the role ofDataArchitect in various projects to help design the system/schema for OLTP &DataWarehousing Systems. Proficient withData Modeling tools like ER Studio and ERWIN.
• Strong experienced inDataAnalysis,Data Migration,DataCleansing, Transformation, Integration, DataImport, andDataExport through the use of multiple ETL tools such as Informatica Power Center Experience in testing,datavalidation and writing SQL and PL/SQL statements - Stored Procedures, Functions, Triggers and packages.
• Have good Experienced on working in offshore/onsite model with ability to understand and/or create functional requirements working with client and also have Good experience in requirement analysis and generating test artifacts from requirements docs.

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, UNIX shell Scripting, VBScript,PERL, AWK, SED, JavaScript, HTML.

Data Modeling Tool: ER StudioDataArchitect, ERWIN, MS Visio, Power Designer (from Sybase)

Operating Systems: Microsoft Windows, Ubuntu, MAC OS X and UNIX.

ETL Tool: Informatica PowerCenter, Power Exchange for VSAM.

S/W development Methodologies: Agile, Waterfall models.

OLTP Tools: Microsoft Analysis Services, Business Objects, and Crystal Reports9.

Database Development Tools: Toad, SQL Navigator, PL/SQL Developer, SQL Developer, DBArtisan, AginityWorkbench for Netezza.

Others: MSOffice … (Word, Excel, PowerPoint, Access), MS Project, Rational Rose, UML.

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

Sr. Data Analyst / Data Modeler

Responsibilities:

• Worked inDataWarehousing project and obtained experience in design and implementation ofData Warehousing solutions especially design & development ofDataWarehousing,DataModeling, and Relational Database Systems.
• Worked on Data Modeling using DimensionalDatamodeling, Star Schema modeling, Snowflake modeling, and FACT and Dimensions tables in ERWIN.
• Experienced in Work closely withDataAnalysts, BI Developers and key business users to review design and develop the solution for LRM.
• Generate DDL scripts for implementingData Modeling 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.
• Experienced in Published Reports, workbooks &datasource to server and exporting the reports in different Formats.
• Experienced in enhancing 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 Power Center 8.6, Oracle 10g, PL/SQL, TIDAL, SQL, SQL Server, DB2, Kintana, PVCS, Windows XP, Oracle 10g,MDM, UNIX

Confidential, Pittsburgh, PA

Sr. Data Modeler/Data Analyst

Responsibilities:

• Experienced in Conducting JAD sessions, wrote meeting minutes, collected requirements from business users and analyzed based on the requirements.
• Responsible for translating requirements to technical specifications and worked on developing design documents like mapping documents anddatadictionary.
• Contributed to analytical modeling architectures, modeling standards, reporting, andData Analysis methodologies.
• Followed SDLC process, created detailed design and ETL design specification documents for each subject area of the project.
• Experienced in Designing the ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) for Oracle and Teradata as per business requirements using ERWIN
• Used ERWINDataModelerand ERWIN Model Manager to create Conceptual, Logical and Physical datamodels and maintain the model versions in Model Manager for further enhancements.
• Responsible to work with finance team, project stake holders,Data Architects andDataDefinition Owners in different subject areas.
• Responsible for supporting analytic initiatives requiringdata mining, detailed statistical analysis, and light development and automation.
• Experienced in Analysis of functional and non-functional categorizeddataelements fordata profiling and mapping from source to targetdataenvironment. Developed working documents to support findings and assign specific tasks.
• Resolved thedatatype inconsistencies between the source systems and the target system during the construction and maintained them in Mapping Documents.
• Involved with MS SQL Server configuration, database creation logins and user creation, granting object level permission.
• Supported ETL team in building the ETL maps to loaddatainto thedatamarts.
• Experienced in QlikView as a BI tool to see thedatacleansing trends and runningData profiling trends and presentation to Cleansing Team and/or business users. IDQ to create Dashboards, Reports & Scorecards to monitorDataQuality and monitor entries in the Global Xref tables.

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

Confidential, Pittsburgh, PA

Responsibilities:

• Gathered requirements from remotely based business users and defined and elaborated the requirements by holding meetings with the users
• Analyzed the historical documentation, supporting documentation, screen prints, e-mail conversations, presented business and wrote the business requirements document and got it electronically signed off from the stake holder
• Wrote the test cases and technical requirements and got them electronically signed off.
• Utilized simple methods like PowerPoint presentations while conducting walkthroughs with the stakeholders.
• Conducted GAP analysis so as to analyze the variance between the system capabilities and business requirements.
• Interacted with teams in AFS, ACBS and infolease to extract the information for the reports.
• Involved in defining the source to target data mappings, business rules, business and data definitions
• Created Logical/physical Data Model in ERWIN and have worked on loading the tables in the Data Warehouse
• Worked extensively with the ERWIN Model Mart for version control
• Experienced in Extensively designed Data mapping and filtering, consolidation, cleansing, Integration, ETL, and customization of data mart.
• Performed small enhancements (data cleansing/data quality).

Environment: MS Office 2007, MS Visio 2003, Windows XP, AFS, MS Excel, SharePoint, PowerPoint, MS Project, UML, SQLServer, ERWIN, Business Objects, MS Outlook

Confidential, Louisville, KY

Sr. Data

Responsibilities:

• Involved in requirement gathering from the business users to create a Business Requirement Document (BRD) document and Functional Requirement Document (FRD) to provide it to the application development team.
• Experienced in Work closely withDataAnalysts, BI Developers and key business users to review, design and develop the solution for LRM.
• Interacted with technical team members and business stakeholders to gather and analyze application requirements.
• Designed and modeledData Warehouse to handle information for more than 200 million accounts and dataprivacy based on local laws and regulations.
• Performed logicaldatamodeling, physicalData Modeling (including reverse engineering) using the ERWINData Modeling tool.
• Responsible fordata mapping, metadata maintenance and enhancing Conceptual, Logical and Physical
• Worked with the Application Development team to implementdatastrategies, builddataflows and developed conceptualdatamodels.
• Involved in providing SQL to tollgate anddataquality check to ETL to test thedatainserted by the Java rules engine into staging table as per requirement and logic to automate the process.
• Responsible for providing theData mapping document and rewrite of the PL/SQL queries from As-Is To-Be and validating thedatathrough PL/SQL.
• Worked closely withdatamodelersbased on business requirement to develop the new tables in USPF APR database and provided the key information forData Modeling such as logical and physical attributes, primary key and foreign key relationships.
• Developed the Entity Relationship diagram (ER) and the physical model in Visio.
• Utilized necessary PL/SQL scripting to perform various tasks such as validating and analyzingdata. Managed and resolved the issues of the users by supporting them in word processing, spreadsheet, databases and presentation software.
• Developed process models,dataflow models in MS Visio for understanding the system architecture.
• Experienced in Providing SQL to tollgate anddataquality check to ETL to test thedatainserted by the Java rules engine into staging table as per requirement and logic to automate the process.
• Developed detailed ER diagram anddataflow diagram using modeling tools following the SDLC structure
• Experienced in Provided PL/SQL queries to developer as source queries to identify thedataprovided logic to assign.

Environment: Oracle 8i, MS Visio, PL-SQL, Microsoft SQL Server 2000, Rational Rose, atawarehouse, OLTP, OLAP, ERWIN 9.2, Informatica 9.x, Windows, SQL, PL/SQL, SQL Server, TalendDataQuality, Talend Integration Suite 4x, Oracle 10g/11g, Flat Files, Windows XP, iReport, SVN

Confidential, Guymon, OK

Data Analyst

Responsibilities:

• PerformedData Analysis anddata profiling using sources systems including Oracle 10g/11g and Teradata.
• Conducted JAD sessions, wrote meeting minutes, collected requirements from business users and analyzed based on the requirements.
• Worked as aDataArchitect/Modelerto generateDataModels using ER Studio and subsequent deployment toEnterpriseDataWarehouse.
• Involved inData profiling and performedData Analysis based on the requirements, which helped in catching many Sourcing Issues upfront.
• Worked with supporting business analysis and marketing campaign analytics withdata mining,dataprocessing, and investigation to answer complex business questions.
• Defined ETL architecture which includes load pattern for staging and ODS layer using Microsoft SSIS ETL tool, file archival process,datapurging process, batch execution process.
• Experienced in Designed and Developed logical & physicaldatamodels and MetaDatato support the requirements using ERWIN.
• Involved using ETL tool Informatica to populate the database,datatransformation from the old database to the new database using Oracle.
• Involved in the creation, maintenance ofData Warehouse and repositories containing Metadata.
• DevelopedData mapping,DataGovernance, Transformation and Cleansing rules for the Master DataManagement Architecture involving OLTP, ODS and OLAP.
• Experienced in Documented logical, physical, relational and dimensionaldatamodels. Designed thedatamarts in dimensionalData Modeling using star and snowflake schemas.
• Performed logicaldatamodeling, physicalData Modeling (including reverse engineering) using the ERWINData Modeling tool.
• Experienced in Resolving thedatatype inconsistencies between the source systems and the target system during the construction and maintained them in Mapping Documents.
• Created documentation and test cases, worked with testing team for new module enhancements and testing.

Environment: Informatica Powercenter 9.1/8.6,IDE(Informatica Developer and/or Informatica Analyst), QlikView, IDQ (InformaticaDataQuality), Oracle11g/10g, SQL, PL/SQL, Oracle SQL Developer, HP Quality Center, Microsoft SQL Server, UNIX, Shell Scripts, Putty, Textpad, Winscp.