SUMMARY

• 8 years of experience as MSBI / Power BI developer, database developer and data analyst with Microsoft SQL Server 2016/ 2014/2012/2008 R2/2008/2005, SSIS/SSRS/SSAS, OLTP, OLAP (Different environment such as Production, UAT, and development) and MSBI/Power BI in various domains.
• Extensive experience with SQL Server Integration Services (SSIS) 2008/2008 R2/2012/2014 and 2016 Data Extraction, Transforming, and Loading (ETL).
• Expertise in Scheduling Database tasks - Jobs, Alerts, Emails, Notification.
• Experience in BI Development and Deployment of DTS, SSIS packages from MS-Access, Excel, Oracle, and Teradata.
• Advance data modeling using DAX, power query/edit query in Power BI desktop, and working with custom visuals.
• Worked with the technical team and business users to analyze business requirements and translate them into technical specifications for ETL and reporting.
• Coordinated and participated in weekly estimation meetings to provide high-level estimates for backlog items.
• Experience in configuration and maintain report manager and report server for SSRS deployed and scheduled the reports in report manager.
• Power BI Tools - power bi desktop, power pivot, power query, power view, power map, power bi dashboard, calculated columns and calculated measures using DAX, data modeling.
• Generated complex Transact SQL(T-SQL) queries, Sub queries, Co-related sub queries, and Dynamic SQL queries. Programming in SQL Server - Using the Stored Procedures, Triggers, User-defined functions and Views, Common table expressions (CTEs).
• Experience migrating DTS packages to SSIS and SSDT is a plus.
• Experienced in client requirement Analysis, Logical and Physical design & development of database (using MS Visio, Erwin, normalization, and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2012/2008R2/2005, DTS, SSIS, SSAS and SSRS.
• 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 partial blocking Transformations.
• Expertise in creating Workflows based on Functional Specification Document.
• Experience in Deploying and Monitoring ETL packages in SQL Server by job scheduling the flow of packages from Development Server to Test and Production Server.
• Proficient in optimizing SQL queries, performance tuning using SQL Profiler as well, as understanding execution plans.
• Periodic reporting is done on a daily, weekly, monthly, and quarterly basis, which helps the clientby using the reporting Services (SSRS), POWER BI.
• Created various types of charts like Heat Maps, Geocoding, Symbol Maps, Pie Charts, Bar Charts, TreeMaps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Table Desktop, Power BI, and Excel to provide better data visualization.
• Expert in generating on-demand and scheduled reports for business analysis or management decisions using SQL Servers Reporting Services (SSRS) and POWER BI.
• Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling for FACT and Dimension Tables using SQL Server Analysis Services.
• Created Excel reports, Dashboards & Performing Data validation activity VLOOKUP, HLOOKUP, Macros, formulas, index match, Slicer with (Pivot table, Get Pivot Data, Dashboards), Power View, Power Map, and Heat Map.
• Using SSIS connectors, assignments, and transformations, extracted, transformed, and loaded data from a variety of heterogeneous data sources and destinations such as Access, Excel, CSV, Oracle, and flat files.
• Familiarity with various SSIS components such as the For loop, For-each loop, Fuzzy lookup, and Event Handlers, Error Handlers, and so on.
• Has worked with SSIS to create master and child packages, as well as package configurations and logging.
• Expert on Microsoft Power BI reports dashboards and publishing to the end-users for executive-level Business Decision.
• Expertise in creating and maintain Workspace and Gateways.
• Expert on maintaining and managing POWER BI driven reports and dashboards. strong understanding of managerial and professional skill sets.
• Extracted data from databases Azure SQL Server for reporting and to facilitate sharing between multiple data systems.
• Experoenced in ERP system such as Oracle, SQL Server, and Azure SQL Server. Extract the data from different sources and cleanse the data.
• Implemented User-Defined server roles in SQL Server 2019, default schemas for groups.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Extensive knowledge and experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, cursors using SQL and PL SQL.
• Experienced in all facets of software development life cycle (analysis, design, development, testing, and maintenance) usinga waterfall methodology.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.
• Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Data Tools

Databases: MS SQL Server 2, Oracle 10g/9i/8i, DB2, Teradata, MS Access

Business Intelligence: MSBI, Power BI, Tableau

Cloud: Azure, Google cloud

Programming Languages: C, C#, VB.Net, SQL, T-SQL, Power Shell, Visual Basic

Web Technologies: ASP.NET, ADO.NET

ETL Tools: Data Transformation Services, SQL Server Integration Services (SSIS), Informatica.

OLAP Tools: SQL Server Analysis Services (SSAS)

Scripting: HTML, DHTML, XML, JavaScript

Reporting Tools: SQL Server Reporting Services (SSRS) 2012/2008, Crystal Reports, Qlik View, Tableau, Power BI, Crystal Reports XI/X/9/8.

Application Packages: MS Outlook, MS Office

Operating Systems: Windows 2003/2008, Windows 7, Windows NT, Windows 2000, XP

Version Control: Team Foundation Server, VSS, SVN

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

MSBI Developer/ Power BI

Responsibilities:

• Coordinating with business users in analyzing business requirements and translating them to technical specifications.
• Developed dashboards and ad-hoc reports using MS Power BI and SSRS for the senior management team for analysis.
• Using SSIS Package, identified the upstreams and imported the required tables into the intake database, Stored Procedures are created in the staging database using the intake database tables.
• Created complex SQL stored procedures, Triggers, Functions, Views, Indexes in SQL Server 2016.
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Design data model and creating the schema on Azure SQL.
• Good grasp of database concepts, structures, storage theories, practices, or principles.
• Hands-on expertise in SQL reporting, development, analytics, or BI.
• Relevant experience in processing flowcharts or data flow diagrams used various sources to pull data into Power BI such as SQL Server, Dynamics CRM, Oracle, SQL Azure, etc.
• Responsible for monitoring and making recommendations for performance improvement in hosted Databases. This involved index creation, index removal, index modification, file group Modifications and updating statistics in databases
• Responsible for Physical Storage Structures and Index Design and Tuning.
• Restored and recovered databases to point in time for testing, pre-prod and production environments.
• Created many complex Query and used them in Power BI Reports directly to generate reports on the fly.
• Incorporated complex business logic by writing complex SQL procedures and functions.
• Extracted data from Oracle, SQL Server, Flat Files, Excel and XML using SSIS and cleanse the data.
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large database sets.
• Checking the code into TFS (Stored Procedures, Views, Tables, Schema)for the deployment process for the production environment Published Power BI Reports in the required origination and made Power BI Dashboards available in Web clients and mobile apps.
• Wrote T-SQL (DDL and DML) queries, Store Procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data.
• Collecting business data from different OLTP systems and loading it into a data warehouse using SQL Server Integration Services (SSIS).
• Filtered bad data from legacy system using T-SQL and implemented constraints and triggers into new system for data consistency.
• Implemented User-Defined server roles in SQL Server 2019, default schemas for groups.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Designed and developed the ETL data flow to populate the CER Cube Analysis Database using the SSIS packages (SQL Server Integration Services). Scheduled and automated the packages to populate the data in the cube daily up to date for business reporting.
• Created functions and developed procedures to implement application functionality at the database side for performance improvement, involved in Performance tuning of Queries, Indexes and Stored Procedures using SQL Profiler.
• Created different data visualizations using Lines, Pies, Histograms, Maps, Scatter, and Bullets using Power BI.
• Created KPI’s, Partitions, Perspectives, and Calculated Measures, used DAX queries, and Roles.
• Created maintenance plans for database consistency and integrity checks, resolved issues related to database consistency and integrity.
• Worked on SSAS storage and partitions and Aggregations, Calculation of queries with MDX, Data Mining Models, developing reports using MDX and T-SQL.
• Implement the SAP Business Objects reporting requirement.
• Worked extensively on data refreshes from production to test environments, automated the whole data refresh process at database level using PowerShell scripts, stored procedures, Backups and SQL Agent jobs without having any performance impact on Production server.
• Responsible for deploying the application for the Integration, Functional, and User Acceptance Testing.
• Adheres to department, organization and industry guidelines, standards, policies, and procedures.
• Created Page Level Filters, Report Level Filters, and Visual Level Filters in Power BI according to the requirements.
• Used One Drive for storing different versions of the Power BI report.
• Used JIRA for Version Control needs task check-ins.
• Excellent problem-solving approach, analytics skills, T-SQL coding commands.
• Responsible for complete maintenance and delivery of scheduled releases.
• Good knowledge of data warehouse and ETL (Extraction, Transformation, and Loading) concepts.
• Amazing communication skills and problem identification ability.

Environment: T-SQL, MS SQL Server 2017/2016, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS),SQL Server Analysis Services (SSAS), PL/SQL, PowerBI, Power BI Pro, AWS, Cloud, SOAP, REST, API, SharePoint, Open Source, Visual Studio 2016, MSSQLAzure, TFS, Unix/Linux, DAX, OLAP, OLAP, Scrum, XLST, XPATH

Confidential, Alpharetta,GA

MSBI Developer/ Power BI

Responsibilities:

• Designed, developed and tested ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Developed complex SSIS packages like Decompress JSON files and convert it to xml file and load it to staging table from SFTP server, loading PayPal, real time floating exchange rate packages using Web Services task, Execute Package task etc.
• Collaborated with the project team to outline project requirements in JRD meetings.
• Created complex DTS Packages for Data Migration and Transformation. Experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2012/ 2008.
• Implemented contained databases and partially contained databases to reduce dependencies of application databases on instance and to ease portability of databases between different environments.
• Profiled the legacy database tables using T-SQL queries to provide data cleansing issue reports to the client.
• Developed data reconciliation SQL queries to validate the overall data migration.
• Formulated DAX Expressions create Date to yearly columns and implemented partitions in Tabular Models for Power BI.
• Monitoring and Troubleshooting SQL Server Performance using Query Tuning, SQL Server Profiler, System Monitor, Database Engine Tuning Advisor, Dynamic Management Views and Functions and Resolving Blocking and Deadlocking Issues.
• Responsible for monitoring and making recommendations for performance improvement in hosted Databases. This involved index creation, index removal, index modification, file group Modifications and updating statistics in databases
• Used recently introduced Power BI to create self-service BI capabilities and use tabular models.
• Used SQL Server error logs and event viewer to troubleshoot issues, Windows performance monitor to find resource usage, profiler and server side trace for tuning SQL queries, stored procedures.
• Wrote DAX expressions to create new measures, calculations per business requirements.
• Effectively used data blending, filters, actions, and hierarchies feature in Power BI.
• Analyzed the data using Statistical features in Power BI to develop trend analysis.
• Published the developed dashboard, reports on the Power BI Services so that the end-users can view the data.
• Successfully integrated custom visuals based on business requirements in Power BI desktop.
• Participated in the configuration of an on-premises Power BI gateway to refresh datasets of Power BI reports and dashboards.
• Loaded data from one schema to another schema within the database through stored procedures.
• Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments.
• Created several types of SSRS reports like drill down, drill through, sub reports, Nested Chart reports and create report parameters included single valued parameters, multi-value parameters which also consisted of different parameter types queried and non-queried parameters.
• Created complicated reports such as parameter-based reports, graphical reports, excel reports, drill-down charts, and tabular reports using SSRS.
• Created different data visualizations using Lines, Pies, Histograms, Maps, Scatter, and Bullets using Power BI.
• Administrated and scheduled data-driven mailing subscriptions on SSRS Reporting Server.
• Generated and scheduled on-demand reports for business analyses and management decisions with SSRS.

Environment: Microsoft Power BI, Power BI Pro, MS SQL Server 2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Unix/Linux, AWS, Cloud, SOAP, REST, SharePoint, Open Source, MSSQLAzure, Python, TFS, PL/SQL, DAX, OLAP, OLAP, Scrum, XLST, XPATH

Confidential

MS SQL Server Developer/Power BI

Responsibilities:

• Participated in the user requirement gathering and Design meetings.
• Worked closely with Business Analyst, Data Modeler, and all teams within the organization to understand business Processes.
• Participate in Microsoft SSIS ETL Framework to perform tasks synchronously and asynchronously.
• Analyze source system data to assess data quality. Work with technical and business representatives to determine strategies for handling data anomalies that are identified.
• Design ETL processes and develop source-to-target data mappings, integration workflows, and load processes. Design, develop and implement enterprise-class data warehousing solutions.
• Used ETL (SSIS) to develop jobs for extracting, transforming and loading data into the data warehouse.
• Experiences in various types of tasks like Execute SQL Task, For each Loop Container Task, Sequence Container, Data Flow Task, File System Task, Execute Package Task, Bulk Insert Task, FTP Task and Send Mail Task on control flow and data flow in SSIS and Implementing like Conditional Split, Lookup, Merge, Merge Join, Multicast, Union, Row Count, Fuzzy Grouping and Checkpoint, Transactions in SSIS.
• Read source data from Azure SQL DB, CSV, and SQL Server 2016. Through Power BI.
• Generated context filters and data source filters while handling a large volume of data.
• Hands-on experience in utilizing DAX functions which includes Aggregation, Counting, and Logical, information, Text and date functions in source data.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Migrated Database from SQL Server by using side-by-side migration.
• Designed and optimized dynamic SQL batches to perform bulk operations in the OLTP environment.
• Designed and developed efficient SSIS packages for processing fact and dimension tables.
• Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.
• Monitored performance with SQL Profiler and Windows System Monitor.
• Create and customize simple data visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges, and single-number cards.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients.
• Created multiple data model and used as a common data source for the reporting purpose.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• In Power BI developed reports by different time intelligence like a year to date (YTD), Month to date (MTD), same period last year.
• Analyzing reporting requirements and develop various Dashboards, using trend lines and reference lines.
• Created no of views, calculated tables, calculated columns, and measures.
• Hand on Experience in UNIX to write basic commands, Moving files from HDFS to local and vice versa.
• Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs, and charts.

Environment: Microsoft Windows 2008 Advanced Server, Microsoft SQL Server 2014/2012/2008 R2, SSIS, SSRS (SQL ServerReporting Services), OLAP, Oracle SQL Developer, TFS, Erwin

Confidential

SQL Server BI Developer

Responsibilities:

• Created and developed data dictionary, tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager.
• Created reports by retrieving the data from cube using MDX reports.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Designed high-level ETL architecture for overall data transfer from OLTP to OLAP with the help of SSIS.
• Performed operations like Data reconciliation, validation and error handling after extracting data into SQL Server.
• Set package configuration in SSIS to redirect path from test environment to production environment.
• Using SSAS created OLAP cubes for data mining and created reports from OLAP cubes using SSRS.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Experience in moving the data from heterogeneous data sources like oracle, xml etc. to SQL using SSIS.
• Lead the development of automated DTS/SSIS packages to extract, transfer, load and convert data from various.
• Prepared the complete data mapping and Report Definitions for the project, which involved around 33 reports.

Environment: MS SQL Server 2012/2008R2/2008/2005,SSIS 2008R2, SSRS 2008R2, SSAS 2008R2,Microsoft Access, TFS, Windows 2003 Standard Edition, Windows 2000 Advanced Server, VSS, SQL Diagnostic Manager.