- Financial Industry, Insurance and Retail industry.
- Hands on experience in developing Conceptual, logical models and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems (Data Marts).
- Expertise in the latest version of ERwin.
- Knowledgeable in modeling Kimball and Inmon Data Warehousing environments.
- Experienced in using SQL/DB2/Oracle/ SQL Server for data analysis and data profiling.
- Proficient in using Normalizing (1NF, 2NF, 3NF) and De-normalizing techniques for optimum performance in relational and dimensional database environments.
- Experienced in performing Data Analysis on SQL querying on Oracle, DB Visualizer Pro, MS SQL Server & MS Access and Information Data Quality (IDQ)
- Working knowledge on creating Dashboards in Tableau.
- Working knowledge in using 'R'.
- Skills:
- Database Modeling Tools
- Erwin 7.1/7.3/8/8.2/9.5/9.5.2,Rational Rose 2000, MS Visio 2000/2007/2010
- Databases & Database Tools
- MS & SQL servers 2000/2005/2008 , Oracle 10g/11g/12c, MS Access 2007/2010/2013, DB2 Visualizer Pro 9.1.2
- Reporting & Analysis Tools
- Informatica Developer Quality(IDQ) 9.6.1 , Tableau, Delphi Report Builder, OBIEE, R Studio
- Web Technologies
- C#, HTML
- ETL Tools
- Informatica Power Center, Datastage
- Technology
- NET Framework 4.0, ASP.NET Microsoft Visual Studio 2010/2013
| |