SUMMARY:

• 10+ years of professional experience as Business Intelligence Developer and Data Analyst.
• Extensive experience in Installation, Configuration and Development of SQL Server 2008, 2012, 2014.
• High proficiency over MSBI Technologies well versed with SSIS, SSRS and Power BI.
• Experience in Development and Deployment of SSIS packages from Oracle, SQL Server 2005, 2008, 2012, AS400, Azure SQL Databases and XML’s.
• Extensive knowledge and experience in developing scripts using T - SQL, Oracle, AS400 for querying against databases
• Expertise in implementing business logic using stored procedures, using temporary tables, views, indexes, triggers when required and complex queries including correlated queries and queries with complex joins and aggregate functions.
• Proficient at Performance Tuning with a solid knowledge of Optimizing Code
• Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modeling and reporting tools.
• Expertise in generating reports using SQL Server Reporting Services, Power BI
• Designing and Deployment of Reports for the End-User requests using SSRS.
• Build regular reports using SSRS SQL Server Reporting Services with help of various tools such as Group by, Drill-down, Drill through, Sub Reports, Cascading, Summarized, Matrix etc.
• Experience in configuration and maintain Report Manager and Report server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Experience in Ad-hoc reports, data driven subscription reports by using Report Builder.
• Experience in developing Dashboard Report, Parameterized Reports, Linked reports, Sub reports by Region, Year, Quarter, Month and Week.
• Developed OLTP system (s) and involved in creating facts, dimensions and Star Schema representation for the data mart.
• Experienced in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools like SSIS and XML.
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Developed the reuse components in SSIS like SSIS Framework and Transaction control for the project
• Experience in Performance Tuning in SSIS packages
• Proficient in application development with .Net technologies like .Net Framework 3.5, C#, ASP.Net, ADO.Net, AJAX, Web Services, SOAP requests, IIS Web Server and conceptual knowledge on SharePoint 2010.
• Experience in creating various reports on Power BI and dashboards using SQL Server, Excel etc to make it more attractive.
• Created DAX Measures in power BI to achieve business requirements.
• Experienced in SDLC life cycle for Design, Development and Staging phases of the projects.
• Experience in analyzing the requirements and mapping them as per the business use.
• Experience in analyzing the root cause of data issues and fixing them.
• Very good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player.
• Provide 24/7 database maintenance and support.
• Have knowledge on insurance domain.
• Capable of handling the complete module alone throughout the requirement phase, development phase, testing phase and till the project moves to production.
• Involved in Designing ETL Architecture.
• Involved in all aspects of project/product development including Analysis, Design, Development, Training, Testing and Implementation.
• Involved in providing Technical solution to different Verticals within the organization.
• Ability to work under extreme pressure without compromising on quality and timely delivery, attention to details, and passion for work.

TECHNICAL SKILLS:

Development Skills: BI Stack

Cloud Technologies: T-SQL, PL/SQL, MSBI(SSIS/SSRS), Power BI, DAX Measures, .NET MSBI (SSIS, SSRS), Power BI, DAX measures Microsoft Azure

Languages: C#.NET

Web Technologies: ASP. Net, HTML, Ajax, Web Services, Restful Web Services

Databases Development Tools: Oracle 11g, SQL Server ( 2005, 2008, 2012,2014): BIDS, SSDT, SSMS, Visual Studio, Oracle SQL Developer

Source Controls: VSS, TFS

Other Tools: RPA

SOAPUI: UI Path

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

Technical Lead

Responsibilities:

• Developed Power BI models used for Reports.
• Designed and documented the entire Architecture of Power bi project.
• Used several DAX functions in Power BI and Power Pivot.
• Used various sources to pull data into Power BI such as SQL Server, Flat File, Excel, SQL Azure etc.
• Installed and configured Enterprise gateway in Power BI service.
• Created Workspace and content packs for business users to view the developed reports.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
• Weekly presentation to the business users about the reports and their changes as required.
• Worked on all types of transformations that are available in Power bi query editor
• Created stored procedures and SQL queries to pull data into power pivot model.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined and Functions as required.
• Created DAX Measures in power BI to achieve business requirements.
• Developed Power BI dashboards for data analysis
• Created various SSIS packages for the enhancements of the project to extract the data from the data sources like SQL SERVER and XML’s to the data warehouse.
• Used SCD transformation to implement incremental loads.
• Monitored runtime events for better troubleshooting, debugging of packages with Event Handlers and custom loggings.
• Implemented Transactions in SSIS packages
• Used SSIS optimization techniques to minimize the package execution time.
• Configured packages with parameters and deployed packages to production servers utilizing package / project deployment model.
• Involved in Designing ETL Architecture as per the requirements.
• Daily Monitoring the Production Environment and analyzed the issues as per the daily load and fixing them.
• Managed the Module by handling any change requirements and as well as enhancements to the project.
• Helping team members to resolve any technical issue, Troubleshooting, Issue identification and management.
• Interacting with Client and providing regular status update
• A nalyz e Business/Functional requirements and provide a Design solution for software components to meet Business/Functional requirements.
• Created few POC’s to automate the things using UI Path.

Tools and Environment: SQL Server 2012/2014, T-SQL, SSMS, SQL Profiler, MS Word, MS Excel, SSIS, SSRS, C#, XML, VSS, POWER BI, UI Path

Confidential, New Jersey, NJ

MSBI / SQL Server Senior Developer

Responsibilities:

• Created various SSIS packages to extract the data from the data sources like SQL SERVER and XML’s to the data warehouse.
• Used SCD transformation to implement incremental loads.
• Monitored runtime events for better troubleshooting, debugging of packages with Event Handlers and custom loggings.
• Implemented Transactions in SSIS packages
• Used SSIS optimization techniques to minimize the package execution time.
• Configured packages with parameters and deployed packages to production servers utilizing package / project deployment model.
• Took Ownership to deploy and maintain SSIS package versioning on daily basis till the code moved to production.
• Used .Net coding to accept data from web services and SOAP requests.
• Created ETL Generic Framework in order to implement Error Handling and Rejection etc.
• Involved in architecture at the ETL level in order to reprocess the data for the Dimensions and Facts.
• Managing the ETL Team and Ensuring Complete Development.
• Involved in Designing ETL Architecture as per the requirements.
• Daily Monitoring the PreProd Environment and analyzed the issues as per the daily load and fixing them.
• Managed the Module by handling any change requirements to the project.
• Reconciled the data with the Old data model and various source systems and make changes to the present environment to match the data.
• Created various SSIS jobs using SQL Agent and monitor them for any issues.
• Created stored procedures using dynamic sql to extract data from XML to staging environment.
• Designed and developed SQL structures utilizing temporary tables, table variables, CTEs, loops, and dynamic SQL to implement business logics.
• Enabled package executions from the latest point of failure (for debugging) with checkpoints.
• Build regular reports using SSRS SQL Server Reporting Services with help of various tools such as Group by, Drill-down, Drill through, Sub Reports, Cascading, Summarized, Matrix etc.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS
• Created few reports with Power BI and SSRS by extracting data from SQL SERVER tables, Excel etc.
• Worked on Power BI and prepared various Reports, dashboards using SQL Server, Excel etc to make it more attractive.

Tools and Environment: SQL Server 2012, T-SQL, SSMS, MS Excel, SSIS, SSRS, C#, XML, VSS, POWER BI

Confidential, New Jersey, NJ

MSBI / SQL Server Senior Developer

Responsibilities:

• Handled the complete module alone throughout the requirement phase, development phase, testing phase and till the project moves to production.
• Direct interaction with client.
• Collected the requirements by interacting with the business users.
• Created various SSIS packages with heterogeneous sources like XML, AS400, Oracle and SQL.
• Created the SSIS package which accepts xml from the web service.
• Created the SSIS packages with get data from various sources, creates xml data and send to web services.
• Also Created the SSIS packages to get the data from SQL Azure
• Created web services using .net which accepts xml and call the SSIS package which is deployed in the SSMS.
• Deployed various SSIS packages in the SSIS catalog.
• Maintained package configurations using Environment variables with the new features of SSMS 2012 called environments.
• Created and maintained Sql login groups to run the SQL jobs.
• Created and scheduled the jobs for the deployed SSIS packages.
• Create SSAS Tabular Model and SSAS Cube Model and support the existing database components
• Create SSAS Tabular model and SSAS Cube using data from database and tables created by myself

Tools and Environment: SQL Server 2012, T-SQL, Oracle 10g, SQL Azure, AS400, SSMS, MS Excel, SSIS,SSAS,.Net 4.0, C#, XML, VSS, IIS

Confidential

Senior Software Developer

Responsibilities:

• Handled the complete module alone throughout the requirement phase, development phase, and testing phase and till the project moves to production.
• Involved in gathering the report specifications by interacting with the business users.
• Identified the database tables and stored procedures for defining the queries for the reports.
• Mentoring the fresher’s.
• Created and deployed various kinds of SSRS Reports.
• Created a multitude of reports with SSRS such as drill down, drill through, parameterized, cascading parameterized, and ad-hoc reports
• Rendered reports to multiple formats per the business requirements utilizing standard and data driven subscriptions in native and SharePoint integrated mode as per business requirements.
• Implemented TFS for BI application and SQL code source control.
• Implemented role-based security for reports with report manager.
• Created various kind of stored procedures, queries used in the SSRS reports using oracle11g
• Creating Custom Data processing Extension using Oracle Data Provider to connect to SSRS Reports using .NET.
• Successfully deployed two SSRS modules (ICS, ISMD and MRT) to production.
• Direct interaction with client.
• Ability to work in the cross vendor environment.

Tools and Environment: Oracle 11g, SQL Server 2008, SSRS, C#.NET, TFS

Confidential

Software Developer

Responsibilities:

• Created SSIS packages to extract data from various heterogeneous sources like sql server, Text files, Excel Spread Sheets, XML, Oracle, clean and load data to various heterogeneous sources.
• Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated.
• Supported Presales POC by creating packages which transfers data from multiple Excel Spreadsheets to SQL Server DB
• Created various SSIS packages for verticals according to the business requirements.
• Supported the HMS team in the creation of packages & provided accurate solution as per their requirements and also provided guidance to their team members.
• Created the Demo on SSIS for the Amex vertical, which extracts the data from flat file and inserts into the SQL server of 10 records at a time with validations, error handling, maintaining the corrupt records, rolling back the transaction if the package fails and also logging the errors.
• Created a POC which connects to various databases like Informix, DB2, Sybase, Oracle, and MySQL and performs ETL operations.
• Created SSRS reports and deployed on windows Azure.

Tools and Environment: Oracle 11g, SQL Server 2008, SSIS, SSRS, C#.NET, Asp.Net, Ado.Net, Ajax, Web S ervices, VSS

Confidential

Trainee

Responsibilities:

• Created and deployed SQL Server 2008 SSIS by using different data Transformations like Derived Column, Lookup, Conditional Split, Pivot, Union and Execute SQL Task to load data into Database.
• Implemented logging, checkpoints and package configuration in SSIS 2008.
• Created and deployed reports using SQL Server 2008 Reporting Services.
• Created Stored Procedures in SQL Server 2008.
• Used drill down functionality such as Drill Through and Drill Down to show the data at different Hierarchical levels.

Tools and Environment: SQL Server 2008, SSIS, SSRS

Confidential

Trainee

Responsibilities:

• Used N-tier architecture for presentation layer, the Business and Data Access Layers and were coded using C#.
• Developed application logic using C#.
• Written stored procedures using SQL in SQL SERVER 2005.
• Worked intensely on the User Interface.
• Developed Web Forms using C# and ASP.NET.
• Used AJAX in some webforms.

Tools and Environment: C#.Net, Asp.Net, Ado.Net, Sql Server 2005