Total Years of Experience: 8 Years, 3 Months
April 2016
To Present
Microsoft Business intelligence (MSBI)
at Equifax
Location :
India - Bengaluru
Responsibilities:
* Developed and optimized database structures, stored procedures, views, and user-defined functions for the Application.
* Involved application tuning and tested the application for deployment, Function and behavior.
* Created some T-SQL queries, Stored Procedures.
* Design and create SQL tables, indexes.
* Responsible for Query optimization and Performance tuning. Performing query plans and making sure each and every query is using appropriate useful indexes.
* Responsible for gathering/refining requirements from the client for developing reports.
* Created SQL Server Reports using SSRS.
* Developed Query for generating drill down and drill through reports in SSRS.
* Uploaded reports on to the report manager and organized them in folders.
* Generated and formatted Reports using Global Variables, Expressions and Functions for the SSRS reports. Designed and implemented stylish report layouts.
* Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters, Debugging Parameter Issues, Matrix Reports and Charts.
* Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
* Created SSIS process design architecting the flow of data from various sources to target.
* Configured SSIS packages using Package configuration wizard to allow package run on different environments.
* Developed and optimized database structures, stored procedures, views, and user-defined functions for the Application.
* Involved application tuning and tested the application for deployment, Function and behavior.
* Created some T-SQL queries, Stored Procedures.
* Design and create SQL tables, indexes.
* Responsible for Query optimization and Performance tuning. Performing query plans and making sure each and every query is using appropriate useful indexes.
* Responsible for gathering/refining requirements from the client for developing reports.
* Created SQL Server Reports using SSRS.
* Developed Query for generating drill down and drill through reports in SSRS.
* Uploaded reports on to the report manager and organized them in folders.
* Generated and formatted Reports using Global Variables, Expressions and Functions for the SSRS reports. Designed and implemented stylish report layouts.
* Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters, Debugging Parameter Issues, Matrix Reports and Charts.
* Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
* Created SSIS process design architecting the flow of data from various sources to target.
* Configured SSIS packages using Package configuration wizard to allow package run on different environments.
February 2014
To June 2014
Trainee
at Moda innovation
Location :
India - Bengaluru
As a Organisation, our goal is to contribute to society through broad-ranging activities in the areas of Software development, Training and Technical Projects.
Modainnovations has successfully performed projects under various platforms and has delivered high quality competitively priced products and services to customers all over India.
Modainnovations has successfully performed projects under various platforms and has delivered high quality competitively priced products and services to customers all over India.
Modainnovations has successfully performed projects under various platforms and has delivered high quality competitively priced products and services to customers all over India.
Modainnovations has successfully performed projects under various platforms and has delivered high quality competitively priced products and services to customers all over India.
Share on Facebook
Share on Twitter
Share Via Email