SUMMARY:

• SQL Server Developer with over 7 years’ experience in SSIS, SSRS, SSAS, MS SQL Server 2008 R2/2012/2014, Power BI, SQL Azure, SAP BI, Oracle PL/SQL, Informatica, Unix from requirements gathering to its implementation using Agile methodologies be it on - premises, Cloud only or hybrid. In-depth knowledge and understanding of best practices with substantial ability to analyze business processes and define optimal procedures. Possesses strong development and analytical skills.
• Used Microsoft Power BI to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database. Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Fair Knowledge on Azure SQL (DB and DWH) and Azure Storage.
• Strong communication and interpersonal skills. Proficient at grasping new concepts quickly and utilizing them in a productive manner.
• Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS. Experience in working with Report Builder for creating reports in SSRS. Expertise in creating Report Models for building Ad hoc reports using SSRS. Experience in Report Processing, Subscription, Delivery and Configurations.
• Hands on Experience delivering full application implementations focused in the following phases:
• Business Requirements Definition and Mapping
• Use Case/Gap analysis
• Prototype
• Design and Development
• Solution Deployment
• Production Support and Maintenance
• Collaboratively worked with the team from requirements gathering to project development, deployment and production support on various projects.
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other SQL code and SQL joins for applications.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Used SQL Profiler for Performance monitor to resolve Dead Locks and Long running queries by checking appropriate changes to Transaction Isolation levels
• Database Performance of Index tuning with using Database Engine Tuning Advisor to resolve Performance issues, tuned a process and brought down the process time from 14 hours to less than 30 minutes.
• Worked on escalated tasks related to interconnectivity issues and complex cloud-based identity management and user authentication, service interruptions with Virtual Machines (their host nodes) and associated virtual storage (Blobs, Tables, Queues)
• Integrated custom visuals based on business requirements using Power BI Desktop
• Provided continued development and maintenance of bug fixes for the existing and new Power BI Reports
• Provide consulting and cloud architecture for premier customers and internal projects running on MS Azure platform for high-availability of services, low operational costs
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance.
• Configured and Monitored Database Mirroring for Application Development environment
• Exclusively worked for SPIFF developments every month and supported all issues related to commissions payout and check releases for dealers.
• Planned, directed and managed designated project tasks; ensured that objectives were accomplished in accordance with outlined priorities.
• Analyzed results of operations to discover more efficient ways to utilize resources; coordinated with successful simultaneous development of projects.
• Reviewed project status reports during each operational phase; prepared weekly project status reports for the management.
• Provide team direction and effectively distribute tasks and track the progress using Team foundation server.

EXPERTISE:

• SQL BI
• SSMS
• SSIS, SSAS, SSRS
• Collaborate
• Monitor
• SQL Azure, BLOB Storage
• Master Planning
• Power BI
• SAP BI
• Oracle PL/SQL
• Informatica
• Unix

• Project Development
• Team Lead
• Business Requirements
• Solution Design
• GAP Analysis
• SQL Query
• Business Process Analysis

EXPERIENCE:

MSBI/Power BI Developer

Confidential

Responsibilities:

• Experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services(SSIS), Analysis Services(SSAS), and Reporting Services(SSRS) Implemented advanced data cleansing in SSIS using Derived Column, Fuzzy Lookup, Fuzzy Grouping and worked with various data transformations like Merge, Sort, Conditional Split and Multicast
• Experience in Performance Tuning of SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in providing Logging, Error handling by using Event Handler and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Built metric reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards with Power BI service
• Generated custom and parameterized reports using SSRS. Created various visualizations like waterfall, funnel, matrix visualization, scatter plots, combo charts, gauges, cards and KPI. Knowledge of publishing the Power BI Desktop models to Power BI Service to create highly informative dashboards, collaborate using workspaces, apps, and to get quick insights about datasets. Experience in publishing Power BI Desktop reports created in Report view to the Power BI service.
• Used Power Query to acquire data and Power BI desktop for designing rich visuals.
• Created basic reports using Confidential files as source to fetch the data in Power BI. Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

SQL Server Developer

Confidential

Responsibilities:

• Implementation and delivery of BI platform solutions to develop and deploy ETL, analytical, reporting and scorecard\dash boarding on SQL Server 2012 using SSAS, SSIS, SSRS.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes. Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and Up gradation of System Configuration. Involved in Installation, Configuration and Deployment of Reports using SSRS with Scale-Out topology.
• Involved in SQL Server Configuration, Administration, Implementation and Trouble-shooting for Business work. Migrated existing self-service reports and adhoc reports to Power BI.
• Developed custom calculated measures using DAX in Power BI to satisfy business requirements.
• Controlled, coordinated installations (Security Patches, Service packs) and evaluated the performance before deployment.
• Performed Database Refresh tasks from production to Development and Staging Servers Documenting Business requirements and requirements tracking.
• Document Business Scenarios and testing Objectives.
• Coordinate with business teams to prepare SIT and UAT test scenarios
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.

Oracle PL/SQL Developer

Confidential

Responsibilities:

• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Designed Informatica mappings by translating the business requirements.
• Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse.
• Widely used Informatica client tools -- Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow Manager. Used Repository Manager for deploying the developed objects
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems. Used workflow manager for session management, database connection management and scheduling of jobs.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Installed, and Documented the Informatica Power Center setup on multiple environments.
• Worked extensively on replicating the Metro-PCS Commissions system which was implemented in SQL BI into Oracle PL/SQL and Informatica by utilizing both of my skillsets.
• Worked on various process improvements and lights on projects besides several regular developmental projects.
• Worked on Disaster Recovery Plan for a complicated Application.

SAP BI Consultant

Confidential

Responsibilities:

• Analysis of the specifications provided by the client Involved in design and development of Info Objects, ODS Objects.
• Scheduled and automated data loads from R/3 to BW and optimized the load performance.
• Worked extensively on Dashboard reporting using Web Application Designer and developed Dashboard reports. Involved in development Extraction process from DB source system.
• Created and maintained queries in BEx Analyzer and BEx Web Application Designer for analysis and web reporting respectively published in Enterprise Portal.
• Experienced in full lifecycle of projects, including business process mappingsoftware implementation, Project management, training and configuration.
• Demonstrated success in Project Planning, Project delivery, client interfacing.
• Has Involved in transports of Data targets, Queries and Web templates.
• Involved in Developer Integration Testing / System Integration Testing / User Acceptance Testing / Go live Support / Post Go live Support.
• Worked with project team to ensure smooth and efficient implementation and integration between technical and functional system requirements
• Documented business requirements and translated them into functional design, specifications and detailed test plans.
• Worked to ensure smooth and efficient implementation and integration between Technical and Functional system requirements.
• Interfaced with customer business and MIS/IT teams during all project implementation phases.
• Assessed “As-is” processes and, using strong knowledge of best practices, guided client in establishing “To-be” processes.
• Planned and designed software based on business requirements.
• Analyzed client’s current forecasting techniques and created data mapping for future business processes.
• Wrote functional specification documents and assisted technical team in creating technical specification documents.
• Prepared functional test plans and executed QA testing prior to client delivery.
• Provided advice to customers regarding industry best practices and process