=========================================================================-- FOR MORE AND LATEST PLEASE CONTACT VINAY SIR ----------------
1. Analyze and discuss the adaptations (client requirement) prepared by the functional team. Clarifications and conclusions follow.
2. Work on various Business and Technical documents (Business Map, Business Change , Unit Testcase ,High level etc...)
3 Focused on Truncate & Load ,Incremental (includes SCD) and Change Data Capture Loading by using various Packages.
4. Experienced in creating simple, medium and complex packages by using normal and Fast load options
5. Working with Loop containers to continually repeat operations,Seqence container for transactional operations.
6. Extensively worked on Data Flow task various sources,transforms(Derived,Lookup,Conditional Split,Sort,Merge ectc...) and destinations.
6. Used Execute SQL task,Script task and Execute Package task when required.
7. Implementing error handling ,branching,check point operation ,configurations and parameterization.
8. Created simple ,Medium and complex reports based on Business Report Design documents.
9. Using variables,parameters and various expressions to implement business logics.
10. Using various visualizations such as Table,Matrix,Chart,List ,Indicator etc...
11. Creating Drill Down , Drill through and Parameterized reports
8. Participated in the bottlenecks elimination of various packages ,reports and implemented tuning standards.
6. Experienced in writing queries by using SQL commands, keywords, functions, Sub Queries and joins ,procedures etc...
9. Reviewed & Tested packages and reports (Unit test ,Report test and Reconciliation).
11. Maintained versioning in Version Tools such as TFS ,Sharepoint Server etc...
12. Acquired good knowledge on Data Warehousing and Data Model Fundamentals.
13. Attended trainings on MSBI2014 version.
INDIVIDUAL PROJECT RESPONSIBILITIES=======================================================================
--FOR MORE AND LATEST PLEASE CONTACT VINAY SIR-----
• As an Associate I involved in getting documents, understanding, analysing documents, creating packages and queries according to those.
• In case of changes we follow CR document procedure of the client
• Different types of Data Loading (Direct, Incremental, SCD Type2 et...) implemented using packages and used configuration files.
• Handled, reported errors in error tables and files.
Using lookup ,derived, sort ,merge ,oledb command etc... transforms , various containers and tasks at control flow level.
• Written SQL queries and delivered results as per the client requirement
• Writing various queries (duplications, tops, aggregate operations etc...) as part of reconciliation and business logics Validation.
10. Used Sql commands and queries to monitor ,reconciliate and manage packages.
• Performance tuning of packages when necessary.
• Adhoc and Unit testing for packages.