PROFESSIONAL SUMMARY:

• 8 years of experience as MSBI / Power BI developer, database developer, and data analyst wif 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 wif 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 wif custom visuals.
• Worked wif teh 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 teh 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 teh Stored Procedures, Triggers, User-defined functions and Views, Common table expressions (CTEs).
• Development of teh databases are created meeting compliance wif 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 wif governance audits and regulatory requirements. Document data Management processes and procedures and provide input to teh 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 teh 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 teh client by using teh 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 noledge 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 wif (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 wif various SSIS components such as teh For loop, For-each loop, Fuzzy lookup, Event Handlers, Error Handlers, and so on.
• Has worked wif SSIS to create master and child packages and package configurations and logging.
• Expert on Microsoft Power BI reports dashboards and publishing to teh 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 teh data from different sources and cleanse teh 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 noledge and experience in dealing wif 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 wif a desire to learn clients’ business requirements.
• Strong inclination for finishing teh job before teh 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, TableauCloud: 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 wif 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 teh senior management team for analysis.
• Using SSIS Package, identified teh upstreams and imported teh required tables into teh intake database, Stored Procedures are created in teh staging database using teh 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 teh 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 teh 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 teh data.
• Scheduled and maintained nightly and weekly loads of data by creating teh corresponding job tasks.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large database sets.
• Checking teh code into TFS (Stored Procedures, Views, Tables, Schema)for teh deployment process for teh production environment Published Power BI Reports in teh 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 teh history of teh 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 teh 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 teh most up-to-date medical practices and technologies for use at company hospitals
• Designed and developed teh ETL data flow to populate teh CER Cube Analysis Database using teh SSIS packages (SQL Server Integration Services). Scheduled and automated teh packages to populate teh data in teh cube daily up to date for business reporting.
• Created functions and developed procedures to implement application functionality at teh 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 wif MDX, Data Mining Models, and developing reports using MDX and T-SQL.
• Implement teh SAP Business Objects reporting requirement.
• Worked extensively on data refreshes from production to test environments, automated teh whole data refresh process at teh database level using PowerShell scripts, stored procedures, Backups, and SQL Agent jobs wifout having any performance impact on teh Production server.
• Responsible for deploying teh application for teh 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 teh requirements.
• Used One Drive for storing different versions of teh 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 noledge 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 teh 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 wif governance audits and regulatory requirements. Document data Management processes and procedures and provide input to teh creation of data definitions, business rules and data access methods.
• Collaborated wif teh 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 teh portability of databases between different environments.
• Profiled teh legacy database tables using T-SQL queries to provide data cleansing issue reports to teh client.
• Developed data reconciliation SQL queries to validate teh 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.
• TEMPEffectively used data blending, filters, actions, and hierarchies feature in Power BI.
• Analyzed teh data using Statistical features in Power BI to develop trend analysis.
• Published teh developed dashboard, and reports on teh Power BI Services so dat teh end-users can view teh data.
• Successfully integrated custom visuals based on business requirements in Power BI desktop.
• Participated in teh 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 wifin teh database through stored procedures.
• Used Package Configurations to make use of teh 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 wif 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 teh user requirement gathering and Design meetings.
• Worked closely wif Business Analysts, Data modelers, and all teams wifin teh 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 wif technical and business representatives to determine strategies for handling data anomalies dat 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 teh 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 teh 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 wif 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 teh 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 teh 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 teh same period last year.
• Analyzing reporting requirements and developing various Dashboards, using trend lines and 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 teh data from teh cube using MDX reports.
• Involved in creating SSIS jobs to automate teh reports generation, and cube refresh packages.
• Designed high-level ETL architecture for overall data transfer from OLTP to OLAP wif teh 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 TEMPeffective 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 wif error handling.
• Experience in moving teh data from heterogeneous data sources like oracle, XML, etc. to SQL using SSIS.
• Lead teh development of automated DTS/SSIS packages to extract, transfer, load, and convert data from various.
• Prepared teh complete data mapping and Report Definitions for teh 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.