About Me

• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Mining, Data Integration and Metadata Management Services...Data Mining, Data Integration and Metadata Management Services.
• Expert level experience in Oracle SQL, PL/SQL (Packages, Stored Procedures, Functions, Triggers, Cursors, Collections, OLAP queries, java stored procedures. In depth knowledge of Oracle packages and database dictionaries.
• Expert level experience in transforming & loading data from Oracle database to Amazon Redshift (MPP) database using Pentaho jobs & transformations and Linux scripts. Experienced in generating various types of data formats including XML using Pentaho DI.
• Good experience in Data Science/Statistical computing using Python & R programming language. Experienced in data acquisition/cleaning, exploratory analysis, Predictive models and creation of data products using Shiny server.
• Expert level experience in Data Warehousing, Data Modeling with expertise in creating Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling.
• Expert level experience in analysis, design, development, testing, implementation and maintenance of applications in Oracle Application Express (Oracle APEX v2.0-5.0).
• Possess knowledge of Oracle database 11g/12c, AWS Redshift, Pentaho BI, Pentaho DI, Oracle Apex & NoSQL databases. Also, have experience in multiple reporting tools like Pentaho Report Designer, MicroStrategy, Business Objects and Jreport.
• Strong knowledge of performance tuning, including extract and load processes.
• Experienced in Agile based development. Organizing and leading the database team guiding technically around the architecture by exhibiting fine leadership qualities.
• Ability to understand current business processes and implement efficient business process.
• Expertise in defining scope of projects based on gathered business requirements including documentation of constraints, assumptions, business impacts & project risks.