PROFESSIONAL SUMMARY:

• Confidential has 12+ years of experience in Information Technology with expertise in data modeling/ data analysis for data warehouse /online transaction processing (OLTP) /business intelligence (BI) applications.
• Evaluating Data Sources and strong understanding of Data Warehouse/Data Mart Design, ETL, BI, OLAP, 3NF OLTP data models.
• Implemented dimensional & relational data structures.
• Deep understanding of the data modeling (dimensional & relational) concepts.
• Facilitated data modeling requirement session with stake holders.
• Experience in handling end - to-end data warehouse implementations and in leading & managing teams.
• Expertise in normalization/de-normalization, data extraction, data cleansing, data Migration.
• Experience in working and creating 3rd Normal Forms(ODS) and Dimensional models (OLAP).
• Worked very close with Data Architect and DBA team to implement data model changes in database in all environments.
• Experience in testing and writing SQL and PL/SQL statements .
• Tested Oracle Data Integration (ODI) mappings.
• Solid hands on experience with administration of data model repository, documentation in Meta data portals in such as Erwin and ER Studio.
• Expertise in all aspects of data management methods and practices including Data Modeling, creation of Logical and Physical Data Models (LDMs/PDMs), Design of Data warehouse schemas, Forward engineering and reverse engineering, creation of data Lineage documents and Data migration/conversion with ETL tools and data warehousing.
• Extensive experience in source system analysis.
• Excellent experience in writing SQL queries to validate data movement between different layers in data warehouse environment.
• Strong experience in using Excel and MS Access to dump the data and analyze based on business needs.
• Excellent experience in trouble shooting SQL queries, ETL jobs, Datawarehouse/DataMart.
• Experience in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures and Views.
• Expert in developing transactional enterprise data models that strictly meet normalization rules, as well as Enterprise Data Warehouses using Kimball and Inman Data Warehouse methodologies.
• Extensive experience in writing functional specifications, translating business requirements to technical specifications.8
• Experience in Big-Data data warehouse (Data Lake, HBase, Hive, Pig) .
• Knowledge of cloud computing infrastructure (e.g. Amazon Web Services EC2, S3, Redshift) .
• Possess strong Documentation skill and knowledge sharing among Team, conducted data modeling review sessions for different user groups, participated in requirement sessions to identify requirement feasibility.
• Created enterprise standards/meta data.
• Strong analytical and interpersonal skills.

TECHNICAL SKILLS:

ERP system: workday, success factors, PeopleSoft

Reporting Tools: SSRS, Cognos, Tableau, Power Bi

Operating Systems: Windows NT/XP/95/98, Windows 2000/2003, MS-Dos,Unix.

Languages: C, C++, Java, SQL, PL/SQL, java script and Shell Scripts.

GUI Tools: Visual Basic 5.0/6.0,Jira

Database: Oracle 11g/10g/8i/7.2, SQL Server, Teradata 12/14

MS: Office, TOAD, SQL Developer, SQL Navigator, Teradata SQL Assistant, Putty

ETL/Data warehousing: Informatica, SSIS, Oracle Data Integrator(ODI)

ER: Studio, Erwin 9.5,7x,6x (Dimensional data Modeling, Relational Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Physical and Logical Data Modeling, Canonical Modeling), SQL Developer, Visio 6.0.

Workload Automation: TWS

EXPERIENCE:

Confidential, Cary, NC

Sr. Data Modeler

Responsibilities:

• Conducted one-on-one sessions with business users to gather data warehouse requirements.
• Studied in-house requirements for the Data warehouse which needs to be developed.
• Analyzed database requirements in detail with the project stakeholders by conducting Requirement gathering sessions.
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.
• Has the lead the tech team to make sure the delivery of the code is consistent with the Sprint using Jira.
• Identified, formulated and documented detailed business rules and Use Cases based on requirements analysis.
• Developed a Conceptual model using Erwin based on requirements analysis.
• Developed normalized Logical and Physical database models to design OLTP system for insurance applications.
• Publish new Data Dictionaries and also update the existing Data Dictionaries to make sure it is upto date.
• 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.
• Generate DDL and Validate if the DDL is implanted properly in Higher environment .
• 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 and SQL Server database systems.
• 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.
• Facilitated development, testing and maintenance of quality guidelines and procedures along with necessary documentation.
• 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

Confidential, Irving, TX

Sr. Data Modeler

Responsibilities:

• conducted one-on-one sessions with business users to gather data warehouse requirements.
• Understand the business requirements (functional and non-functional) and work with the Business and the Technical team to provide estimations.
• Conducted data modeling sessions with stake holders.
• Conducted design reviews with business analysts, solution lead to create proof of concept for the Rule Engine.
• Worked extensively in creating database objects like Procedures, Functions, Packages, Views, Dynamic SQL as part of Application requirement.
• Created Conceptual, logical & Physical models as per the data warehouse standards using Erwin.
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin.
• Publish new Data Dictionaries and update the existing Data Dictionaries to make sure it is upto date.
• Tuned database SQL statements and procedures by monitoring run times and system statistics.
• Generate DDL and Validate if the DDL is implanted properly in Higher environment.
• Developed the process to dynamically update the business rules in rule engine rather using the ETL to change the rule when an enhancement to the existing rule is proposed by business user which increases the overall efficiency of the application and time.
• Created ETL plan and Data Mapping documents (from golden source to target system) .
• Documented all the data workflow, packages, procedures and functions involved in ETL process.
• Gathered reporting requirements from business end users/clients. Identified key dimensions and facts.
• Conducted data modeling/Data Designs sessions with stake holders.
• 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.
• Capture data models from existing databases into Erwin.
• Interacted with the business representatives to Identify the subject areas & to validate the designed models.
• Responsible for Data Modeling and Database Design of bringing in bringing in multiple source systems into the data warehouse central repository.
• Helping the team in fixing the issues facing in data (both ETL and Reporting teams).
• Working with Cognos developer to make sure the reports are being populated according to requirement.
• Optimizing the queries which are used to populate the tableau reports .
• Worked on creating unit test cases.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT).
• Lead daily scrum calls with the client as well as other team members to discuss on status of the application being developed.

Confidential, Reston, VA

Sr. Data Modeler

Responsibilities:

• Conducted data modeling sessions with stake holders.
• Analyzed source data for inconsistency.
• Developed conceptual /logical model using ER-Studio.
• Developed Logical Model from the conceptual model.
• Publish new Data Dictionaries and also update the existing Data Dictionaries to make sure it is upto date.
• Worked with DBA's to create a best-fit Physical Data Model from the logical data model.
• Conducted design reviews with business analysts, Enterprise data architect and solution lead to create proof of concept for the reports.
• Involved in data model reviews as data architect with business analysts and business users with explanation of the data model to make sure it is in-line with business requirements.
• Forward engineered to create DDL.
• Validated the data model using story boarding /use cases.
• Built an inventory of data needed to implement the architecture.
• Responsible for the data architecture design delivery, data model development, review, approval and Data warehouse implementation.
• Used Informatica designer, workflow manager and repository manager.
• Performed unit testing, system integrated testing for the aggregate tables.
• Worked over ETL methodology for supporting data analysis in a corporate-wide-ETL solution using Informatica.
• Created and maintained Informatica Mappings.
• Wrote several adhoc sql queries to validate ETL.
• Created and Maintained metadata (data definitions of table structures) and version controlling for the data model.
• Delivered data solutions in report/presentation format according to customer specifications and timelines

Confidential, New York, NY

Data Modeler

Responsibilities:

• Created Conceptual, Logical Data model using Erwin for both relational and dimensional models.
• Reverse engineered reports to understand business rules and process.
• Conducted Design sessions.
• Designed normalized /dimensional data model for OLTP / data warehouse project.
• Designed cubes for BI application.
• Involved in designing Logical data model and Physical conceptual data model using Erwin.
• Extracted data from different sources like SQL Server, DB2 and flat files and loaded into Oracle data base and data warehouse/data mart according to the specifications.
• Responsible for the mapping of the data from source to target
• Analyzed business process workflows and developed ETL procedures for moving data from source to target systems.
• Created and maintained Informatica Mappings.
• Publish new Data Dictionaries and also update the existing Data Dictionaries to make sure it is upto date.
• Developed scripts for database tuning procedures.
• Documented all the data workflow, packages, procedures and functions involved in ETL process.
• Gathered reporting requirements from business end users/clients. Identified key dimensions and facts for analytical reporting and decisions support reporting to develop custom reports
• Created rationalized domains to bring consistency in the tables.
• Involved in Manual and Automated testing using QTP and Quality Center.
• Identified source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Worked with cross-functional teams and prepared detailed design documents for production phase of current customer database application.
• Worked on data profiling, data validation, data quality to ensure the accuracy of the data between the warehouse and source systems.

Confidential, Bentonville, AR

Data Modeler/ Data Analyst

Responsibilities:

• Created and reviewed the conceptual model Enterprise Data Warehouse with business users.
• Analyzed the source system to understand the source data along with in detail understanding of business rules.
• Identified various facts and dimensions from the source system and business requirements to be used for the data warehouse.
• Studied the existing CC&B architecture and analyzed the existing systems to propose the alternate solutions.
• Created and maintained ODI Mappings.
• Proposed the EDW data design to centralize the data scattered across multiple datasets. The proposal also address the data duplications, data in consistencies, data quality management etc.
• Created the dimensional logical model with approximately 10 facts, 30 dimensions with 500 attributes using ERWIN.
• Developed data governance plan.
• Implemented the Slowly changing dimension scheme for most of the dimensions.
• Implemented the standard naming conventions for the fact and dimension entities and attributes of logical and physical model.
• Developed ETL plan and mapping.
• Extracted data from different sources like SQL Server, DB2 and flat files and loaded into Oracle data base and Teradata warehouse/data mart according to the specifications.
• Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis.
• Reviewed the logical model with Business users, ETL Team, DBA’s and testing team to provide information about the data model and business requirements.
• Created the DDL scripts using ERWIN tool and source to target mappings (S2T- for ETL) to bring the data from source systems to the warehouse.
• Worked with DBA to create the physical model and tables.
• Worked on the model based volumetric analysis and data based volumetric analysis to provide accurate space requirements to the production support team.
• Worked on Mercury Quality Centre to track the defect logged against the logical and physical model also for development part where I was involved and test support of module systems.
• Worked as an onsite project coordinator once the design of the database was finalized in order to implement the data warehouse according to the implementation standards.
• Worked with client and off shore team to make sure that the reports are delivered on time.
• Participated in UAT sessions to educate the business users about the reports. Worked with the test team to provide insights into the data scenarios and test cases.
• Worked on data profiling and data validation to ensure the accuracy of the data between the warehouse and source systems.
• Conducted data governance council meeting for data definition.

Confidential, Indianapolis, IN

Data Modeler/Data Analyst

Responsibilities:

• Translate the business requirements into logical and physical data model, analyze data across data sources to support requirements, identify integration and security requirements and develop data architecture for supporting IT solution.
• Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS and OLAP.
• Responsible for modeling of BI solutions including dimensional data marts and operational reporting databases and establish and maintain processes to support and grow data modeling practices
• Identified source systems mapping.
• Performed Data Analysis and Data Profiling and worked on data transformations and data quality rules.
• Facilitated modeling sessions and design walk-throughs with DBA and development team members.
• Conducting strategy and architecture sessions and deliver artifacts such as MDM strategy (Current state, Interim State and Target state) and MDM Architecture (Conceptual, Logical and Physical) at detail level.
• Extensively used Aginity Netezza work bench to perform various DML, DDL etc. operations on Netezza database.
• Involved with impact assessment in terms of schedule changes, dependency impact, code changes for various change requests on the existing Data Warehouse applications that running in Production environment.
• Interacting with business users to understand the business requirements.
• Coordinating with Business analysts to understand the business challenges and data for reporting.
• Designed Stars schema for Risk Retail reporting for credit card portfolio subject area.
• Conducted design reviews with business analysts, Enterprise data architect and solution lead to create proof of concept for the reports.
• Developed SQL scripts for creating tables, Sequences, Triggers, views
• Worked with DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering using Erwin
• Prepared detailed design document.
• Worked on requirements traceability matrix.

Confidential

Developer

Tools: PS 8.51.

Application: PS EP 8.9, PS HRMS 8.9.

Languages: People Code, Sql .

Responsibilities:

• Developed /modified pagelet according to the client requirements.
• Developed customizations using Application Designer for PO and INV.
• Authored PeopleSoft OM for Capturing and validating Orders.
• Applied PeopleSoft fixes and patches to Inventory module.
• Customized RMA SQR report to display RMA transactions for internal and external locations in inventory module.
• Built and customized Component Interface and
• Used CI for Item Loader process.
• Enhanced existing SQR’S to print invoices, purchase orders, price confirmations and request for quotes,
• Wrote and compared reports before and after applying the patches fixes.

Confidential

Developer.

Tools: PS 8.47.

Application: PS HRMS 8.9.

Languages: People Code, HTML, JavaScript.

Database: Oracle10g.

Responsibilities:

• Developed Online Pages using Application Designer and People code.
• Developed reports and interfaces using SQR and Application Engine.
• Transferred historical data from legacy system to new system using SQR process.
• Developed Component interface to transfer the transaction data from legacy to PeopleSoft.
• Performed go-live activities for move to production.