Used OWB as ETL tool to extract data from source systems, cleanse Transform, and Load data into databases.
Involved in many meetings with the customers, Business and users to understand their requirements and to effectively change the existing design to improve the performance.
Ensured that Business Requirements can be translated into Data Requirements.
Attended and participated in information and Requirements Gathering sessions.
Packages: Microsoft Office Suite, Microsoft Project 2010, SAP and Microsoft Visio.ĮTL Tools: Informatica 7.1/6.2, Data junction, Ab-Initio, DataStage, SSIS,BODS. Programming Languages: SQL, Confidential - SQL, PL/SQL, Base SAS, HTML, XML, VB.NET, C, C++, UNIX and Shell Scriptingĭatabase Tools: Microsoft SQL Server 2000/2005/2008/2012/2014, MySQLOracle 11g/10g/9i/8i, DB2, MS Access 2000 and Teradata V2R6.1 OLAP Tools: Microsoft Analysis Services, Business Objects and Crystal Reports9.
Excellent communicative, interpersonal, intuitive, analysis, leadership skills, quick starter with ability to master and apply new concepts.ĭata Modelling Languages: Erwin r7.1/7.2, Erwin r8.2, Erwin r9.1/9.5/9.6Embarcadero ER/Studio, Oracle Designer, Sybase, Power Designer.
Facilitated and participated in Joint Application Development (JAD) sessions, and white board sessions to keep executive staff and the team members apprised of goals, project status, and resolving issues.
Worked with Architects, Developers and Quality Assurance lead to understand Use Case and functional requirements.
Well versed in conducting Gap analysis, User Acceptance Testing (UAT), Cost benefit analysis and ROI analysis.
Experience in creating scripts to fetch data from NoSQL database like MongoDB.
A good familiarity and expertise in the work environment including things like Business analysts, Production/Support teams, Subject Matter Experts, Database Administrators and Database developers.
Experienced in Database using Oracle, XML, Teradata, SQL server and NoSQL.
#ERWIN R9 LOCKS SOFTWARE#
Experienced with most of software deployments methodologies like Water Fall, Iteration, Agile and Rapid Application Development (RAD).
Excellent knowledge of SDLC phases (Inception, Elaboration, Construction and Transition).
Excellent knowledge of complete data warehouse life cycle, testing methodologies, OLAP and OLTP.
Excellent knowledge on logical application design and physical implementation for database application.
Excellent knowledge of Bill Inmon and Ralph Kimball methodologies to design database architecture.
Experienced with Data Quality Management, Metadata Management, Master Data Management, Process Modeling, Data Dictionary, Data Stewardship, Data Profiling, Data Quality, and Data Model Standards.
Experience in Data Scrubbing/Cleansing, Data Quality, Data Mapping, Data Profiling, Data Validation in ETL.
Experienced with integration of External Data with SAP in Business Warehouse.
Efficient in analyzing and documenting business requirement documents (BRD) and functional requirement documents (FRD) together with UseCase Modeling and UML.
Very proficient with Data Analysis, mapping source and target systems for data migration efforts and resolving issues relating to data migration.
Well versed in Normalization / Denormalization techniques for optimum performance in relational and dimensional database environments.
Designed the Data Marts in dimensional data modeling using star and snowflake schemas.
Experience in Requirement gathering, System analysis, handling business and technical issues & communicating with both business and technical users.
Experience in designing star schema, Snowflake schema for Data Warehouse, ODS architecture.
Experience working with data modeling tools like Erwin, Power Designer and ER Studio.
Experienced with all major databases: Oracle, SQL Server 2008/2012, Teradata in large data warehouse (OLAP) environments.
11+ years of experience in Data Analysis, Design & Modeling across various industries, clients and geographies.