About Me

Having 5+ Years of Professional experience in IT industry, Involved in MSBI projects with extensive usage of TSQL, MSSQL, ETL & Reporting tools like SQL Server Integration Services (SSIS), SQL Server Repor...ETL & Reporting tools like SQL Server Integration Services (SSIS), SQL Server Report Service (SSRS).

• Having Good experience in writing SQL queries, Stored Procedures, Triggers, Views, Constraints, Functions, Indexes, Schedulers and Performance Tuning.
• Having much experience in DB activities like Data Manipulation, Data Querying, ;.’
• Data Transaction, Data Definition, Data Pivoting, Data Validations, Data control and Consistency.
• Worked on Schema, Tables, Cursors, Deadlocks, Common Table Expression, sequences and SQL Server Profiler.
• Proven proficiency in Granting resources, privileges, T-SQL queries, Ranking functions, Derived tables and Table Partitions.
• Hands on Experience in dynamic SQL, Exception Handling, Maintaining the Log and Audit information in the SQL tables.
• Hands of experience in creation of work flows with Tasks, SQL Job Agent and various Transformations and Scheduling jobs using TSQL and the Reports Weekly and Monthly basis as per the Client Requirements.
• Having much experience in DB activities like Data Manipulation, Data Querying, Data Transaction, Data Definition, Data Pivoting, Data Validations, Data control and Consistency using TSQL.
• Worked extensively on Data Extraction, Transforming and Loading the data by using SSIS.
• Proven proficiency in Data Transformations to load data into Data Warehouse, Data Analysis using MDX Queries and Maintaining the Log and Audit information in the SQL tables.
• Have worked in multiple projects as BI Developer in Designing ETL Packages and Reports in development and implementation stages of the Projects.
• Hands of  experience  in  creation  of  work  flows  with  Tasks, Containers and various Transformations and Scheduling jobs using TSQL and  the Reports Weekly and Monthly basis as per the Client Requirements.
• Proficiency in using Visual studio Data Tools (SSIS, SSRS, SSAS), SQL Server 2012 and SQL Server 2014.
• work ethics and interpersonal skills that help in communicating with the fellow team members, Managers, Developers and Users. Ability to handle multiple tasks and work independently as well as in a team.
• Having motivated, hardworking, able to meet tight deadlines, thorough in project completion and possess excellent communication and analytical skills.
• Good interpersonal and communication skills, commitment, result oriented, and zeal to learn new technologies and   undertake challenging tasks.
• Expertise in Financial Domain areas that include Mutual Funds and Insurance.
• Expensive experience in meeting demanding deadlines and delivering critical solutions on various levels of Client expectation.
• Excellent Technical and Analytical skills with clear understanding of design goals of ER Modelling for OLTP and dimension modelling for OLAP.
• Advanced knowledge on Relation database, Logical and Physical Data Modelling Using Normalization Techniques.