SUMMARY

• I am a Sr. SQL/Power BI Developer with 10+ years of IT experience and 5+yrs MSBI experience in database design, development and administration with Oracle SQL Server 2016/ 2014/2012/2008/2005/2000 using SQL Server Integration Service (MS POWER BI SSIS), SQL Server Analysis Service (MS POWER BI SSAS), SQL Server Reporting Service (MS POWER BI SSRS) within in Banking, Healthcare and Insurance industries
• Conversant with all phase of Software Development Life Cycle (SDLC) involving System Requirements, Analysis, Design, Development, Implementation, Integration, Testing, Deployment and Maintenance.
• Experienced in ETL processes, Data warehousing methodologies and concepts including Star schemas, Snowflake schemas, Dimensional modelling, Reporting tools, Operations Data Store Concepts, Data Marts and OLAP technologies
• Extensive expertise in designing and development of applications utilizing of oracle, PL/SQL, SQL and UNIX Shell Scripting.
• Extensive knowledge and experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (MS POWER BI SSIS), Data Transformation Services (DTS), Bulk Copy Program (BCP)
• Experienced in designing high level ETL architecture, creating, configuring and fine tuning ETL workflows designed in DTS for overall data transfer from the OLTP to OLAP with the help of MS POWER BI SSIS.
• Highly proficient in the use of T - SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models, data integrity, SQL joins and query writing.
• Efficient in up-gradation and migration from ORACLE SQL Server 2000 to ORACLE SQL Server 2014/2012/2008/2005/2000
• Experience in developing Custom Report, different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (MS POWER BI SSRS) in Business intelligence development studio (BIDS).
• Experience in creating and deploying MS POWER BI SSIS (ETL process) packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column and Data Conversion Transformations
• Proficient at data transformations like lookups, Derived Column, Conditional Splits, Sort, Data Conversation, Multicast and Derived columns, Union All, Merge Joins, Merge, Fuzzy Lookup, Fuzzy Grouping, Pivot, Un-pivot and SCD to load data in SQL SERVER destination.
• Developed OLAP Cubes by using SQL Server Analysis Services (MS POWER BI SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Extensive knowledge of subject areas in Oracle 9i, 10g, 11g and 12c (SQL/PLSQL) combined with a broad subject background enabling contributions to application development.
• Expertise in preparing low and high-level design, UTC (Unit Test case), RCA (Root Cause Analysis), release notes and functional/Technical specifications document.
• Writing MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Used ProClarity tool to analyse the data in the cube by using different features like Chart view, Decomposition Tree, Performance Maps, etc.

TECHNICAL SKILLS

Languages: MY SQL, T SQL, PL/SQL, XML, C, Visual Basic 6.0, Java, and HTML.

Databases: SQL Server 2016/ 2014/2012/2008/2008/2005/2000 R2, MS Access, Oracle 9i, Oracle 10g, 12g, MySQL, DB2

BI tools: SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS).

ETL Tools: DTS, SSIS, Data Stage, Informatica, Bulk Copy Program (BCP), Business Intelligence Development Studio (BIDS), Crystal Reports 8.5/9/10/11

Data Modelling Tools: Erwin, Microsoft Visio

Operating Systems: Windows 98/XP/NT/ 2000/2003/2008/10 , UNIX, LINUX, Mac OS

Database Tools: SQL Query Analyser, SQL Enterprise Manager, SQL Server Management Studio (SSMS), SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server.

PROFESSIONAL EXPERIENCE

Confidential

SQL/ MS Power BI Developer

Responsibilities:

• Responsible for technical design, development, coding, testing, debugging and documentation of databases and database applications to satisfy requirements of one or more user areas.
• Responsible for creation of data services and integrating the data service components.
• Collaborate with other developers in creating optimal, maintainable, and scalable architecture and design and actively promote quality in coding and other project activities.
• Create high quality, detailed technical documentation overall database for the Current Project.
• Created MS POWER BI SSIS packages to load data into Data Warehouse using Various MS POWER BI SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task.
• Developing complex MS POWER BI SSIS packages using different data transformations like Aggregate Conditional Splits, Lookup, Sort, Merge Join, Data Conversions, Derived Columns, Multicasting, Slowly Changing Dimensions, Scripting, OLEDB Command with SQL etc.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and created clustered and non-clustered indexes.
• Generated reports using MS POWER BI SSRS, Power Pivot, and Power BI that could be used to send information to a diverse group of users, clients, and managers.
• Developed reports using MS POWER BI SSRS and published as PDF, Excel, and CSV formats.
• Responsible for the segmentation which runs daily where individual opens, clicks will be updated every day.
• Responsible for the database for the current project, where data is dumped into the database and scrubbed into the correct format per the requirement given by the client.
• Extensively used Joins and sub Queries to simplify complex queries involving multiple tables.
• Responsible for enterprise level solutions development including Data Warehousing, Data Martss.
• Responsible for high performance of data architecture and design including Star Schemas, Snowflake Schemas, and Dimension Modelling.
• Designed and created OLAP cubes (MSBI SSAS) on Data Warehouse.
• Highly proficient in creating data sources, data source views, dimensions, measures, measure groups, perspectives, partition aggregations. Analysis and Reporting Services, MDX queries, OLAP Cubes, and deployment and processing MSBI SSAS objects.
• Developed CTE's, Constraints, and Complex queries to fetch the data from different servers.
• Actively involved in writing SQL Stored Procedures, functions, and triggers for updating customer usage information in the database.
• Developed several behavioural reports and data points creating complex SQL queries and stored procedures using MS POWER BI SSRS and Excel.
• Monitored the jobs run using Informatica Workflow Monitor and used to debug the job by setting up the log files and bad files.
• Implemented the changes/modification like iterative/incremental development and used .NET Framework and Object-Oriented Methodologies for application development by using agile scrum methodology.
• Maintained Source definitions, Transformation rules and Target definitions using Informatica Repository Manager.
• Developing MS POWER BI SSIS packages that upload multiple flat files using for each Loop Container and uses other control flow tasks like File System task, FTP task, Send Mail Task, Script Task etc.
• Created MS POWER BI SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Designed and implemented stored procedures and triggers for automating tasks.
• Built ETL workflows using Informatica tools to extract the data from feed files (with the formats like XML, TXT, DAT, XLS, Message Queues, etc.,) and load them into staging area and then to Data Warehouse.
• Developed custom selection of reports ordering using SQL Server Reporting Services (MS POWER BI SSRS)
• Used MS POWER BI SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analysing multi-dimensional reports in MS POWER BI SSRS.
• Create reports in Power BI preview portal utilizing the MS POWER BI SSAS Tabular via Analysis connector.
• Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a date.
• Built different data visualization by using Power BI to turn data into charts/maps.
• Built a Tabular Model cube from scratch data and by MDX queries fetched data to MS POWER BI SSRS and Power BI reports.
• Implemented Event Handlers and Error Handling in MS POWER BI SSIS packages and notified process results to various user communities.
• Scheduling Daily, Weekly and Monthly MS POWER BI SSIS package execution process using SQL Server Agent jobs.

Environment: SQL Server 2016/2014/2012 , Clustering, MS POWER BI SSIS, MS POWER BI SSRS, T- SQL, Visual Basics, Visual Studio 2012/2015, Indexes, Cluster, Informatica, .Net Framework 3.5, MS Office suite 2011

Confidential

SQL/Power BI Developer

Responsibilities:

• Project: Retail Grocery Power BI for online transaction databases with SQL/SSRS/SSIS/SSRS technology
• Worked with Client/Business Analysts to define data requirements for reporting warehouse.
• Designing and developing SQL Server 2008 Databases, Tables, Indexes, Stored procedures, Views, Triggers.
• Worked with Client/Business Analysts to define data requirements for reporting warehouse.
• Designing and developing SQL Server 2008 Databases, Tables, Indexes, Stored procedures, Views, Triggers.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Created many MS POWER BI SSIS packages using Import/Export Wizard. Designed many Packages using MS POWER BI SSIS Designer by using Control Flow and Data Flow Tasks with ETL Tool.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services using packages to import/export data feeds to/from data warehouse and client systems.
• Designed and developed ETL process with SCD (slowly changing dimensions) with T-SQL, MS POWER BI SSIS and VBScript
• Migrate the data from an Access database to SQL Server 2008.
• Fetch the data from Oracle 10g by creating a linked server and use SQL Server to query Oracle database.
• Designed the packages in order to extract data from SQL database, flat files and loaded into Oracle database.
• Wrote and maintained database documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases.
• Involved in re-design, re-code, and deploy new data extractions using MS POWER BI SSIS, and designed and produced documentation of data transformations for all extractions.
• Developed, deployed and monitored MS POWER BI SSIS Packages including upgrading DTS to MS POWER BI SSIS.
• Designed best practices document for ETL and Reporting Systems using Data Warehouse concepts.
• Experience in creating multiple reports (MS POWER BI SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.
• Design, deploy, and maintain various MS POWER BI SSRS Reports in SQL Server 2008.
• Involved in the preparation of detail Unit Cost, Price and Volume Trends, Expense Variances and Profitability Reports using MS POWER BI SSRS.
• Reports in both SQL and reporting tools such as Crystal Reports and Business Objects
• Used SQL Server Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Environment: SQL Server 2014/2012/2008/2005/2000 R2, T-SQL, MS POWER BI SSRS, MS POWER BI SSIS, MS POWER BI SSAS, Visual Studio 2008, MS Office 2007/2003, MS VSS, XML, MS SharePoint 2007

Confidential - Providence, RI

MSBI Developer / SQL

Responsibilities:

• Developed Logical and physical data model using ERWIN,DAX and mapped the data into database objects.
• Web module development and deployment using ASP.net.
• Based on business requirements, developed the complex SQL queries with Joins and T-SQL, Stored Procedure, Views, Trigger to implement the business rules and transformations.
• Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Created reports from complex SQL queries and MDX queries.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various MS POWER BI SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used MS POWER BI SSIS to implement the slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created MS POWER BI SSIS packages to load data into Data Warehouse using Various MS POWER BI SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, and xml task.
• Created MS POWER BI SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Designed and developed matrix and tabular reports with drill down, drill through and drop-down menu option using MS POWER BI SSRS.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using MS POWER BI 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 (MS POWER BI SSRS).
• Customized Team Foundation Server as per project requirements.
• Customized and generated TFS reports to serve company needs.
• Integrated and customized TFS add-ins called 'Aggregator' to ensure automation.
• Problem identification, troubleshooting, resolution, and index tuning databases.
• Taking Database Full Backup, Transaction log backup & differential backup in daily Routine.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Diagnosing and tuning the server optimal performance using SQL Server 2008 SQL Profiler and Database Engine Tuning Wizards.
• Coordinated with web development team in .Net framework programming solutions.
• Integrated ASP.Net Web Pages to the SQL Server 2008 Back End.

Environment: ORACLE SQL Server 2008/2012 MS POWER BI SSIS, MS POWER BI SSRS, ORACLE SQL Server 2012/2008, C#, ASP.Net, Visual studio 2008/2010, MS Access, MS Excel, MS Office Access 2007.