o 3+ years of Professional experience as Business Data Analyst, working on different Data Warehouse Projects o Experienced in all phases of Software Development Life Cycle (SDLC), on both Agile and Waterfall Methodologies and acted as a key member of Agile/Scrum team to communicate and to progress the project o Strong experience in Business and Data Analysis, Data Profiling, Data Migration and Data Integration o Efficient in analyzing and documenting Business Requirement Documents (BRD) and Functional Specification Design documents (FSD) along with Use Case Modeling and UML. o Extensive working experience in translating business requirements into creation of database objects o Experience with various ETL, data warehousing tools and concepts. o Expertise in defining scope of projects based on gathered Business Requirements including documentation of constraints, assumptions, business impacts & project risks. o Extensively worked with Subject Matter Experts, asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business and technical people. o Experience in understanding Stored Procedures, Stored Functions and Packages using PL/SQL. o Used ETL to load data from different source systems like Flat files into the Staging table and load the data into the target database. o Creating Tableau Dashboards using SSAS o Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica Power Center 7.1 o Extensively worked on Forward Engineering and Reverse Engineering. o Reverse engineered the database structure from the existing application using Sybase power designer. o Involved in the maintenance of enterprise metadata repositories. o Expertise in Physical Modeling for multiple platforms such as Oracle/Teradata/SQL Server/DB2. o Data Analysis using SQL on Oracle, MS SQL Server, DB2 and Teradata. o Gathered data, reporting and analysis requirements and translated into reporting structures data models, including aggregated tables, pivoted tables, and relational and dimensional (star-schema) marts. o Coordinated with DBAs, QA and external team for technical needs and to ensure the timely release of project. o Lead discussions and JAD Sessions with the Business Intelligence and developer team to discuss possible solutions and documenting the Software Requirement Specifications (SRS). o Worked on Tech BRD’s which would be standard templates and captured technical and data requirements o Worked as a design analyst and prepared mapping documents for FSD’s and checked in using Change Manager Tool. o Good communication skills, inter personal skills and proven ability to perform both as an individual and as a team player. o Trained in Oracle DBA and have knowledge in DBA concepts like Database installation, configuration, Tablespace management, User management and Data Pumps. TECHNICAL SKILLS Database Oracle 10g/11g/12c, SQL Lite, MS Access, Teradata SQL Languages C, Java, SQL, PLSQL Operating Systems DOS, Windows, Linux, UNIX Utilities SQL* Plus, SQL* Loader, TOAD, ETL tools, ERWIN, Power Designer SCM Tools Subversion (SVN), Team Foundation Server(TFS), Visual Source Safe (VSS) Data Modeling Tools Erwin 9.5/8/7, TOAD Modeler