SUMMARY

• Around 8 years of experience as Business Intelligence Developer and Lead.
• Strong Communication & Management skills with Excellent Role - playing capabilities.
• Highly experienced with the Full Life Cycle and Methodology for implementing OLAP (Online Analytical Processing), data warehouses (star and snow flake schemas) and business intelligence reporting systems.
• Expert in ETL (SSIS, Data Factory) perform data transfer from different server locations and heterogeneous sources like Oracle, SharePoint Online, Azure Storages, Excel, CSV, XML and Text Format Data.
• Expert in presenting multi-platform data visualization like pie/bar/graph charts.
• Efficient in Database / Data Marts design, Stored Procedures, Triggers, Indexes, Data Cleansing / Data Mining.
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler.
• Highly experienced in using SSIS Import / Export Wizard, SSIS designer and other package execution utilities for performing the ETL operations.
• Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models, E-R Diagrams.
• Extensive experience in Installation, Configuration and Deployment of SSRS.
• Involved in migration of SSIS Package and troubleshoot migration issues.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Excellent T-SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers.
• Experienced in using multiple transformations provided by SSIS such as script component, Lookup, Data Conversion, Conditional Split, Bulk Insert, Merge, Merge Join, Union All, and Slowly Changing Dimension .
• Experience with Microsoft Azure products including blob storage, data factory,SQL Server Data Warehouse
• Experience leading teams in an Agile environment.
• Experience using TFS, Visual Source Safe or similar source control
• Experience in working in DEVOPS model.
• Experience in building solutions using Microsoft O365 Apps such as PowerApps, PowerBI, Microsoft Flow, SharePoint Online.

TECHNICAL SKILLS

Programming Languages: VB, C#, Javascript, SQL

Tools: Visual Studio 2012/2013/2012 , SQL Server Data Tools, SQL Server Management Studio, Azure,BIDS, InfoPath, MS Access, SharePoint, PowerBI

Version control tools: Team Foundation Server, Visual Source Safe

Operating Systems: Microsoft Windows

Software development: Agile, Waterfall

PROFESSIONAL EXPERIENCE

Confidential

BI Developer/Azure Engineer

Responsibilities:

• Understand the business problem/ business question.
• Data extraction from various sources.
• Data Cleaning and preparation.
• Creating data/Tables in required format for analysis.
• Have basic data pull knowledge to pull the data from SQL.
• Involved in design and development of SSIS Packages
• From the analysis, drawing the conclusions and insights
• Develop excel based interface for the models/reports
• Create and maintain all process documents to ensure smooth delivery.
• Migration of Legacy packages to SSIS 2012/2016.
• Migration of On premises applications to cloud (Azure).
• Develop both internal and external reports using industry standard tools (SSRS,Excel, PowerBI).
• Designing solutions using Microsoft tools.
• Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and upgrading of SQL Servers.
• Fine-tuned Stored Procedures and SQL Queries and User Defined Functions.
• Design solutions to extract data from cloud services such as Azure PAAS, Azure Blob storages, SharePoint online.
• Design Approval workflows, File Movement using Microsoft FLOW.
• Troubleshoot and fix SQL Agent Job failures.
• Created complex reports such as Matrix, Charts, Cascading Parameters, Sub reports and Dashboards using SSRS 2008R2.
• Build Data Controls and User Controls using C# and are used in UI design.
• Build audit reports for different applications using SSRS.
• Monitoring application health through Azure Application Insights and building PowerBI reports from the data.
• Participated in the Agile planning for Team Foundation Server to make sure that our team sprints satisfied backlogs.
• Used Visualizations like bar chart, column chart,maps,gauge in PowerBI reports and used it in reporting Microsoft sales data.
• Worked on premises gateways to connect to cloud data.
• Create apps in Infopath, PowerApps to load files to SharePoint Online.

Environment: T-SQL, SSIS, SSRS, SQL Server and Microsoft Visual Studio, XML, Windows 10, Office 365, PowerBI, Azure, Infopath.

Confidential

BI developer/UI Develop

Responsibilities:

• Understanding Business requirements and requirement gathering
• Preparing the logical diagrams, data flow diagrams and the sequence diagrams for any new interface
• Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures.
• Created new database logical and physical design to fit new business requirement and implemented new design into SQL Server 2008 R2.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Created Sub-Reports, Drilldown-Reports, Summary reports, and Matrix reports in SSRS.
• Wrote complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
• Writing database scripts and SQL.
• Developed SSIS packages with various tasks like - FTP, file system, for-each-loop, execute package, data flow task, execute SQL task, custom script task, analysis services task.
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS
• Identifying the unit test cases and preparing the unit test case document
• Implemented Table Partitioning, Advanced Error handling, Common Table Expression (CTE).
• Build applications using .net technologies.
• Pull Mortgage data using SSIS for Oracle data warehouse.
• Created CSV and excel files for data analyst for the particular records they want.
• Responsible for making sure reports are scheduled and delivered in a timely manner
• Model fact and dimensions tables.
• Deployed reports to Report Manager and Troubleshooting for any error occur in execution.
• Implemented Table Partitioning, Advanced Error handling, Common Table Expression (CTE).

Environment: T-SQL, SSIS, SSRS, SQL Server and Microsoft Visual Studio, Windows XP, MS Access, Crystal reports, VB 6.0, VB.net