- Around 8 years of experience in Development and maintenance of database applications on SQL Server *** 2008R2/2012in OLTP/OLAP/BI environment.
- Extensive experience in Business Intelligence in MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS).
- Analyze and discuss the adaptations (client requirement) prepared by the functional team. Clarifications and conclusions follow.
- Work on various Business and Technical documents (Business Map, Business Change, Unit Test case, High level etc...).
- Worked Extensively on ETL process using SSIS package.
- Focused on Truncate & Load, Incremental (includes SCD) Loading by using various Packages.
- Experienced in creating simple, medium and complex packages by using normal and fast load options.
- Worked with Loop containers to continually repeat operations, Sequence container for transactional operations.
- Extensively worked on Data Flow taskvarious sources, transformations (Derived, Lookup, Conditional Split, Sort, Merge etc...) and destinations.
- Used Execute SQL Task, Script Task and Execute Package Task when required.
- Experience in creating configuration files to deploy the SSIS packages across all environments.
- Experience in creating jobs, SQL Mail Agent, Alerts and schedule SSIS Packages.
- Implementing error handling, branching, check point operation, configurations and parameterization.
- Created simple, Medium and complex reports based on Business Report D...