SUMMARY

• A 8 years of IT experience as a MSBI and SQL developer that includes migration of data and buling of reports using SQL server 2016/ 2014/2012/2008 R2/2008/2005 and Visual studio 2010/2008.
• Expert in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2005/2008/2008 R2/2012/2014 with expertise on data normalization.
• Conversant with all phases of the Software Development Life Cycle (SDLC) especially Agile, Scrum, involving business process analysis, requirements gathering & analysis, detailed design, development, testing and post implementation support.
• Strong knowledge of Data Warehouse concepts and technologies such as ETL processes, dimensional modeling, Star and Snowflake Schemas, reporting tools etc.
• Highly proficient in creating database objects like tables, indexes, views, user defined functions, stored procedures, triggers, cursors, data integrity and constraints.
• Good knowledge of Normalization/De - normalization, data design methodology and building Referential Integrity.
• Well versed in Normalization/Denormalization techniques for optimum performance in relational and dimensional database environments.
• Expertise in Database Administration operations like Backup, Disaster Recovery, Replication and using SQL Profiler.
• Highly skilled in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Experienced in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and SQL Server Analysis Services (SSAS).
• Used VB scripts in the script task in SSIS packages.
• Highly knowledgeable in Designing, Developing and deploying various kinds of reports using SSRS using relational data.
• Strong experience in Creating, Designing and Processing a Multi-Dimensional Analysis Cubes (Configured Cubes, Dimensions, Measures, MDX Queries, DAX Data mining, Data Source, Data Source Views and following Star and Snow Flake schema) using SQL Server 2005/2008/2012 Analysis Services (SSAS).
• Scheduled & distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio.
• Experienced in designing and developing large number of reports in SSRS using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Good knowledge of Azure services - Data lake and Azure SQL
• Organized, self-motivated and punctual with excellent oral and written communication skills, quick learner, can adapt quickly to a new technology, with ability to take new roles in minimum time and little training.

TECHNICAL SKILLS

RDBMS: MS-SQL Server 2016/ 2014/2012/2008 R 2/2008/2005/2000 , MS Access, DB2, PostgreSQL, Mysql

SQL Server Tools: (SSMS)SQL Server Management Studio 2012/2014/2016 , SSIS, SSRS, SSAS, SQL Profiler, DTS, SQL Server Business Intelligence Development Studio, Power BI

Tools: Microsoft Visual Studio 2017/2010/2008 , Share Point Server 2007, Microsoft Project Server 2007.

Reporting Tools: SSRS (SQL Server Reporting Services), Tableau, Power BI, Crystal reports

ETL Tools: SSIS (SQL Server Integration Services), DTS, BCP (Bulk Copy Program)

OLAP Tools: SQL Server Analysis Services 2016/2012/2008/2005

Operating System: Windows 95/2000/2003/ XP/VISTA/7/8/8.1/10, LINUX, UNIX, Windows Server 2003/2007.

Business Tools: Office 2000/2003/2007/2010/2013/2016 (Word, PowerPoint, Excel, Project), Xcelsius

Web Development Tool: HTML, XML

Architecture: Relational DBMS, Client-Server Architecture, OLAP and OLTP

Methodologies: Agile, Waterfall

PROFESSIONAL EXPERIENCE

MSBI Developer

Confidential

Responsibilities:

• Collaborate with the business stakeholders, developers, analysts, and testers to understand the requirements, design, and develop solutions
• Developed Logical and physical data model using ERWIN and mapped the data into database objects.
• Analyzed financial data to identify relationship between operations and payment trends
• Written complex procedures, functions and created database objects to manipulate data
• Create and modifying Tables, view, Stored Procedures and Functions using T-SQL
• Prepare and maintain database design and data Mapping documentation.
• Convert the Mapping document into SSIS package and created highly complex SSIS packages using various Data transformations like conditional split, Fuzzy lookup, Multi Cast, Derived column, Lookup, Union All, merge, Copy etc.
• Involved in designing and deploying Data warehouse using Snowflake schema and created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Designed, developed and established KPIs, matrix and tabular reports with drill down, drill through report using SSRS and Power BI to monitor, analysis and provide strategic insights to drive performance for Loan risk department
• Developed metrics that provide data for loan process management and indicators for future service improvement opportunities
• Developed report on loan performance on a daily, weekly and monthly basis in Power BI and SSRS
• Implement automated methods and industry best practices for consistent installation and configuration of PostgreSQL for production and non-production environments.
• Database Consolidation from MySQL, DB2 & SQL Server into PostgreSQL Database
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and Customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Using ado .net as the connection manager we moved data from Sql server management studio to Azure.
• Problem identification, troubleshooting, resolution and index tuning databases.
• Taking Database Full Backup, Transaction log backup & differential backup in daily Routine.
• Diagnosing and tuning the server optimal performance using SQL Server 2008 SQL Profiler and Database Engine Tuning Wizards.

Environment: SSIS, SSRS, MS SQL Server 2014/2012/2008 , C#, Visual studio 2008, PostgreSql DBA, Microsoft Azure, NiFi, MS Access, MS Excel, MS Office Access 2007.

SQL Developer / BI Developer

Confidential

Responsibilities:

• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using DTS and SSIS services.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Have deployed packages on different servers by configuring it.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Create and edit alerts on Reports, as per User request
• Modify the existing reports by adding new logic and deleting existing logic as the line of Business changes periodically
• Migrate reports from Dev to Production
• Provide on call support after reports are deployed to production
• Export reports in various formats like MS Excel, PDF, MS Word, Text and CSV
• Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Ad hoc reports (SSRS)
• Experience in writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers.
• Used Tableau 8.2 and Power BI for creating Dashboards over the database system.

Environment: SQL Server 2012/2014, SSIS, SSRS, SSAS, OLAP, OLTP Performance Point Server, SQL Server Business Intelligence Development Studio(BIDS), T-SQL, C#, MS Excel, Windows 2000 Server, T-SQL, Tableau, Power BI