Business Intelligence Developer

Phone: +1-216-***-****

Email – adi74b@r.postjobfree.com

Address: Irving, TX, 75063

Experience Summary:

With 5 years of professional IT developer experience using Microsoft SQL (T-SQL) Server database, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI desktop, Informatica as tools in various challenging work environments.

Developed SSIS/Informatica packages to Extract, Transform and Load (ETL) data into Data warehouse from various sources like Oracle, Progress, SQL Server.

Expertise in CI/CD using Team Foundation Server (TFS), VSTS and Azure DevOps for source code maintenance and automation deployment to various environments like Dev, QA and PROD.

Experienced in Creating SQL Projects and automating the deployments to multiple environments using TFS/VSTS/Devop’s

Experienced in creating the SSIS/SSRS Projects and automating the deployments to multiple environments using TFS/VSTS/Devop’s

Expertise in automating the scheduling of batch jobs using SQL Server Agent or Control-M application

Highly Proficient in writing complex SQL queries, Store Procedures, Functions, Views, CTE’s, analyzing data and creating index's on tables with high volume of data for faster data retrieval. Hands on experience in Performance Tuning and Query Optimization for better performance.

Extensive hands-on experience in creating various SSRS reports like Ad hoc, Drilldown, Drill through, Parameterized, Subscription based reports

Experience in creating Area Charts, Bar Charts, Line Charts, Doughnut Charts using PowerBI desktop.

Highly self-motivated and dedicated in work environment along with ability to work in high pressure sensitive time line environments.

Ability to work collectively in a team or individually

Expertise in debugging SQL/SSIS/SSRS/Informatica production issues irrespective of the business area.

Demonstrated very good communication skills while gathering and understanding the requirements from business users or end customers. Good qualitative and quantitative skills

Skills:

Languages T-SQL, SQL, C#, PL-SQL, Power shell

BI tools (SSIS, Informatica, SSRS, PowerBI Desktop, Excel)

Databases MS SQL Server 2008 R2/12/16/18, Oracle 11g/12c, Progress 15

DAX Query, Power Pivot, Power Query.

CI/CD (Azure DevOps)

Source Control (TFS, VSTS, GIT, Source Tree)

Agile

Operating Systems Windows 7, Windows 8, Windows 10

Visual Studio 2012, 2015, 2017,2019

Educational Qualifications:

Bachelor's Degree in Engineering 2014 JNTUH, Hyderabad, India

Master's Degree in Electrical and Computer Science Engineering 2016 CSU, Cleveland, Ohio

Professional Experience:

1)Business Intelligence Developer FHLB Dallas Irving, TX

Feb 2018 – Present

Responsibilities:

Worked together as a team in successfully implementing data warehouse for MPF product

Created SSIS Packages to move data from OLTP database to OLAP staging Databases

Created Dacpac’s and implemented the CI/CD pipelines in TFS for automation deployment

Expertise in creating Informatica mappings to load data into Operational Data Stage (ODS) from various sources

Created/Modified Informatica mapping(s) as per the business requirements

Designed and built complex SCD Type – 2 mappings (using SQ, RTR, JNR, AGG etc.) in Informatica to load Dimension tables in Data warehouse

Built Informatica mappings to load snapshot Fact Tables with moderate to complex logic in transformations

Troubleshooted and fixed the issues in informatica mappings on numerous occasions

Designed and Implemented the project of bringing Transaction level information of OLTP database to Dimension and Fact Tables in data warehouse

Expertise in creating automated process for loading data from tables into a CSV/XML files using Informatica which are later consumed by downstream process during nightly batch processing.

Expertise in designing tables or writing moderate to complex Stored Procedures or views in Oracle PL-SQL/ T-SQL

Worked directly with multiple user groups across the bank to gather the requirements and fulfill their needs which in turn helped them achieving their OKR’s or corporate VPP goals

Automated the deployment of SSIS Projects, Database Projects and SSRS Projects

Expertise building/Scheduling new jobs using automation job scheduler Control-M across multiple platforms like Informatica, SSIS, SQL Stored Procedures

Expertise in building SSIS packages using various components like Foreach Loop Container, Sequence Container, Execute Package Task, Execute Process Task, Data conversion, Merge Join, Conditional Split, Multi Cast, Script Component, Script Task, Union All, Hash key generation etc.

Worked on implementing bridge tables in data warehouse which help in one-many or many-one relationships

Created or provided support to numerous Drill through, Ad hoc reports in SSRS which helps in providing KPI’s, KRI’s and other metrics to the end users

Experience in debugging complex live production issues and resolving them in the need of hour

Developed SSIS package using web service to pull data from Office of Finance which help Capital Markets team to monitor the changes to securities from OOF

Created and automated the process in SSIS to receive Chicago Buddy Bank Files and load them into SQL tables

Implemented complex business logic of calculating collateral for a customer based on various business rules

Implemented Audit Trail using SQL to track the changes made to a record for internal and external audit

Conducted seminars on various topics in knowledge share meetings at IT Department level

Automated numerous process using SSIS which help business users to focus more on their day-to-day activities

Collaboratively working together as a team in Collateral project to meet the banks VPP goal of Collateral De-Customization

Environment: SQL Server 2012/16/18, VS 2015/17/19 SSDT 2015, SSIS 2015, SSRS 2012/15, PowerBI Desktop, Progress DB, Oracle 11g/12c TFS 2015/17/19, VSTS, Azure DevOps, GIT, Control-M, PowerShell, C#, SSRS Report Builder, PowerPivot, PowerQuery, DAX, Jira

2)SSIS/SSRS Developer Kansas City Southern Kansas, MO

Feb 2017 – Feb 2018

Responsibilities:

Involved in design, development and Implementation of fact tables, Dimension tables in SSIS using star schema model

Migrated data from Oracle databases to SQL Databases through SSIS by using ODBC Connection manager

Created SSIS packages to connect to webservice and pull data into SQL Server tables

Used various Control Flow tasks like For Each Loop Container, For Loop Container, Sequence Container and Data Flow tasks like Merge, Multicast, Lookup, Derived Column, Script Component etc.

Used DML (Data Manipulation Language) to Insert or Update data by satisfying the referential integrity constrains and ACID properties

Created numerous Ad hoc reports, Parameterized reports and Drilldown reports

Implemented numerous heavy business logic stored procedures which helped the request from the UI to be processed a lot quicker

Participated in the requirements elicitation and technical specification processes

Designed Entity-Relationship diagrams and thus the database schema

Environment: MS SQL Server 2016, Oracle12g, VS 2015, TFS 2015, SSDT 2012, MS Office 2010.

3) Jr SQL Developer Blueware Technologies & Services Hyderabad, India June 2014 – July 2015

Responsibilities:

Performed performance tuning by identifying the bottle necks in slow performing queries.

Created Non-Clustered/ Clustered Indexes on objects based upon the most commonly used data elements by the end users.

Created SSIS packages and automated them through SQL Agent job to load data from Flat Files, CSV files, Xml files into SQL Tables

Simplified complex logic in SQL Queries by creating Views/Functions and used them in SSIS to read data from OLTP system and loading into ODS.

Worked as a team and assisted the end users with various ad hoc queries

Used various types of logical and arithmetic SQL functions as part of the development process

Validated the change requests and made appropriate recommendations. Standardized the implementation of data

Created Drill through and Drilldown reports as per the end user requirements

Environment: SQL Server 2008R2, SSDT, SSRS, TFS, Visual Studio 2012, MS-Office, MS-Excel.

BHARGAV KUMAR

YELURI

Contact this candidate