Over 6 years of experience in developing BI applications utilizing SQL server, BI stack, Power BI, and Tableau. Proficient in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, SQL Server and MS Access Hands on experience with various transformations such as lookup, conditional split, multicast, Derived column, merge, for each, for loop, Multi - cast, sorting, Data profiling, Bulk insert, Sequence container, Delayed validations etc. in Integration Services development.
Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables. Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling. Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration, Conversions.
Extensive database programming experience in writing T-SQL, User Defined Functions, Triggers, Views, Temporary Tables Constraints and Indexes using various DDL and DML commands. Developed complex and customized Stored Procedures and Queries for implementing business logic and process in backend, for data extraction, reports and other client interfaces. Experience in managing and automating control flow, data flow, events. Generated reports with parameters, sub reports, cross tabs, charts using Crystal Reports.
Experience in Design, development of Business Intelligence Solutions using Tableau. Thorough understanding on connection managers, Checkpoint, Transactions, logging . Created Drill through reports, drill down reports, Sub reports, Cascading Parameters, Linked reports, Matrix etc. Using BIDS
Expertise in dealing with RDBMS including E/R Diagrams, Normalization and De-Normalization, Constraints, Data Import and Export etc. Experienced in Design and Optimization of OLTP, OLAP tools, creating SSAS based OLAP Cubes . Worked on projects using Agile and Waterfall model methodologies.
