Now you can Instantly Chat with Bhanu!
Skills
Portfolio Projects
Description
Project: Latam Company : ND Technology
Develop Tabular and Power BI reporting solutions for Microsoft MS Sales LATAM division.
- Import data from Sources, create underlying data structures in SQL Server
- Dimensional modelling using star schema using SSAS Tabular , create measures using DAX
- Create power BI reporting using the Tabular Cube as source
Description
This application is Banking application for Customer. This is a very critical application as users can contact at any time. More than 400 users these for different applications. They pull daily reports reports. End users Pulls the reports from Microstategy. Our scope of work is to maintain the databases from backend as L2/L3 work.
Responsibilities
- Good in SQL Programming.
- Designing and creation of the Database.
- Troubleshooting.
- Automation tasks like Batch file program, scheduling jobs etc.
- Developing SSIS Packages for ETL Process.
- It’s my responsibility to take complete ownership of all Class-3 applications.
- There are 13 medium applications and 8 team members in my team.
- Creating a SQL Jobs, triggers and stored procedures.
- Maintained current and historical version files(SQL Scripts, SSIS Packages , Reports and Project related files) using the Tortoise SVN
- Working on Change Requests according to the Client’s requirements.
- Creating Reports Using Microstategy.
- Knowledge about Control-M, Fusions and Incidents, TWS Maestro Tool.
Environment: Windows XP/7, SSIS, MS SQL Server 2005/2008 R2, Access, Control-M, Fusion and Incident tools.
Show More Show LessDescription
PROJECT: Pulse Company : DELL INTERNATIONAL SERVICES
PULSE is a finance project which includes Dell’s Scrap, DMD, Intake and Purchase data. The pulse application refreshes weekly basis once the Purchase and Scrap data is ready. Our role is to check the input data and needs to refresh the PULSE DB and Cube.
Responsibilities
- Experienced in preparing estimate by providing the Detailed Level design
- Responsible for creating the standard custom Logging and Error Handling for ETL’s
- Preparing Unit Testing documents for the above all ETL Solutions.
- Experienced in preparing SQL Scripts (Stored Procedures, Views, CTE and Tables) to load data from Source Systems to staging, target and to fact tables.
- Involved in improving the Performance of the SQL Queries
- DevelopedETL packages that handles Master & Incremental Data Loads
- Created Agent jobs and scheduling them to extract data from Source Systems.
- Developed Unit Test cases to ensure successful execution of the data loading processes.
- Developed SSRS 2008 Reports which uses the stored procedure that extracts data from Fact Tables
- Have written custom code for data validation in the reports.
- Responsible for Creating and maintaining various user groups and their security using Sql Server or Window Server
- Given Online Support to Sys, UAT testing and also to Production Environment
- Documents are maintained at SharePoint and the code in Team Foundation Server.
- Developing Stored Procedures, complex SQL queries required for reporting module.
- Developing SSIS packages to carry out the data processing and transferring to downstream systems.
- Consulting with users to analyze and understand functions to be automated.
- Developing, testing, maintenance and installation of applications
- It’s my responsibility to take complete ownership of all tasks for America’s team.
- Creating a SQL Jobs, triggers and stored procedures.
- Working with Profilers and Execution plans for improving performance of stored procedures.
- Worked on Control-M, Fusions and Incidents tools.
- Manage resources and weekly resources to ensure SLA’s are meet and provide a monthly accounting of SLA performance.
- Raising Incidents to Teradata based on the priority for issues.
- Working with Teradata/Oracle tools for getting work around and fix the issues through Incidents.
Environment: Windows XP/7, SSIS, SSRS, SSAS, MS SQL Server 2008 R2 / 2008, VBA Macros, Adv. Excel , TFS, SharePoint.
Show More Show LessDescription
PROJECT: BUSOPS (EMEA Region) and Bratislava Applications Company: DELL
This application is Sales Operations application for Customer Care. This is a very critical application as users can contact at any time. More than 100 users in this application. All users are BUSINESS ANALYSTS. They pull daily reports/weekly reports and also Quarterly report based on Dell’s transactions. This application includes HR, Laptop Sales and Recovery information. End users Pulls the reports from SSRS. Our scope of work is to maintain the databases from backend as L2/L3 work.
Responsibilities
- Good in SQL Programming.
- Designing and creation of the Database.
- Troubleshooting.
- Automation tasks like Batch file program, scheduling jobs etc.
- Developing SSIS Packages for ETL Process.
- I am Leading DB team since from Jan-2013 along with Sr. SQL Developer.
- I am good team player and able to handle the issues in any situations.
- It’s my responsibility to take complete ownership of all Class-3 applications.
- There are 13 medium applications and 8 team members in my team.
- Creating a SQL Jobs, triggers and stored procedures.
- Working on Change Requests according to the Client’s requirements.
- Working with Profilers and Execution plans for improving performance of stored procedures.
- Creating Reports Using SQL Server Analysis and Reporting Services (SSAS, SSRS) .
- There is no L3 team for this, we have to work all kind of work based on users demand.
- Work knowledge about Cubes and Excel Pivots.
- Migration of application from MS-SQL 2000 environment to MS-SQL 2005 environment.
- Able to work in Advance Excel tools.
- Knowledge about Control-M, Fusions and Incidents.
- Manage resources and weekly resources to ensure SLA’s are meet and provide a monthly accounting of SLA performance.
- Raising Incidents to Teradata based on the priority for issues.
- Working with Teradata for getting work around and fix the issues through Incidents.
Environment: Windows XP/7, SSIS, SSRS, MS SQL Server 2005/2008 R2, Access, Control-M, Fusion and Incident tools.
Show More Show Less