SQL BI DEVELOPER/LEAD
Resume:
PRAVEEN KUMAR
**********.**@*****.***
Summary
7.8 years of overall IT experience in Analysis, Design, Development, Migration and support in Microsoft SQL Server and MSBI Technologies.
2.5 years of experience in Analysis, Design, Development, Testing and Implementation of Business Intelligence applications using QlikView/ QlikSense application developer
2 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
Expertise in Client-Server application development using Oracle 11g/10g
Worked installation & configuration, environment, system analysis, design, deployment, testing of projects
Experience in optimizing QlikView and QlikSense applications to improve the performance.
Developed QlikView and QlikSense objects like Multi Boxes, Straight tables, Pivot tables, Containers, Line charts, Bar charts, Combo charts, Scatter charts, Line objects, Pie charts, Buttons.
Proficient in troubleshooting and fixing the QlikView and QlikSense dashboard issues.
Created incremental load process to load the data into QlikView applications from different source systems.
Involved in Performance Tuning and Deployment of QlikView and QlikSense applications.
Experience in developing and maintaining large scale Data Warehouse applications using Microsoft Technologies like SQL Server 2005/2008/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
Good client facing skills and onshore experience (United States).
Excellent feedback and recognition received from clients and stakeholders.
Great Team player and Lead.
Technical Expertise
Database: Microsoft SQL Server 2005/2008/2012, Oracle 7.x/8i/9i/10g/11g (SQL, PL/SQL, Stored Procedures, Triggers),
ETL Tools: SQL Server Integration Services (SSIS)
Reporting and Visualization Tools:
Advanced knowledge and Expertise: SQL Server Reporting Services (SSRS), Qlik Sense
Trained and have basic understanding: Tableau and Power BI Desktop
Analysis Tools: SQL Server Integration Services (SSAS with considerable knowledge on MDX)
Programming Languages: T-SQL, SSIS Scripting(c#), MDX, PL SQL
Source Control: TFS, SVN
Tools: SQL Server Management Studio (2005-2012), Microsoft Visual Studio (2005-2014)
Monitoring /Scheduling Tools: Control-M, SQL Server Agent
Achievements: Received Award of Excellence for client service
Project Experience
Project #1:
Project Name
SPEAR – Strategic risk reporting platform
Client
Credit Suisse
Software
Qlik Sense, SQL Server 2008, SSIS, SSRS, SSAS, C#.Net
Role
Lead BI Developer.
Duration
November 2017 To Till date
Description:
SPEAR is Strategic Performance Exposure Attribution Risk platform for Alternative Investments. Risk Management SPEAR is a web-based application that supports analysis of Performance, Exposure and Risk of Funds. For the analysis of Risks, application is using Web services of third-party tools like Risk Metrics, Barra One. Application generates different reports which facilitate managers to analyze the various portfolios and Funds on different metrics. Loading new data of new business units using SSIS packages and implementing logic for the reports in SSRS.
Responsibilities:
Lead the offshore team in Planning, brainstorming sessions and various discussions with Business Analysts and counterparts.
Involved in requirements gathering, analysis, design and coding phase and coordinated with counterparts in fulfilling the client’s requirements.
Design & Develop SSIS Packages for importing the data from multiple sources into DB, based on business requirement.
Implemented SSIS package for data reconcile process to automate the validation of data from multiple sources.
Implemented automation of data archival and purging of staging data using table partitions.
Improved performance of SSIS packages using Tuning and Optimization techniques.
Design, Development & Administrating of SSRS Reports using SQL Server and MDX.
Design, Development & Administrating for SSAS cubes and implemented cube partitioning.
Migrated SSIS packages and SSRS reports from SQL server 2008 to 2014.
Involved in Creating, Modifying & Supporting SQL Server databases.
Creating and maintaining the database objects like tables, views & Procedures.
Involved in developing Custom Code using Microsoft Visual Studio.
Involved in designing, developing, testing, publishing, maintaining, and supporting QlikView & QlikSense applications.
Building QVDs, QVWs, QVFs using source systems
Involved in the requirement analysis and identifying sources and targets.
Created QlikView & QlikSense dashboards using different objects like List Boxes, Multi Boxes, Pie charts, Line charts, Funnel charts, Scatter charts, Bar charts, Combo charts, Straight tables, Pivot tables, Buttons, Containers.
Involved in performance tuning of QlikView & QlikSense apps for faster data reloads and efficient response times.
Involved in analyzing the data and defining Key Performance Indicators (KPI).
Assisted in installation and configuration of QlikView and QlikSense servers.
Involved in optimizing the existing data models and load scripts to improve the performance.
Simplifying complex expressions in the dashboards and improving front end.
Implemented section access to make the application available to the desired users/
Assisted users with demo sessions in using QlikView & QlikSense; converted QlikView applications to QlikSense.
Creating and maintaining of jobs scheduling using Control-M tool.
Involved in PROD support activities.
Project #2:
Project Name
SPEAR NY – Strategic risk reporting platform
Client
Credit Suisse
Software
SQL Server 2008, SSIS, SSRS, SSAS, C#.Net
Role
Lead BI Developer.
Duration
March 2014 To October 2017
Description:
SPEAR NY is Strategic Performance Exposure Attribution Risk platform for Alternative Investments. Risk Management SPEAR is a web-based application that supports analysis of Performance, Exposure and Risk of Funds. For the analysis of Risks, application is using Web services of Third party tools like Risk Metrics, Barra One. Application generates different reports which facilitate managers to analyze the various portfolios and Funds on different metrics. Loading new data of new business units using SSIS packages and implementing logic for the reports in SSRS.
Responsibilities:
Lead the team in Planning, Brainstorming sessions and various discussions with Business Analysts and counterparts.
Involved in requirements gathering, analysis, design and coding phase and coordinated with counterparts in fulfilling the client’s requirements.
Design & Develop SSIS Packages for importing the data from multiple sources into DB, based on business requirement.
Implemented SSIS package for data reconcile process to automate the validation of data from multiple sources.
Implemented automation of data archival and purging of staging data using table partitions.
Improved performance of SSIS packages using Tuning and Optimization techniques.
Design, Development & Administrating of SSRS Reports using SQL Server and MDX.
Design, Development & Administrating for SSAS cubes and implemented cube partitioning.
Migrated SSIS packages and SSRS reports from SQL server 2008 to 2014.
Involved in Creating, Modifying & Supporting SQL Server databases.
Creating and maintaining the database objects like tables, views & Procedures.
Involved in developing Custom Code using Microsoft Visual Studio.
Involved in the requirement analysis and identifying sources and targets.
Creating and maintaining of jobs scheduling using Control-M tool.
Involved in PROD support activities.
Project #3:
Project Name
PMS Reporting
Client
Credit Suisse
Software
Oracle Database, SSIS, SSRS, SSAS, C#.Net
Role
Sr. BI Developer.
Duration
July 2013 To Mar 2014
Description:
AUM is a full-fledged Finance platform which is built to orchestrate financial month-end closing processes. It includes managing the detailed sub-ledger, consolidating financial information from multiple sources, and delivering real time financial results to senior management. The system is equipped with a powerful Data Management system that gives Finance users the control over the entire data life cycle management. This enables self-service BI where users can add alternative reporting views without IT involvement and generate various ad-hoc reports like P&L statement, Balance Sheet and Assets under Management (AUM).
Responsibilities:
Analyzing the Existing System and Understanding the business requirements.
Design & Develop SSIS Packages for importing the data into DW and MDM based on User requirements.
Loading data from files from Shared Location using Custom Order.
Validating Data using Validation Framework.
Error Handling / Event Handling of SSIS Packages.
Design, Development of SSRS reports based on User requirements.
Creating and maintaining the database objects like tables, views & Procedures.
Involved in developing Custom Code using Microsoft Visual Studio.
Creating and maintaining of jobs scheduling using Control-M tool.
Involved in UAT and PROD support
Project #4:
Project Name
SPEAR NY – Strategic risk reporting platform
Client
Credit Suisse
Software
SQL Server 2008, SSIS, SSRS, SSAS, C#.Net
Role
Lead BI Developer.
Duration
December 2011 To February 2014
Description:
SPEAR NY is Strategic Performance Exposure Attribution Risk platform for Alternative Investments. Risk Management SPEAR is a web-based application that supports analysis of Performance, Exposure and Risk of Funds. For the analysis of Risks, application is using Web services of Third party tools like Risk Metrics, Barra One. Application generates different reports which facilitate managers to analyze the various portfolios and Funds on different metrics. Loading new data of new business units using SSIS packages and implementing logic for the reports in SSRS.
Responsibilities:
Lead the team in Planning, Brainstorming sessions and various discussions with Business Analysts and counterparts.
Involved in requirements gathering, analysis, design and coding phase and coordinated with counterparts in fulfilling the client’s requirements.
Design & Develop SSIS Packages for importing the data from multiple sources into DB, based on business requirement.
Implemented SSIS package for data reconcile process to automate the validation of data from multiple sources.
Implemented automation of data archival and purging of staging data using table partitions.
Improved performance of SSIS packages using Tuning and Optimization techniques.
Design, Development & Administrating of SSRS Reports using SQL Server and MDX.
Design, Development & Administrating for SSAS cubes and implemented cube partitioning.
Migrated SSIS packages and SSRS reports from SQL server 2008 to 2014.
Involved in Creating, Modifying & Supporting SQL Server databases.
Creating and maintaining the database objects like tables, views & Procedures.
Involved in developing Custom Code using Microsoft Visual Studio.
Involved in the requirement analysis and identifying sources and targets.
Creating and maintaining of jobs scheduling using Control-M tool.
Involved in PROD support activities.
Education:
Masters in Computer Applications (MCA) from VIT University, Andhra Pradesh in 2011.
Bachelor’s Degree in Computer Science from Nagarjuna University in 2008.
Contact this candidate