About: Hiren Kapadia

• Over 11.5 years of experience in all phases of the SDLC. Analyze the requirements, estimate and propose the solutions, Project Planning, Project Architecture, DB Designing, Release Management and Team Management by setting protocols to be followed during the project execution. • In-depth knowledge and Involved in Systems Analysis and Design, Visual Modeling Using UML Diagrams (Flow Chart, Use Case Diagram, Activity Diagram, Class Diagram, Object Diagram & Sequence Diagram). • Experience working with Data Warehousing Concepts like Ralph Kimball Methodology, Bill Inmon Methodology, OLAP, OLTP, Star Schema, Snow Flake Schema, Fact Table, Dimension Table, Logical Data Modeling, Physical Modeling, Dimension Data Modeling. • Experience with high availability systems Very Large databases with proper data Archive and Purge processes. • Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP. • Expertise in writing SQL Queries and stored procedures, ETL using SSIS, Reports using SSRS, Cube & Multidimensional data using SSAS, Data warehousing and Reports using QlikView (BI tool). • Knowledge in database optimization and performance tuning of database and SQL queries using Query execution plan. Configuring/Troubleshooting SQL server, SQL server reporting service. • Very good Experience in .NET framework, VB.net, C#, ASP.Net ADO.net, Web Services, .Net Remoting and Multithreading.

Posts by Hiren Kapadia:

Older Posts »