Feb-07 to till date
Cognizant Technology Solutions. Chennai
Other Technical Skills:
Areas of Expertise
Sqlserver, VB scripting,Sharepoint Server
Title Of Course
B.Tech – Electronics & Communication Engineering
SSIS,SSRS , Sqlserver,Win
· The existing MRDP reports generation by oracle reports is to be replaced by the SSIS and SSRS jobs. There are several translations that should be set for each customer based on the customer id assigned to each customer. The translation files are created from EMS process, which has also the schedule job master file created. Totally there 60 reports that needed to be created by this process. The process runs on a daily basis.
· As an Associate I involved in getting docs (which are kept in Sharepoint Server), understanding, analyzing ,creating and manipulating various packages and queries according to those.
· In case of changes we follow CR document procedure of the client
· I prepared several types of documents (Technical, Unit test) required for the project.
· Different types of Data Loading (Direct, Incremental, SCD Type2 et...) implemented using packages and used configuration files.
· Handled errors in packages and reported errors in error tables.
. Identified long running packages and did tuning according to the
. Written many Unit test cases and Implemented Unit test results.
. Worked with various Control Flow items(For Loop,For Each loop,
Sequence ,Execute Sql task,File System task) and Data Flow items (Flat File and Oledb source and Dest,Derived column,Sort,Lookup,Conditional Split,Multicast etc...).
. Created many simple,complex and dynamic reports.
. Worked with Parameterised and action reports.
. Implemented Drill down ,Drill through and Recursive operations.
. Worked with tabular,cross tab and chart report items.
· Writing various queries (duplications, tops, aggregate operations etc...) as part of reconciliation and business logics Validation.
· Maintained versioning in VSS and FTS with appropriate comments.
· Performance tuning of scripts when necessary.
. Experienced in writing queries by using Sql commands,keywords,
functions ,Sub Queries ,Set Operations and Joins.
· Good knowledge on DWH and BI fundamentals.