SUMMARY

• Highly motivated SQL BI Developer/Analyst with 12+ years of IT experience in database development, Business, Functional, and Technical requirements design and planning.
• Experience in data design, plan, and architecture using Microsoft BI Suite with expertise on ETL process, reporting, and support using SQL server 2012/2008/2005 , SSIS and SSRS.
• Strong experience in client requirement analysis, physical, logical design development, resource planning, coding, debugging, testing, deployment, support and maintenance of business intelligence applications using SQL Server, SSIS, SSRS, and Teradata.
• Continuous interactions with Business users, upstream vendors, solution architects to gather and understand business needs and implement in project delivery.
• Created, attended and participated in End to End project planning sessions including scrum meetings.
• Connecting with Business and Technology partners to ensure remediation of data quality items.
• Expert skills in Business Analysis, Data Analysis, Requirement Analysis, Business Process Modeling and Use Case Development.
• Thorough knowledge in all phases of software development life cycle (SDLC), quality procedures and standards while executing projects.
• Data modeling, project planning, analysis, profiling, cleansing, mapping, architecture, End to End data validation frame work creation for Data Migration and Integration
• Primary knowledge on C# and ASP.NET.
• Expert in writing T - SQL Queries, Stored Procedures, Common Table Expressions (CTEs), and User Defined Functions, Indexed Views and Triggers for data consistency and data manipulation.
• Expertise in dealing with complex and uncleansed data sources and data from legacy systems and migrate to new data sources/ databases.
• Hands on experience using Power BIcustom calculated measures in DAX for creating dashboards for Sales, Orders, and Enrollments.
• Strong knowledge in publishing and scheduling power BI dashboards and reports in Power BI service.
• Utilized legacy systems from SAP Hybris to EDW for end to end mapping documentation.
• Hands on experience using Tableau Desktop for Dashboard creation.
• Strong experience in developing complex reports like reports using cascade parameters, drill down and drill through reports, matrix reports, sub reports, parameterized reports, Ad-Hoc and charts using SQL Server Reporting Services (SSRS) based on client requirement.
• Extensive experience in data extraction, transforming and loading (ETL)using SQL Server Integration Services (SSIS), DTS, Bulk Insert and Bulk Copy Program (BCP).
• Proficient in creating and deploying SSIS packages from heterogeneous sources like Excel, CSV, Oracle, flat file, text format data by using multiple transformations in SSIS such as data conversion, conditional split, bulk insert, merge, aggregate, derived column and union all.
• Deploying SSIS packages with environmental pick variables through data connection strings, scheduling SQL jobs using SQL Agent at proficient level.
• Expert in using Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS with SQL Server.
• Extensively worked on SSIS packages to extract data from heterogeneous databases & different files format (Text File, Spread Sheet, and XML) and load to SQL Server 2005, 2008.
• Experienced in designing jobs, alerts, SQL mail agent, and scheduling DTS and SSIS packages.
• Migration process from Oracle to SQL server using SQL Server Migration assistant.
• Experience in designing, developing, deploying and processing cubes in SSAS.
• Proficient knowledge in designing partitions, aggregations for performance tuning in SSAS.
• Experience in writing MDX queries in Analysis Services and Reporting Services.
• Good knowledge of implementing backup and disaster recovery procedures.

TECHNICAL SKILLS

Databases: SQL Server 2005/2008/2012 /2014/2016 , MySQL

Database Tools: SQL Server Management Studio, BIDS, SQL Enterprise Manager, SQL Compare

Languages: T-SQL, MDX

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Import Export Data, Bulk Insert, Teradata

Reporting Tools: SSRS, Report Builder 3.0, Power BI, Tableau Desktop

Data Migration: MSDTS, SSIS, Data Migration, SQL Loader, SQL Server Data Tools

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

Sr. SQL BI Developer / Data Engineer

Responsibilities:

• Analyze marketing, sales, and operation data based on financial modeling and recommend next actions to improve ROI based on the data analyzed. Prepare trending reports and continually improve analytics dashboards in place today.
• Build data models and that show trends, ROAS (Return on Ad Spend) performance trending, lead projection forecasting. Use existing company technology while integrating new technology to optimize efficiency and increase ROI.
• Use data to better understand target market, segment audiences, run queries and perform analysis to support decision-making process.
• Create monthly, weekly and daily reporting dashboards on marketing-generated leads. Make recommendations to adjust tactics for future campaigns to meet lead and pipeline development goals.
• Establish and report on KPIs across all online and offline marketing channels.
• Participate in the creation and execution of marketing campaigns; track the success of campaigns, conduct ROI analysis and present findings to senior leadership.
• Coordinate with Marketing and Finance departments on budget vs. actual spend reporting.
• Effectively manage multiple projects varying in scope and deliverables while remaining focused in a fast-paced environment to ensure the target delivery or time-sensitive projects are met.
• Experience building automated Extract Transform and Load (ETL) systems to process incoming data sources.
• Implemented ETL to migrate the data from azure database to SQL Server using Kingsway soft tool.
• Support end user reporting tools such as Microsoft Power BI, SSRS and Domo.
• Create and manage analytical tools that transform operational data into actionable business intelligence.
• Perform detailed data exploration and validation from a variety of sources.
• Used Red gate tool for comparing the scripts in the production environment with the backup to ensure no errors in the deployment.
• Coordinated with the change advisory board (CAB) for accessing the risks and consequences of requested changes and the implemented change does not cause service interruption.
• Collaborate with other departments to solve problems and identify trends and opportunities.

Environment: MS SQL Server 2014/2017, Windows 10, T- SQL, SSIS, TFS 2017, MY SQL Workbench, DOMO, CRM365, AZURE DevOps

Confidential, San Ramon, CA

SQL BI Developer/Data Engineer

Responsibilities:

• Successfully completed and launched first phase of consultant Purchase Profile information integration project with continuous data integration from SalesForce Marketing Cloud to EDW.
• Successfully completed and launched ATLAS project with complete End-to-End process for Enrollments.
• Completed Data Migration for Customer data with complete database replication with new database built and data movement from SQL database to SAP Hybris system.
• Attended data mapping sessions with legacy database development resource for new system built and to match with Hybris system for Data Migration.
• Collaborated with stake holders, end users, vendors, and SME’s to understand and prepare project planning and requirements to meet the business needs.
• Organized multiple designs and project planning sessions with technical experts, development team, validation team to collaborate and understand requirements and scope of project.
• Worked closely with engineering teams and program management or business to deliver products to market.
• Documented required business and technical metadata attributes, respectively with input from data specialists and subject matter experts (SME) and technology custodians.
• Supported the implementation of metadata management standards to allow consistent definition of risk data elements at the enterprise level.
• Migrated 300K Customer profile data with Orders, Returns, Payments, and AutoShip information from legacy system to Hybris.
• Completed full data profiling, data cleansing, data transforms before the project launch. Created column to column mapping documents from legacy system to staging to End user system (SAP Hybris).
• Established SQL jobs to automate the ETL load process through SQL Agent.
• Pulled data from MySQL databases to staging database for Data Integration validation.
• Completed End-to-End validation with partial, bulk, and full load of data on multiple test servers and replication production servers and achieved best results.
• Continuous support based on the priority of task during customer data onboard process to production level environment.
• Created scripts to pull data from SalesForce to integrate with EDW system to upload data back to upstream systems.
• Created multiple SSIS packages to integrate with legacy database to pull data to staging and to Hybris.
• Developed scripts to bring in Order Data into Datawarehouse from Source through staging database.
• Created a Power BI Live Streaming Dashboard’s using Azure Stream Analytics for the R+F Convention 2018.
• Created Reports and Dashboards using Power BI Desktop.
• Created dynamic data visualizations in Power BI and integrated custom visuals based on business requirements using Power BI.
• Embedded Power BI reports on SalesForce portal page and managed access of reports and data for individual roles using user Roles.
• Extended current ETL Packages in SSIS to bring in data into EDW.
• Used SSRS Sales report dataset to bring data into EDW for Purchase Profile data using SSIS for tracking email for Marketing Cloud project.
• Created ETL to load Tracking and Unsubscribes flat files from Marketing Cloud export into staging database.
• Created complete working technical document and Data Dictionary for ATLAS-R1 project to reference for R2 and upcoming projects.
• Picked Boomi feed data from FTP Server and created ETL to integrate EDW and to integrate with profile feed for SalesForce.
• Created branches in source control for sprint deployment to check in development changes.
• Created Change Request’s, attended CAB approval sessions to represent the ongoing changes that need to be deployed on sprint basis for production changes.

Environment: SQL Server 2017, SSDT 2017, JIRA, Bitbucket, MySQL, Power BI, Source Control, Service Now

Confidential, Bartlesville, OK

Sr. SQL BI Developer

Responsibilities:

• Responsible for complete Database related activities for forms development in K2 application.
• Worked closely with the technical team to resolve issues and ensure solutions address functional requirements and to perform sanity Testing.
• Organized sessions with Product Owners, SME’s, and developers to create roadmap for product growth and launch and to align the stakeholders, and to acquire a budget for developing the product.
• Created roadmap in Agile Methodology with understanding the complexity of changes and updates during the ongoing project.
• Created, updated stories in Rally in sync with Scrum Master about User Stories with Tasks based on daily allocated tasks.
• Participated in development of enterprise standards around data management, integration, and systems interoperability
• Created high level metadata documentation to perform UAT and post deployment testing for the Enterprise Data.
• Helped engineers to storyboard process flow between the stake holders and IT in RALLY
• Continuously identified areas of improvements and opportunities to apply agile best practices into daily team activities in running bi-weekly 15-minute sprint meetings.
• Integration DB objects in K2 Black Pearl application to show form Header, Attachment, Signature, and various tabs information.
• Work closely with Scrum masters on writing user stories and work on timelines for sprint planning, reporting, backlog prioritization etc.
• Created dashboards using Tableau Desktop to visualize Driver tracks, pipeline analysis which displays KPI’s, metrics, and key data points to monitor each department process.
• Consulted stakeholders and gather key data points, visualized data, and designed dashboard and deployed KPI dashboard to portal.
• Developed multiple dashboards, analytical reports, KPI’s, and interactive reports based on business requirements using SSRS and Power BI.
• Utilized SSRS to add KPI’s to add directly to web portal. Established and own selection goals, identify and define metrics to show impact
• Created, updated, and modified database objects based on form requirement and integrated with form in application.
• Communicate with management and senior executives about program direction, strategy and the operational execution.
• Designed and developed full scale BI reporting solutions utilizing SSRS.
• Enabled Power BI access from any device with Power BI Mobile app to easily access and annotate reports.
• Shared and published Power BI sales reports with users and Business users.
• Created various Function’s to feed Form Attachments data into respective Attachment table.
• Migrated data from various Excel documents to system using Data Export Import wizard and through SQL Data Insert statements.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts, Pie Charts.
• Deployed and Migrated Data and DB objects from Development to Test and to Production as release activity.
• Compared DB Objects using SQL Compare tool and then created deployment scripts.
• Created data migration scripts by comparing data using SQL Data Compare tool and then deployed data to different environments.
• Created Production replica database with every day restore job to provide clone of production database used for testing and prod data reference.

Environment: MS SQL Server 2012 (SSIS), SSRS, Tableau Desktop, T-SQL, SQL Redgate Compare, K2 Black Pearl, Rally, SharePoint

Confidential, South Beach, FL

SQL BI Developer

Responsibilities:

• Participated in installation of SQL Server. Installed Enterprise Manger tools using SQL Server Setup Program.
• Created SSIS packages to load data into staging database for Ad Sales Data using Script task for bulk load from CSV Files using SSIS 2008 R2.
• Created package to load SVOD Sales Data into landing tables in Staging Database from multiple CSV Files.
• Used Conditional Split, Derived Column, and Union-All in SSIS package to fetch data in required order in table.
• Added Configurations to package to access and move the package at different environments by adding variables.
• Merged Ad-Sales Database tables with SVOD Sales revenue table data using joins to integrate data from different tables to move and used in Store Procedure to fetch data into GCC Database.
• Added SQL tasks in control flow for every log to identify the status of the package.
• Created Store Procedures using existing ones from Oracle database in SQL Server to move data into SQL Database.
• Involved in designing ETL as a part of Data warehousing and loaded data in to Fact tables using SSIS.
• Completed Technical Assessment for GCC Project and suggested best approach to integrate data from multiple sources.
• Attended sessions to gather development requirement information to enhance projects on both Sales and Services.
• Used JIRA to track and update the day to day changes on the task.

Environment: MS SQL Server 2008 R2 (SSIS), MS SQL Reporting Services 2008, JIRA.

Confidential, Nashville, TN

SQL BI Developer

Responsibilities:

• Participated in the installation of SQL Server. Installed SQL Server Enterprise manger tools using SQL Server Setup Program.
• Created SSIS packages by testing and cleaning the standardized data by using tools in Data Flow Transformation (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for the existing and new packages.
• Responsible for creating the reports based on the user requirements using SSRS 2010.
• Implemented MERGE statement for improving the Package performance.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Deployed the created SSIS packages in Development and Testing environments.
• Developed SSIS packages as per requirements and extracted and loaded data using FTPs.
• Created efficient SSIS packages for processing fact and dimension tables using transformations.
• Responsible for monitoring the progress of a SSIS packages and logging progress to a text file, SQL Tables and windows event log.
• Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to different databases.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Created and updated various T-SQL stored procedures, triggers, views and adding/changing tables for data load, transformation and extraction.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts, Pie Charts.
• Developed report parameters and performed Parameterized and cascading parameterized reports and sorting the data, defining subtotals for the reports using SSRS in Visual Studio

Environment: MS SQL Server 2010 (SSIS), MS SQL Reporting Services 2010, Tableau Desktop, SharePoint 2013.

Confidential, Tulsa, OK

SQL BI Developer / Analyst

Responsibilities:

• Developed over 100 reports for the BOKF-NetO Project as a quick fix release.
• Modified the existing StoreProcedure’s and Queries to accommodate the changes in reports.
• Involved in understanding the functional requirements, translation of technical documents, data dictionary mapping and data mappings
• Created SSIS packages by testing and cleaning the standardized data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split).
• Wrote complex queries using joins, Sub-queries, common table expression’s (CTE) in T-SQL-2008.
• Improved the performance of the T-SQL queries and Stored procedures by using SQL profiler, Execution plan, SQL performance monitor and Index tuning advisor.
• Developed Many Excel Reports like Pivot Table, chart Reports for Data manipulation.
• Created SSIS packages to transfer data from different data sources load it to data warehouse.
• Used SSIS features like event handlers, property expressions, and package configurations, transaction option, checkpoints and protection levels in the packages.
• Involved in Created Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through Report Models and Drill down Reports.
• Designed large number of reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading Parameters.
• Scheduled reports for daily, weekly, monthly for Executives, Business Analyst’s, and customer representatives for various categories and regions based on business needs using MSSSRS.
• Involved in designing ETL as a part of Data warehousing and loaded data in to Fact tables using SSIS.
• Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations. Created SSIS packages with error handling, and also worked with different methods of logging.
• Worked with other Business Analysts, Project Manager, and software development team through the life cycle of the Project.

Environment: MS SQL Server 2008 (SSIS), SQL Reporting Services 2008, Toad for SQL, Report Builder 3.0

Confidential, Woodcliff Lake, NJ

SQL SSIS/SSRS Developer

Responsibilities:

• Responsible for collecting and analyzing business requirements and building logical data models that describe the data and relationships between the data.
• Responsible for creating reports based on the requirements using SSRS 2005.
• Created new database objects like tables, views, indexes, stored procedures using T-SQL in development as well as production environments for SQL 2008.
• Involved in writing scripts to check for duplicate records, delete/modify them depending on the business rule.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Analyzed the requirements and framed the business logic for the ETL process.
• Extensively used SQL Server Agent and scheduled jobs to run at defined time.
• Scheduled the SSIS packages in jobs to load data every day. Analyzed and framed the business logic for the ETL process as per the requirements.
• Created periodic reports for Boards and Commissions using SSRS 2008 and scheduled SQL Server Reports (SSRS) using report server scheduler.
• Created ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data-mart databases, and process SSAS cubes to store data to OLAP databases in SSIS.
• Created SSIS Packages to migrate slowly changing dimensions.
• Deployed the SSIS package on various servers using package configuration from Test to Production servers.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Responsible for deploying reports to Report Manager and Troubleshooting any errors occurred during execution.

Environment: MS SQL Server 2012/2008, SSRS 2005/2008/2012 , SQL Agent, Windows 2003 Server.