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 environments 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, Notifications.
• 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 maintaining 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, Subqueries, Co-related subqueries, and Dynamic SQL queries. Programming in SQL Server - Using the Stored Procedures, Triggers, User-defined functions and Views, Common table expressions (CTEs).
• Development of the databases are created meeting compliance with HIPAA, patient privacy, and information and security. Functional area: Health care
• Experience migrating DTS packages to SSIS and SSDT is a plus.
• Experienced in client requirement Analysis, Logical and Physical design & development of databases (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.
• Generate and maintain control documentation of reporting procedures to comply with governance audits and regulatory requirements. Document data Management processes and procedures and provide input to the creation of data definitions, business rules and data access methods
• Implemented Copy activity, CustomAzure Data FactoryPipeline Activities for On-cloud ETL processing
• Expertise in creating Workflow based on Functional Specification Documents.
• 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, and understanding execution plans.
• Periodic reporting is done on a daily, weekly, monthly, and quarterly basis, which helps the client by 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, Event Handlers, Error Handlers, and so on.
• Has worked with SSIS to create master and child packages and package configurations and logging.
• Expert on Microsoft Power BI reports dashboards and publishing to the end-users for executive-level Business Decisions.
• Expertise in creating and maintaining Workspace and Gateways.
• Expert in 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.
• Experienceded in ERP systems 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 a variable for characteristics and query costs.
• Maintained a database of patients’ information including demographics, diagnoses, prescriptions and more.
• 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, and good interpersonal and communication skills. Team-oriented, technically motivated, and creative. User-oriented with a desire to learn clients’ business requirements.
• Strong inclination for finishing the job before the 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 2012/20 /2000, 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, Florida

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, and Indexes in SQL Server 2016.
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Design data model and create the schema on Azure SQL.
• Primarily involved in Data Migration using SQL, SQL Azure, Azure Storage, Azure Data Factory, SSIS, PowerShell
• 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, and Stored 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 the 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 variables for characteristics and query costs.
• Conducted research on the most up-to-date medical practices and technologies for use at company hospitals
• 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 KPIs, Partitions, Perspectives, and Calculated Measures, used DAX queries, and Roles.
• Created maintenance plans for database consistency and integrity checks, and resolve issues related to database consistency and integrity.
• Worked on SSAS storage and partitions and Aggregations, calculation of queries with MDX, Data Mining Models, and 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 the database level using PowerShell scripts, stored procedures, Backups, and SQL Agent jobs without having any performance impact on the 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.
• Analyzed and interpreted data from various sources to identify trends, patterns, or other useful information for use in healthcare research projects
• Developed complex SSIS packages like Decompress JSON files and convert them to an 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.
• Generate and maintain control documentation of reporting procedures to comply with governance audits and regulatory requirements. Document data Management processes and procedures and provide input to the creation of data definitions, business rules and data access methods.
• 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 instances and to ease the 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.
• Collected and analyzed clinical trial data according to approved study protocols and ensured adherence to regulatory requirements including GCPs (Good Clinical Practices)
• 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, and 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, and 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 the 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 including single-valued parameters, and 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 Analysts, Data modelers, 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 include Aggregation, Counting, and Logical, information, Text, and date functions in source data.
• Used Power BI, and Power Pivot to develop data analysis prototypes, 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 to Web clients.
• Created multiple data models and used them as a common data source for reporting purposes.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• In Power BI developed reports using different time intelligence like a year to date (YTD), Month to date (MTD), and the same period last year.
• Analyzing reporting requirements and developing 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 server reporting Services), OLAP, Oracle SQL Developer, TFS, Erwin

Confidential

SQL Server BI Developer

Responsibilities:

• Created and developed data dictionaries, 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 the cube using MDX reports.
• Involved in creating SSIS jobs to automate the reports generation, and 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.