- Over 8 yearsof IT experience in software development, designing and implementation with major focus around Business Intelligence, Data Warehousingand Database Applications.
- Hands on experience on T-SQL,MSBI-SSIS, SSAS, SSRS, MDX, DAX, Power Pivotand Power Viewreports.
- Experienced with full life Cycle phase of SDLC involving Systems Analysis, Design, Development and Implementation.
- Experience in Designing Business Intelligence Solutionswith Microsoft SQL Server 2008and […] using MS SQL Server Integration Services(SSIS),MS SQL Server Reporting Services(SSRS) and SQL Server Analysis Services(SSAS).
- Excellent skills in Developing SSIS Packagesto Extract, Transformand Load(ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, Sybase, Excel Sheets, Flat Filesand MS Access.
- Experience in developing custom reports and creating various types of reports like On demand, drill down, Drill-through, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Sub Reports, Ad hoc Reports, dynamic grouping, Cross-Tab, graphical, distributed Reports in multiple formats using SQL Server Reporting Services(SSRS) and Business Intelligence Development Studio(BIDS).
- Having development experience of .net components for reusable content framework for SSRS reports.
- Experienced Interacting with the business users to gather report requirements and finalize the deliverables.
- Expertise in developing reports related to Market Research & Analysis, Design & Modeling of Supply Chain, Economic Analysis of Industrial Projects and Resource Planning.
- Extensively worked on Documents and Dashboardsto facilitate customized multi-report display for advanced visual effects and give the privilege to business users for better business analysis.
- DevelopedScorecardsfor key performance indicator, including all drill options. Use of drill maps to jump and segregate data in required form.
- Experience in developing Security Filters, Access Control Lists, Security Rolesand assigning privileges.
- Good knowledge in buildingintelligentcubereports to analyze data from different source systems.
- Good understanding of Data Warehousingconcepts, Data ModelingandOLAP.
Technical Skills:
BI Tools
SSAS, SSIS, SSRS, BIDS, Informatica Power Center, OBIEE, Crystal Reports, Data Modeling
Tools
SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS), Crystal Reports, Power, ProClarity, Microsoft Office.
Databases
Oracle 10g/11g/12g, SQL Server, Teradata
Data Modeling Tools
IBM Infosphere Data Architect, ERWIN, MySQL, MS VISIO
