SUMMARY

• 10+ years of experience in Business Intelligence Using Microsoft SQL Server 2012/2016/Power BI and Azure.
• Currently working as a Data Conversion/SSIS/ETL/Power BI and Azure Developer at Lowes for a distribution and supply chain management tools project on Tabular Data model Architecture design.
• Strong Knowledge on Power BI to import data from various sources such as SQL Server, Azure SQL DB, SQL Server Analysis Services (Tabular Model), MS Excel etc.,
• Hands on experience on all phases of Software Development Life Cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, testing, and implementation.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using SQL Server Integration Services 2012/2016 (SSIS).
• Expert in developing Cubes on SSAS using SQL Server 2008/2012.
• Experience in managing and automating control flow, data flow, events and logging programmatically using Microsoft .NET framework for SSIS packages.
• Experience in creating partitions and designed various storage modes to increase the performance of cubes using SQL Server Analysis Services 2008/2005 (SSAS)
• Expert in calculating measures and dimension members using Multi - Dimensional Expression (MDX).
• Expert in writing DAX for writing custom calculations in power pivot MS Excel reporting
• Performed complex SQL, PL/SQL procedures and MDX Queries and generated reports.
• Experienced working on OLAP database development including KPIs, Data Mining.
• Expertise in designing complex reports like Dashboard Reports, Drill-Down Reports, Parameterized Reports, Cascaded Reports and Sub Reports using SQL Server Reporting Services based on client requirement.
• Expert in deploying the SSRS reports on Report Server.
• Expert in creating complex Stored Procedures, User Defined Functions, DDL/DML Triggers, Views, Cursors and Indexes to facilitate efficient data manipulation and data integrity in Teradata.
• Experience on High Availability/Disaster Recovery(HADR) solutions, Failover Clusters and Always on High Availability Groups, Replication, Log Shipping and Mirroring.
• Building the MS Dynamics CRM forms, screens, and views, as well as workflows and reports around the customer needs for an interface.
• Good knowledge on multiple clouds which include AWS and Azure.
• Experience in Azure SQL, Azure data lake, Azure data warehouse, Azure data factory.
• Experience in Azure Blob storage and azure pipelines.
• Understanding of MDM, Data warehouse / Data mart Experience with SQL Server in AWS environment.
• Testing the Web Applications manually and identify the application and database issues.
• Identify the application level issues and log the defects using JIRA as the Defect tracking tool.
• Logged all type of objects in JIRA/Remedy from the requirement specification issues, mapping documentation defect and database issues.

TECHNICAL SKILLS

• SQL Server 2012/2016 MS SQL Analysis Services, MS SQL Integration Services
• MS SQL Reporting Services, Power Pivot, XMLA, T-SQL/PL SQL, MDX, JIRA
• .NET Framework, C#, PowerShell, Teradata and Power BI Desktop.
• Azure SQL, Azure data Lake, Azure Data Warehouse, Azure ML

PROFESSIONAL EXPERIENCE

Confidential

MS SQL/SSIS/SSAS/MS Azure/Tabular Model/Power BI Developer

Responsibilities:

• Participated in the requirement gathering sessions to understand the expectations and worked with system analysts to understand the format and patterns of the upstream source data.
• Involved in writing the Design documents for new features & Enhancements.
• Built a Tabular Model cube from scratch data.
• Built Measures in tabular model using DAX queries and created partitions in tabular model.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them via Power BI.
• Built KPIs in tabular based on the end user requirements, worked on Performance of SSAS tabular model cubes.
• Automate SSAS tabular model cube processing using XMLA queries.
• Developed Multiple Power BI dashboards on top of different sources.
• Developed data model in Power BI and implemented Many to Many relationships.
• Automate Power BI data refresh by using Power BI Enterprise gateway.
• Did custom transformation in power BI by using M Language.
• Expertise in DAX Queries to build Power BI calculated measures and Calculated columns.
• Published Power BI reports to Power BI web service and Implemented Security for users.
• Directly interact with end users to get the ad hoc requirements and report modifications.
• Developed POWER BI Ad hoc reports on top of Existing Teradata data warehouse.
• Getting data from Teradata data warehouse.
• Developed Tabular model and generates Power BI dash boards on top of that.
• Worked on R programming to create custom visual in Power BI.
• Developed data warehouse using SSIS, SSAS tabular models.
• Using SQL Server Integration Services (SSIS) as an ETL Tool, the data has Extracted, Transformed and Loaded (ETL) from Excel and Flat file to MS SQL Server.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Developed Azure Pipe lines and getting data from IoT.
• Experience in Azure SQL and Azure blob storage.
• Migrated legacy SSIS packages into Azure data warehouse.
• Schedule Azure Pipe lines in Azure Job scheduler
• Migrating SQL Server 2012 SSIS packages to SQL Server 2016.

Environment: MS SQL Server 2012/2014, BIDS, Management Studio (SSMS), ETL, Integration Services (SSIS) 2008 R2/ 2012, Reporting Services (SSRS) 2008 R2/2012, Power BI, TFS, SQL Profiler, SQL Server Query Analyzer, Tabular Models, Azure.

Confidential

BI Developer (SSIS, SSRS)

Responsibilities:

• Involved in the entire conversion lifecycle stages of Requirement Analysis, Data Profiling, Logical and Physical Data Mapping, Strategy, design, development, Unit testing, conducting conversion mock runs, SIT, UAT, Data Reconciliation and validation.
• Created packages in SSIS with error handling as well as created complex SSIS packages using various data transformations like conditional split, Cache, for each loop, multi cast, Derived column, Data conversions, Merge, OLEDB Command, script task components.
• Deployment of SSIS packages to the conversion server and create and schedule SQL Server Agent jobs to automate the run of SSIS packages on a weekly basis.
• Developed data reconciliation SQL queries to validate the overall data migration. Prepared data reconciliation reports for conversion team/business. Maintained ETL functional specifications, test plans and data for data conversions. Automated the data reconciliation process to minimize the developer involvement in validating production migrations.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Extracted history data from flat files onto more than 140 SSIS packages by deploying them to different SQL Instances using Integration services catalog and created SQL agent jobs.
• Development of SSIS packages during Conversion, Unit Testing, Defect resolution in the Testing Phases of the project.
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Extract Transform Load (ETL) development Using SQL server 2008, SQL 2008 Integration Services(SSIS).
• Collected existing infrastructure information including Active Directory, SQL server, Reporting Server instance for implementation of MS Dynamics CRM 2015 system.
• Building the CRM forms, screens, and views, as well as workflows and reports around the customer, needs for an interface.
• Hosted SQL Databases on Microsoft Azure, AWS RDS.
• Managing AWS Infra and automation with CLI, API. Managing Data Centre Inbound and Outbound services.
• Created SSRS Reports and deployed on the report server and scheduled the reports using subscriptions and created jobs to deploy the reports to a specific location after every Release.
• Testing the Application before moving the code to the higher environments to reduce the defect percentage rate.
• Involved in Resolving the Defects from the Defect Tracking Tool JIRA in all the environments from STAGING, UAT and PROD.

Environment: Tableau Server 7.0/8.0, Tableau Desktop 8.1, SQL Server,Microsoft CRM 2015, JIRA,MS SQL Server 2008, TSQL, SQL Server 2008, SQL BI Suite (SSIS, SSRS) /DBA, Oracle 11g, JIRA, Report Builder.

Confidential, Charlotte, NC

SSRS Developer

Responsibilities:

• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
• Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using SQL Server Integration Services (SSIS).
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Build DataSync job on Windows Azure to synchronize data from SQL 2012 databases to SQL Azure .
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
• Used SSIS to unite data from existing system and performed transformations on MS SQL 2008.
• Timely Basis of code check ins using Team Foundation Server for the SSRS Reports.
• Performed troubleshooting of client CRM issues and maintained documentation of all reported issues.
• Worked closely with clients to understand CRM application enhancement needs.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Used Joins and subqueries for complex queries involving multiple tables from different databases.
• Designing and deploying scalable, highly available, and fault tolerant systems on AWS.
• Selecting the appropriate AWS service based on data, compute, database, or security requirements
• Implemented AWS Cloud Services EC2, VPC, Route53, S3, Dynamo DB, ELB, RDS, Elastic Beanstalk, Auto Scaling, SNS, SQS, Cloud Watch and Cloud Trail.
• Orchestrating and recreating the AWS Cloud Formation templates to create custom sized VPC, Subnets, NAT to ensure successful deployment of web applications and database templates.
• Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.
• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.

Environment: MS SQL Server2005/ 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), AWS, MS Visual Studio.NET# 2008, Microsoft TFS (Team Foundation Server), Visual Basic6.0/VB.net, VB Script and Windows 2008 Server.