PROFESSIONAL SUMMARY:

Experienced SQL/ETL Developer with a demonstrated history of working. Experience in insurance, financial, cloud (GCP) and medical industries in providing various ETL and BI solutions. Motivated and ambitious Business Intelligence Analyst/Data Engineer with advanced experience in data analysis, data - warehousing, database design and administration. My future goal is to become full-time Business Intelligence Analyst, Data Engineer, Data Analyst or Data Scientist

TECHNICAL SKILLS:

Languages: Transact SQL, C, Visual Basic 6.0, VB.Net, C#, .NET, ASP.NET, HTML, JAVA

Databases: SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000 , MS Access. MongoDB, Postgres.

Analysis/Reporting Tools: SQL Server Reporting Service (SSRS), Data Studio, SQL Server Analysis Service (SSAS).

ETL Tools: DTS, SSIS, Data Stage, Alooma

Data Modeling Tools: Erwin, Visios

Other Software: MS Office- 2010/2007/2003/2000

Operating Systems: Windows /2000/2003

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, Solution Explorer, Analysis Manager, Reporting Server, GCP, BIG QUERY, MYSQL

PROFESSIONALEXPERIENCE:

Confidential, Charlotte, NC

Power BI/SSIS Developer

Responsibilities:

• Worked with business users on requirements gathering, provided project delivery estimates and Implemented requirements based on timelines.
• Actively participated in Methodologies like Scrum (Daily stand ups to give the progress of the work for the week) and Sprint for two weeks and Agile monthly.
• Creating Dashboards Scorecards, views, pivot tables, charts, for further data analysis using Power BI desktop.
• Created hierarchies in Power BI reports using Data visualizations like Bar chart, Line chart, pie charts, forecast charts.
• Creating DAX Expressions, create Date to yearly columns and implement partitions in Tabular Models for power BI.
• Publishing Power BI reports of dashboards in Power BI server and Scheduling the dataset to refresh for upcoming data in power BI server.
• Generating Drill through and Drill down reports with Drop down menu option, sorting the data, and defining subtotals in Power BI.
• Migrated existing self-service reports and ad-hoc reports to Power BI.
• Developed custom calculated measures using DAX in Power BI to satisfy business needs.
• Propose various Performance enhancement techniques to effectively source data for SSRS reports and power BI users.
• Worked with both live and import data into Power BI for creating reports.
• Managed relationship between tables in Power BI using star schema.
• Used different type of slicers available in Power BI for creating reports.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
• Migrate Business Objects reports to Power BI
• Migrate SSRS reports to Power BI.

Environment: SQL Server 2016, Visual Studio 2017, SharePoint, DataBricks, Azure Devops, Power BI, Microsoft Azure.

Confidential, Las Vegas, NV

Risk Analyst (SSIS/Power BI Developer)

Responsibilities:

• Worked with business users on requirements gathering, provided project delivery estimates and Implemented requirements based on timelines.
• Extracting the data from the different sources (Sybase, oracle) and sent the data into the intermediate Staging Database (SQL), CSV FILES using the SSIS ETL tool.
• Extensively used ETL to load data from wide range of sources such as flat files CSV, fixed width or delimited.
• Used highly complex T-SQL Queries and SQL Scripts to perform effective data load based complex business rules and provided backend SQL support.
• Created clustered indexes and optimized various T-SQL queries and done performance tuning using execution plan.
• Created SSIS packages using different talks and transformations and moved data from various sources to appropriate destinations.
• Used SSIS Import/Export Wizard, for performing the ETL operations.
• Extracted data using SSIS from OLTP to OLAP. Based on required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Responsible for testing to optimize the procedures and triggers to be used in production.
• Creating multiple kind of Power BI Reports and Dashboards.
• Publishing Power BI reports of dashboards in Power BI server and Scheduling the dataset to refresh for upcoming data in power BI server.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards per the client Requirements.
• Worked with both live and import data into Power BI for creating reports.
• Building the pipelines to copythe data from source to destination inAzure Data Factory(ADF V1).
• Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL and U-SQL Azure Data Lake Analytics.
• Transforming data in Azure Data Factory with theADF Transformations

Environment: SQL Server 2014/2016, SSIS, Power BI, SQL Profiler, DTS, T-SQL.

Confidential, San Antonio, TX

SSIS/GCP ETL Developer

Responsibilities:

• Actively worked with architects, developers, DBA’s and business stakeholders across multiple teams to migrate several ODS from SQL Server to Google Big Query.
• Analyzed existing Informatica workflows, SSIS packages and created mapping documents.
• Worked on setting up ETL plumbing data flows in Alooma. Created performance metrics for the data Loading into BigQuery via Alooma.
• Converted existing SQL Server tables, stored procedures into BigQuery tables and stored Procedures.
• Installed Docker container with Airflow on local machine for developing and testing workflows.
• Orchestrated workflows based on mapping documents in Google Cloud Composer/Apache Airflow (Deployed on Kubernetes cluster with Docker containers) by building several data pipelines for
• ETL/ELT data loading using Python to replace SSIS and Informatica.
• Utilized Airflow Postgres, MySQL, Oracle hooks and operators in building DAGs (Python scripts), YAML and SQL scripts to import several Postgres, MySQL and Oracle source systems data into BigQuery for EDW.
• Built DAGs to call the operators and bring in the source data as JSON schema and data files onto
• Google Cloud Storage (GCS). Loaded JSON files from GCS into BigQuery tables.
• Bulk imported SQL server generated JSON data files into BigQuery for large tables.
• Utilized on premise hooks and operators to connect to internal REST APIs and then loaded GET Request JSON files into BigQuery.
• Actively pushed code changes to GitHub and utilized Google Cloud Build trigger to auto deploy code in to Google Cloud Composer.

Environment: SQL Server 2014/2016, SSIS, Informatica, Power BI, SQL Profiler, DTS, T-SQL, Python, Big Query, Google Cloud Platform, Oracle, Alooma. Google Cloud Composer, Apache Airflow

Confidential, Dover, NH

SQL BI Developer (SSIS/SSRS)

Responsibilities:

• Worked as part of Integration team and Converted manual excel reports to Automated using SSRS and SSIS.
• Performing Peer review for SSIS, SSRS and SQL solutions.
• Worked with Database analysts for the Design of Summary tables required for efficient Report Design.
• Created complex SSIS packages extensively for data loads and businesslogics implementation.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2012 to MS SQL 2016 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Extracting the data from the different sources (CSV files, Sybase, oracle, and MS SQL) and stored the data into the intermediate Staging Database (SQL) using the SSIS ETL tool.
• Created complexSQL stored procedures using Microsoft SQL Server 2014 and 2016
• Used tools to migrate the data from legacy systems to MS SQL database.
• Developed various reports using SSRS, which included writing complex stored procedures for datasets.
• Performed the task of data transfer from files in remote server to folders in another server using FTP.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.
• Create ComplexStore T-SQL Procedurefor Medicare Reports using Common Table Expressions CTE.
• Worked on new reporting tool BIRST for creating templates and Subscriptions for different customers based on the requirements from the customer
• Maintained the ALM (Application life cycle management) tool for business level requirements before starting the development.
• Created Unit test and regression test scripts to validate the results and created the test cases.
• Monitoring, Job Scheduling, Troubleshooting, Back Up, recovery and system upgrading through Autosys.
• Experienced inenhancing and deploying the SSIS Packagesfromdevelopment server to production server.
• Created the SSRS reports based on the customer specifications (Standard /Custom reports).
• Worked on Performance tuning for the procedure which run for a longer time.
• Created SSRS reports based on the client requirements and scheduled meetings for producing Test cases based on the business requirement.
• Worked on the Reports module of the project as a developer on MSSQL Server 2005(usingSSRS, T-SQL, scripts, stored procedures and views).
• UsedDTS/SSISandT-SQLstored procedures to transfer data fromOLTPdatabases to staging area and finally transfer into data marts and performed action in XML.
• Created simple and complex stored procedures at Batch level processing for multiple subscriptions based on the requirement.
• Actively participated in Methodologies like Scrum (Daily stand ups to give the progress of the work for the week) and Sprint for two weeks and Agile monthly.
• Scheduled meetings with business lead to get the requirements for the stories to be done and maintained JIRA Dashboard to track the status of the work, capacity of the team and Burn down chart.
• Created the Debug, Unit and regression test scripts to validate the results and to create the test cases.
• Worked on TFS version control to check-in the code and have used the merging branch techniques. Also used GITLAB after post Integration
• Involved in debugging and Tuning the SQLcode, tuning queries, optimization for the Oracle database.
• Designed/developed tables, views, various SQL queries, stored procedures, function, complexSQLpackages.
• Extensively UsedSSIS as an ETLtool to extract data from legacy source Disability Reporting System (DRS) to Target system.
• Created Disability Reporting System (DRS) Reports based on Sybase Database.
• Documented all the process in the confluence.
• Primarily involved in Data Migration using SQL, Azure Data Factory and SSIS.
• Generating Drill through and Drill down reports with Drop down menu option, sorting the data, and defining subtotals in Power BI.
• Responsible for building reports in Power BI from the Scratch.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Publishing Power BI reports of dashboards in Power BI server and Scheduling the dataset to refresh for upcoming data in power BI server.

Environment: SQL Server Management, Azure, Microsoft Visual Studio 2013, Azure Data Factory, Microsoft SQL Server 2012, SQL Server Business Intelligence Development Studio (BIDS),AutoSys, JIRA, SSRS 2008 R2, SharePoint 2010.

Confidential, Scottsdale, AZ

SQL BI/Power BI Developer (SSIS/SSRS)

Responsibilities:

• Worked with business users on requirements gathering, provided project delivery estimates and Implemented requirements based on timelines.
• Created various Functional Specification Documents (FSD) and Technical Specification Documents.
• Used various sources to pull data intoPower BI such as Sql Server, Oracle, SQL Azure etc.
• Design and development of Microsoft Power BI visualization solutions like Dashboards, Standard Reports, Scorecards, Drill down reports, Drill through reports, charts and Ad - hoc Reports.
• Deployed web embedded power BI dashboards refreshed using gateways by using workspace and data source.
• Developed dashboards and ad-hoc reports using MS Power BI and SSRS for senior management team for analysis.
• Utilized Power BI to design multiple scorecards and dashboards to display information required by different departments and upper-level management.
• Scheduled Automatic refresh and scheduling refresh in Power BI services.
• Configured Power BI enterprise data gateway for scheduled data refresh of Power BI datasets.
• Provided continued maintenance and development of bug fixes for the existing and newPower BI Reports.
• Designed, developed and maintained the entire ETL and ELT processes to load the Hadoop File System (HDFS) from Linux server into SQL Server using SSIS.
• Created complex SSIS packages extensively for data loads and businesslogics implementation.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Created various SQL Stored Procedures, Functions, Views, Cursors, Triggers and Complex Queries using T-SQL and MySQL.
• Created aggregate tables and populated them on daily schedule using SQL stored procedures to support the entire reporting system for scheduled and on demand reports.
• Created SQL scripts and reports to monitor the revenue and spend during production releases.
• Extensively involved in performance tuning and optimization of various queries and stored procedures using SQL Profiler, query execution plans and DMV’s in SQL Server.
• Converted various manual Excel reports into automated reports and created new reports using SSRS.
• Developed the ‘Dimensional model’ of the Data warehouse and populated the historical data using SSIS.
• Performed extensive data analysis by writing complex SQL Queries and provided insights into various data related issues using EXCEL including pivot tables and ODC files so that business can make decisions.
• Documented every task performed on Atlassian Confluence wiki.

Environment: SQL Server 2010/2008/R2, T-SQL, MS SQL Server 2008 R2, MS SQL Server Integration Services 2008 R2, MS SQL Server Reporting services 2008 R2, Visual Studio 2008.

Confidential, Cleveland, OH

SQL BI/Data Analyst Developer (SSIS/SSRS)

Responsibilities:

• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Extensively worked on Data Flow tasks like for each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
• 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.
• Used dynamic connection managers using SSIS expressions to load data from different databases into a single DB.
• Attended daily scrum meetings and updated the status on User Stories.
• Provided story point estimation for user stories and hours for tasks.
• Worked in both Waterfall and Agile Methodology.
• Involved in Migration of Databases from SQL Server 20012 to SQL Server 2014 using SSIS.
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team and Capacity planning.
• Maintaining and supporting the existing reports as per the requirements in the customer support portal.
• Improved the performance of SSRS reports by tuning the Stored Procedures and TSQL queries using various join conditions. Generate experience in converting Actuate reports into SSRS. Created XML, PDF, EXCEL files using SSRS.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time.
• Created stored procedures and SQL statements for generating Ad-hoc Reports in SSRS.

Environment: SQLServer2012, 2008/2008 R2, SSIS, SSRS, T-SQL, Erwin, TFS, MS Excel.