SUMMARY

• Over 7 years of IT experience in the field of Business/Data analysis, ETL Development, Data Modeling, Data Integration, Data Profiling, Data Mapping, Metadata Management Services, Data Warehousing using Informatica, Teradata and Oracle technologies.
• IT experience in System Analysis, Application Design, Data Modeling, Implementation and Testing of Enterprise Data Warehousing and Database.
• Experience in Data Modeling with expertise in creating Star & Snow - Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin and Embarcadero.
• Good experience in the field of business analysis, reviewing, analyzing, and evaluating business systems and user needs, business modeling, document processing.
• Having good experience as a Data Modeler, Data Analyst and SQL Developer.
• Experience in gathering requirements and making Business Requirement Document (BRD), Functional Specification Document(FSD) and SRS documents.
• Strong background in various DataModeling tools using ERwin, MS Visio.
• Competent knowledge in Data Modeling tools like ERwin, IBM Rational Software Architect (RSA) and ER/Studio.
• Created, Documented and Maintained Logical and Physical Database Models in compliance with enterprise standards.
• Excellent experience in Data Modeling using Erwin r9.5/9.6/r9.1/r8/r 7.1/7.3/4.5/4.1.4 , ER Studio.
• Experience in modeling OLTP and OLAP using tools like ERwin, SAP PowerDesigner 12.1 and ER/Studio.
• Coherent with Normalization/De-normalization techniques in relational/dimensional environments and have performed normalizations up to 3NF (Third Normal Form).
• Experience in developing data models which will serve both OLTP and OLAP functionality
• Good experience in Data Modeling with expertise in creating 3NF and Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin and ER Studio.
• Experience in modeling with both OLTP/OLAP systems through Ralph Kimball and Bill Inmon Data Warehousing environments.
• Proficient with the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables with data modeling tools ERWIN and ER Studio.
• Used SQL and Data Profiler tools. Very good understanding of scheduling the Informatica mapping using the Informatica workflow manager.
• Technical and Functional experience in Data warehouse implementations ETL methodology using Informatica Power Center 8.x / 9.x. Teradata, Oracle 10g/9i/8i and MS SQL SERVER in Finance, Health Insurance and Pharmacy Domains.
• Optimizing the queries which run in the production with high consumption of system resources. Proficient in Microsoft Excel, Word, PowerPoint and Visio.
• Extensive knowledge in Business Intelligence and Data Warehousing Concepts with emphasis on ETL and System Development Life Cycle (SDLC).
• Working Knowledge of Data warehousing concepts like Star Schema and Snowflake Schema, Data Marts, Kimball Methodology used in Relational, Dimensional and Multidimensional data modelling.
• Proficiency in design and developing the ETL objects using Informatica Power Center, SSIS with various Transformations like Joins, Aggregate, Expression, SQL, Lookup, Filter, Update Strategy, Stored Procedures, Normalizer transformations etc.
• Proficient in implementing complex business rules by creating re-usable Transformations, Workflows and Mappings.
• Experience in programming with SQL and PL/SQL (Stored Procedures, Functions, Cursors, and Database Triggers).
• Strong SQL experience in Teradata from developing the ETL with Complex tuned queries including analytical functions and BTEQ scripts.
• Extensively used Mapping Variables, Mapping Parameters, and Dynamic Parameter Files for improved performance and increased flexibility and also worked with XML Sources & Targets.
• Experience in performing reverse engineering of physical data models from data, SQL scripts. Created ERWIN reports in HTML, RTF, PDF format depending upon the requirement.
• Excel Expert with success in maintaining and organizing data, including dictionaries, metadata repositories, and cross-reference indexes across a broad range of industries.
• Skilled in vlookup formula development, Pivot Table generation, and Pivot reporting.
• Demonstrated ability to use critical and strategic thinking to resolve discrepancies, fill gaps, and sustain quality control benchmarks. Experience in using SSRS, crystalreports, cognos, tableau in creating and managing reports for an organization.
• Developing workflows with Worklets, Event waits, Assignments, Conditional flows, Email and Command Tasks using Workflow Manager.
• Experienced with identifying Performance bottlenecks and fixing code for Optimization in Informatica and Oracle.
• Created UNIX shell scripts for Informatica post and precession operations, database.
• Administration and day-to-day activities like monitor network connections and database ping utilities.
• Extensive experience in implementation of Data Cleanup Procedures, Transformation, Scripts, Stored Procedures and execution of Test plans for loading the data successfully into Targets.
• Creating checklists for coding, testing and release for a smooth, better & error free project flow.

TECHNICAL SKILLS

Data Modeling Tools: ERwin r7.1/7.2, ERwin r8.2, ERwin r9.1/9.5, 9.6, Embarcadero ER/Studio, Oracle Designer, Sybase Power Designer.

OLAP Tools: Microsoft Analysis Services, Business Objects and Crystal Reports 9.

Programming Languages: SQL, T-SQL, PL/SQL, Base SAS, HTML, XML, VB.NET, C, C++, UNIX and Shell Scripting.

Database Tools: MicrosoftSQLServer 2000/2005/2008/2012/2014 , MySql, Oracle 11g/10g/9i/8i, DB2, MS Access 2000 and Teradata V2R6.1.

Packages: Microsoft office Suite, Microsoft Project 2010, SAP and Microsoft Visio.

ETL Tools: Informatica 7.1/6.2, Data Junction, Ab-Initio, Data Stage, SSIS.

Other Tools: SAS Enterprise Guide, SAP ECC and Panorama Web Service, CodeFlow/TFS

PROFESSIONAL EXPERIENCE

Confidential, EL Paso, TX

Data Analyst/Data Modeler

Responsibilities:

• Involved in full Software Development Life Cycle (SDLC)-Business Requirements, preparation of Technical Design documents, Data Analysis, Logical and physical database design, Testing, and deploying to business users.
• Involved in gathering business requirements, logical modeling, physical database design, data sourcing and data transformation, data loading, SQL and performance tuning.
• Developed aConceptual modelusing Erwin based on requirements analysis.
• Developed normalizedLogicalandPhysicaldatabase models to design OLTP system for insurance applications.
• Created dimensional model for the reporting system by identifying required dimensions and facts usingErwin r9.6.
• Used forward engineering to create a Physical Data Model withDDLthat best suits the requirements from the Logical Data Model.
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.
• Identified, formulated and documented detailed business rules and Use Cases based on requirements analysis.
• Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation.
• Responsible for defining the naming standards for data ware house, Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy DB2 andSQL Serverdatabase systems.
• Exhaustively collected business and technical metadata and maintained naming standards.
• UsedErwinfor reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• 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
• Used Model Mart ofErwinfor effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Extracted data from the databases (Oracle and SQL Server, DB2, FLAT FILES) using Informatica to load it into a single data warehouse repository.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT).
• Integrated the work tasks with relevant teams for smooth transition from testing to implementation.

Environment: Erwin r9.6, Informatica Power Center, SQL Server 2012/2014, SQL, Oracle, DB2, MS Excel, Mainframes MS Visio, PL/SQL.

Confidential, Franklin, TN

Data Analyst/SQL Developer

Responsibilities:

• Analyzed consumer surveys and gave technical inputs in business meetings.
• Involved in the meeting with business process owners, SME (subject matter experts) and marketing team for requirements gathering in definition stage.
• Gathered the requirements, develop process model and detailed business policies and modified the business requirement document.
• Developed aConceptual modelusing Erwin based on requirements analysis.
• Developed normalizedLogical (relationship, cardinality, attributes, and, candidate keys)andPhysicaldatabase models to design OLTP system for the applications.
• Created dimensional model for the reporting system by identifying required dimensions and facts usingErwin r9.
• Used forward engineering to create a Physical Data Model withDDLthat best suits the requirements from the Logical Data Model.
• UsedErwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Conduct design discussions and meetings to come out with the appropriate data mart at the lowest level of grain for each of the dimensions involved.
• Designed a STAR schema for the detailed data marts and plan data marts involving confirmed dimensions.
• Created and maintained the data model repository as per company standards.
• 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.
• Collaborated with the reporting team to design monthly summary level cubes to support the further aggregated level of detailed reports.
• Worked on the snow-flaking the dimensions to remove redundancy.
• Designed sales hierarchy dimensions to handle sales hierarchy reporting historically and dynamically.
• Documentation of all entities, attributes,datarelationships, primary and foreign key relationships, allowed values, codes, business rules, glossary terms, etc.is done.
• Built a set of reports which includes historical same-period comparisons.Enhance and build selected redirect reports with the flexibility of an OLAP service.
• Created SSIS packages to load data into staging table and data mart and also performed logging in SSIS packages to capture error data and for error handling.
• Extract data from flat files which comprised of header and input files to SQL server and Created Testing scripts for staging validation, generated the Map Force file for mapping between flat file and database.
• Create various file and database validation rules like schema validation, null file validation, invalid file format validation, duplicate file validation and database connection check validation.
• Document ETL framework and a template package to help developers understand ETL development strategies.

Environment: Erwin r9/9.1, SQL Server 2012/2014, Oracle 11g, SQL, SSIS, Teradata, Source Analyzer,Datawarehouse designer, Workflow Manager, Workflow Monitor, Tableau, PL/SQL, SAS.

Confidential, Atlanta, GA

Data Modeler/Business Analyst

Responsibilities:

• Communicated with the Service Integration (SI) team for understanding the functionality, structure and flow of the Middle Tier Integration (MTI) services for the Consumer Business Banking (CBB) line of business.
• As an IT Business AnalystIntern, involved in performing data validation, data mining, and statistical analysis and creating and visualizing dashboards.
• Interacted with Business Analysts to understand the business requirements. Gathered the necessary information for Canonical Modeling/Business Object Modeling (BOM).
• As a part of the working sessions with the Business Analysts, identified the logical names as per the Integrated Frame Work (IFW) standards.
• Closely worked with the Index modeling team to get the physical level information.
• Part of the daily sessions with Data Architects to review the work.
• Developed the canonical model objects and relationships between them to represent the business requirements of the services using the IBM Rational Software Architect (RSA).
• Performed mapping from SI services (source) to Canonical Model Repository (target).
• Created Canonical business attributes, classes and relationships using the RSA tool.
• Created class diagrams for the specific services.
• Worked extensively with XML Modeling(SI) team to make them understand the schema and data standards.
• Using the compare option in the RSA tool, performed merging on different Canonical (BOM) files from different projects and created a unified Canonical BOM model.
• Created and maintained the Canonical log (BOM log) for all the MTI services, withholding package level, class level, and physical level information for the attributes.
• Created logical model from the canonical model (BOM).
• Created the physical data model from the logical data model.
• Worked as a part of the review and collaboration sessions regarding business processes, canonical (BOM) modeling.
• Conducted business meeting sessions for addressing discrepancies and resolving them.
• Assisted the Interface Design Model (IDM) team in understanding the Business Model.
• Participated in the Data Review Board (DRB) reviews as a part of the Data Architecture Team by playing the role of a secondary and email reviewer.
• Provided recommendations as a part of the DRB review sessions, to see if the attributes at the physical and logical level abide by the naming standards.

Environment: IBM Rational Software Architect 7.1s, Erwin8.x, MS Excel, Oracle 11g.

Confidential, Salt Lake City, UT

Informatica/Teradata Developer

Responsibilities:

• Documented and delivered functional specification document to the project team.
• Assisted the Project Manager to develop both high-level and detailed application architecture to meet user requests and business needs.
• Worked extensively in writing and debugging complex stored procedures, triggers, Inner Joins, Outer Joins, views and user-defined functions.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS.
• Installed, configured and maintained SQL Server Integration Services (SSIS).
• Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files, OLEDB.
• Experience with the Share point 2007 to upload the SSIS packages in to Web portal.
• Participated in requirement gathering, cube design, application design, SSAS development, training operational users.
• Implemented SQL Server OLAP services (SSAS) for building the data cubes.
• Creating complex cubes for seeing business data from different perspectives by slicing and dicing the data.
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
• Defined MDX scripts for querying the data from OLAP cubes (SSAS) and build reports on top of cubes.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS).
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
• Developed reports using SSRS and published as PDF, Excel, and CSV formats.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Designing and building data load procedures using MS SQL Server. Designed and implemented Stored Procedures and Triggers for automating tasks.
• Configured product meta-data tables to support client data reporting needs.
• Incremental and full database recovery with experience of complex recovery scenarios.
• Analyzed database performance with SQL query manager and Optimized indexes to significantly improve queries.

Environment: MS SQL Server, SQL Server Integration Services (SSIS), SSRS, SSAS, T-SQL, OLAP Services, MDX, Share point, ASP.NET, C#.NET, XML, Microsoft Source safe, Clear Quest, Windows.

Confidential

Data modeler/Data Analyst

Responsibilities:

• Used Reverse engineering to connect to existing database and create graphical representation (E-R diagram).
• Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
• Worked on conceptual/logical/physical data model level using ER Studio/ERWIN according to requirements.
• Interacted with various Business users in gathering requirements to build the data models and schemas.
• Extracted data from Oracle and SQL Server and DB2 using Informatica to load it into a single data warehouse repository.
• Created entity relationship diagrams and multidimensional data models, reports and diagrams for marketing.
• Model Mart of ERwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Created Data Models for multiple subject areas involving star and snowflake schemas using Erwin.
• Involved in Logical to physical data model conversion, Forward Engineering, Reverse Engineering, DDL generation.
• Involved in ETL data mapping for source to target tables and also worked on ETL scripts to do the ETL.
• Developed and implemented measurements for various marketing campaigns.
• Created a net loss model which analyzes the impact of loan defaults and recoveries.
• Created a relational model and dimensional model for online services such as online banking and automated bill pay.
• Applied data cleansing/data scrubbing techniques to ensure consistency amongst data sets.
• Developed logical data models and physical data models using ER-Studio.

Environment: Teradata 12.0 (FastLoad, MultiLoad, FastExport, BTEQ), Teradata SQL Assistant, Informatica Power Center 8.5, Unix, SQL, PL/SQL, Work Load Manager, MS Access, UNIX.

Confidential

Data Modeler/Data Analyst

Responsibilities:

• Studied in-house requirements for the Data warehouse to be developed.
• Conducted one-on-one sessions with business users to gather data warehouse requirements.
• Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions.
• Developed aConceptual modelusing Erwin based on requirements analysis.
• 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.
• Used forward engineering to create a Physical Data Model withDDLthat best suits the requirements from the Logical Data Model.
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.
• Identified, formulated and documented detailed business rules and Use Cases based on requirements analysis.
• Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation.
• Responsible for defining the naming standards for data warehouse.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy DB2 andSQL Serverdatabase system.
• Exhaustively collected business and technical metadata and maintained naming standards.
• UsedErwinfor reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups and their privileges.
• Erwinfor effective model management of sharing, dividing and reusing model information and design for productivity improvement.

Environment: Informatica 8.5 (Designer, Repository Manager, Workflow Manager, Workflow Monitor), Teradata 12, UNIX, Citrix, Toad, PL/SQL Developer