SUMMARY

• Highly professional and well - versed MS SQL BI Developer with over all 7+ years of experience in designing and developing with strong background in Data warehousing and ETL.
• Experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Analysis and Reporting Services.
• MS SQL Server Development experience in Insurance, Banking, and Finance Facilities Management domains with expertise in MS SQL Server R 2 / 2012/2014/2016.
• Experience in design and development of Power BI graphical and visualization reports as per business requirement documents (BRD).
• Microsoft certified in (70-461) “Querying Microsoft SQL Server 2012”, LOMA 281 and 291 certifications.
• Highly experienced in whole cycle of DTS/SQL server integration services Packages (SSIS) for performing Data transfers and ETL processes across different servers.
• Experience in creating jobs, Alerts, SQL Mail Agent, Database Mail, and schedule SSIS Packages based on Business or Application needs.
• Integrating and transforming data from different data sources like Oracle, DB2, Excel, and Flat Files to SQL Server 2008R2 using OLE DB connection providers by creating various SSIS packages.
• Proficient in designing Enterprise reports using SQL Server Reporting Services (SSRS) to generate drill down, drill through, parameterized, linked, matrix and charts reports in SSRS 2005/2008/2012/2014.
• Used 2012, 2014, 2016 version of SSAS to develop tabular models and experience in performing tuning of tabular cubes.
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.
• Expertise in creating OLAP cubed and developing complex calculations, Aggregations, implementing dynamic security model using MDX functions in SSAS.
• Experience developing and supporting Microsoft BI and reporting capabilities (Power Pivot, Power BI, Power View) and implementing enterprise software solutions.
• Wrote calculated columns, Measures queries in power bi desktop to show good data analysis techniques.
• Managed indexes, statistics, and tuned queries by using execution plan for optimizing teh performance of teh databases.
• Expertise in developing, enhancing, and tuning of Oracle database objects and advanced PL/ SQL programs.
• Experience in working in agile scrum development methodology.
• Excellent interpersonal abilities, communication skills, time management and team skills with an intention to work hard to attain project deadlines under stressful environments.
• Flexible and versatile to adapt to new- environment and technologies.

PROFESSIONAL EXPERIENCE

Confidential - TX

MSBI, SQL Developer, Power BI Developer

Responsibilities:

• Worked closely with business and involved in gathering teh user requirements.
• Responsible for writing and modifying stored procedures, functions, packages for data conversions to create database objects dynamically.
• Created indexes, tables, and sequences as per teh business requirement and views to maintain data privacy.
• Used SQL profiler to identify slow running queries.
• Designed SSIS packages to validate, extract, transform and load data into staging and Data Warehouse.
• Analysed teh requirements and framed teh business logic for teh ETL process.
• Extensively used SSIS Import/Export Wizard, for performing teh ETL operations.
• Performed data migration from Excel, Sybase and Oracle to MS SQL Server using SSIS.
• Created package to transfer data between OLTP and OLAP databases.
• Designed Cubes with star schema using SSAS. Created hierarchies and partitions for improving SSAS cube performance.
• Created various complex reports and manage them using SQL Server Reporting Services (SSRS)
• Deployed and uploaded teh SSRS reports to Report Manager and called reports through a URL from .Net API for teh end users and involved in enhancements and modifications.
• Designed rich dashboards with Power BI and referred user stories to create compelling dashboards to deliver actionable insights.
• Created reports in Power BI preview portal utilizing teh SSAS Tabular via Analysis connector.
• Maintained database for inventory, billing and invoice systems and created dynamic stored procedures to retrieve teh customer details, payment history by giving related parameters
• Used Agile Development Methodology.
• Point of contact for all teh production issues.

Confidential

MSBI, SQL Developer, Power BI Developer

Responsibilities:

• Developing SSIS ETL packages from Avaya, NEBCO to staging as well as staging to data warehouse
• Active involvement in SSRS report development.
• Developed SSAS cubes for daily as well as continual jobs data by analysing data from various sources.
• Extracting data from source like Heterogeneous and transforming, cleansing, validating data and loading into destination DWH.
• Designed packages Using Control Flow Tasks and Data Flow Task. Used Control Flow Tasks like Sequential Container, Execute SQL Task, Send mail task
• Extracted data from sources and transformed teh data using different transformations like data conversion, derived columns, look up, Conditional Split, Aggregate, Union all, merge join and multi cast transformations.
• Created Event Handlers for teh Packages Using Event Handler Tab for Error Handling.
• Created Transactions in packages to roll back teh whole process in case of package fails.
• Logging - Maintained log information in SQL table to tracking Errors and recording package execution status through (Windows event log provider)
• Deployment - Build teh changes of packages, reports, Cubes and DB in to teh one folder and deploy teh changes through Batch Files.
• Responsible for Scheduling jobs for weekly, daily data refresh on different Power BI reports.
• Experienced in Data visualization and Data analyzation using Power BI.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Power BI.

Confidential

MSBI, SQL Developer

Responsibilities:

• Teh project aims at upgrading teh application from Sql server server
• Analysing teh stored procedures dat teh SSIS packages refer to and upgrading teh code from Sql server 2000 to Sql server 2008.
• Following teh best practices of teh stored procedures, preparing a checklist accordingly and then testing them in their environments.
• Running teh jobs through batch systems and rectifying teh issues if any, either in teh packages or teh procedures.
• Design and document teh error-handling strategy in teh ETL load process using Event handlers.
• Used Notification services to generate error messages and send them to teh user through e-mails.
• Post up gradation of teh code, testing teh code in two environments of Sql server 2000 and 2008.
• Creating unit test template documents and capturing teh results of both servers.
• Setting up teh batches and testing teh jobs in teh remote servers.
• Running teh jobs, analysing, and testing teh objects in development, integration, and production servers.

Confidential

MSBI, SQL developer

Responsibilities:

• Co-ordination with teh onsite and offshore team in understanding teh requirements.
• Coordinating with teh technical team to have clear insight of teh underlying business process and developing functional requirement documents.
• Written SQL queries for back- end data validation database testing and reports verification.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted teh results into reports and kept logs.
• Working experience writing SQL Scripts using Joins, stored procedures, Views, Indexes, functions, triggers.
• Provided back-end support for functional testing and performance testing.
• Worked on reconciliations of balances from different systems.
• Developing SSIS ETL packages from ODS to staging as well as staging to data warehouse, based on teh provided inputs and ensuring their successful execution during teh release 5 developments.