Resume

Sign in

Sr. Business Intelligence Developer/ Sql Developer

Location:
New York, NY
Posted:
February 26, 2016

Contact this candidate

Resume:

Priyank

Email id:actpm4@r.postjobfree.com

Phone: 973-***-****

C2C or CTH

Professional Summary:

●Over 8 years of IT experience as MS SQL Server Developer 2014/2012/2008 R2/2008/2005/2000 in various Industry verticals like insurance, engineering, Pharmaceutical, Retail and Bank.

●Hands on experience in designing data warehouse using star flax schema and snow flax schema.

●Proficient in doing performance tuning in T-Sql using SQL server profiler and SSIS packages.

●Expertise in Creating, Configuring and Fine-tuning ETL workflows designed between Homogenous and Heterogeneous Systems using SSIS of MS SQL Server 2008 and MS SQL Server 2005 respectively.

●Extensive Knowledge in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated transformations to be used in SSIS packages.

●Expert in Data Conversion, Normalization and Data Modeling, Multi-Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema using Erwin Tool.

●Expertise in developing SSIS Packages and using data transformations and deploying them on various production servers.

●Proficient in creating On-demand and Scheduled reports, handling sub reports and defining query for generating drill down reports using MS SQL Server Reporting Services 2008/2005 (SSRS).

●Highly skilled in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008/2005.

●Expertise in Developing and Extending MS SQL Server Analysis Services 2008 (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects.

●Adept in defining referenced relationships and calculated members in SSAS and used MDX queries.

●Expert in using tools such as Bulk Copy (BCP) and Data Transformation Services (DTS).

●Extensive knowledge in developing and implementing Disaster Recovery Model, and Replication Models.

●Worked on building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

●Worked on developing Tableau visualizations and dashboards using Tableau Desktop.

●Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows Performance for monitoring and tuning SQL Server performance.

●Maintained positive communications and working relationships at all business levels.

●Sound knowledge and working experience under Agile and waterfall methodology of Software Development Life Cycle Process (SDLC)

●Worked on TFS for Schema compare, Code Management and Deployment.

Education & Certification:

Masters

Skillset

MS SQL Server 2014/2012/2008 R2/2008/2005/2000/7.0, MS SQL Server 2008/2005 Analysis Services (SSAS), MS SQL Server Integration Service (SSIS), MS SQL Reporting Services (SSRS), Microsoft Access 2000/8.0, Business Object 3.1, Microsoft Excel, Outlook, MS SQL Profiler, SQL Query Analyzer, Database engine tuning advisor, Tableau Desktop (Version7.0.3-Version8.2.3), Tableau Server, Toad, Power Designer 16.0, 16.5, Vb.net, Erwin Data Modeler 7.2/4.2/4.1, Excel VBA, Crystal Reports 8.5, T-SQL, MS Visio 2005, Windows 2003/2000 Advanced Server/Professional, Windows NT 4.0 Server/Workstation, Agile, TFS.

Professional Experience:

Fluor Greenville, SC

Duration: August 2015 – present

Role: Sr. Business Intelligence Developer/ Sql Developer

Job Description:

Fluor is leading engineering services company in United State and providing engineering services in all over the world. The purpose of the project was to designed and developed Data warehouse and generating company’s projects profile report to support management team using SSIS and SQL Studio functionalities.

Responsibilities:

Primary responsibilities include develop, organize and manage ETL processes between multiple systems, protocols and data structures. This is hands-on role with responsibilities of designing/updating the ETL code and logic along with monitoring and maintaining daily ETL operations.

The ETL processes will be leveraged to transform and transport data from multiple data sources into the data warehouse from data acquisition staging tables.

Additional ETL processes will be required to provide the data warehouse to consuming applications in conformance with data structure and mapping requirements.

ETL & SSIS - staging data from source systems and moving into operational data stores.

Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on bi weekly basis.

Responsible for working on relational database in SQL server.

Work on database modeling, including using modeling tools such as ER Studio or Erwin

Creating Unit Test Cases, OR Document, ROM and Technical Specification Documents.

Database management and performance tuning

Working with data management tools

Responsible for Development of stored procedures and other components in SQL server.

Responsibility includes working in a collaborative agile environment

Designs ETL solutions through analysis of business objectives and knowledge of available toolsets.

Created complex business logic using C# and script task.

Created Dynamic SSIS packages using complex expressions, variables and control flow components such as For Each Loop a Directory to load inbound files coming weekly.

Designed customer login to capture error messages and in the case of failure of the package.

Develops and maintains ETL processes to manage data from several internal/external systems.

Participates in unit testing and team data quality efforts.

Develop and maintain data mappings between source and destination data stores.

Ensures data quality and sound data management practices.

Maintains a solid understanding of business workflows, processes, and events and how these are captured in transactional systems.

Troubleshoots production issues, identifying root cause and implementing sound technical resolutions in a timely manner.

Worked on many Cascaded parameters in the reports using SQL SSRS 2012. Developed many Tabular Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS 2012).

Developed cubes using MS SQL Server Analysis Services 2008 (SSAS) Cubes and worked on Data Mining Models, Deploying and Processing SSAS objects.

Used TFS for Schema compare, Code Management and Deployment

Tools & Technologies:

MS SQL Server 2012, T-SQL, SSIS 2010, SSRS 2012, SSAS 2008 and TFS.

Wells Fargo Winston Salem, NC

Duration: December 2014 – July 2015

Role: Sr. Business Intelligence Developer/ Sql Developer

Job Description:

Wells Fargo & Company is an American multinational banking and financial services holding company. The purpose of this project is to develop applications to integrate data from different data sources to destination databases and generate different kinds of reports using SSRS for inter user’s.

Responsibilities:

●Planned, defined and designed data based on business requirement and provided documentation.

●Actively participated in gathering Business Requirements and System Specification. Participated in implementing the logical design to the physical design by creating tables.

●Analyzed the existing data and performed the appropriate changes from SQL Server 2008 to SQL Server 2014 by following the Normalization standards to maintain data consistency and by performing data validation.

●Involved in the design of new schema, new tables, field definitions and mappings, stored procedures, views, indexes.

●Created SSIS Packages by using advance transformations (i.e. Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate) and also used Custom components such as Audit on Pre-Execute, Audit On Post-Execute, Custom Email Task and Statistics Logging Component.

●Created Dynamic SSIS packages using complex expressions, variables and control flow components such as ForEach Loop, For Loop to loop over a Directory to load inbound files coming daily.

●Prepared the Migration document showing the paths for input and output files, configuration files, table scripts, stored procedures and SSIS packages.

●Tested, Cleaned and Standardized Data to meet the business standards using Fuzzy and Exact lookups and String manipulations.

●Enforced the Business Rules to filter bad data from the system by using Complex T-SQL Statements, and implemented various Constraints and Triggers for Data Consistency.

●Responsible for creating the reports based on the requirements using SSRS 2008.

●Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services (SSRS).

●Created different type of reports which include: Cross-tab, Conditional, Sub report, Drill-down and Parameterized and deployed and scheduled Reports in Report Manager using SSRS to generate all daily, weekly, monthly and quarterly Reports.

●Monitoring performance and optimizing SQL queries for maximum efficiency

●Developed reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS

●Deployed and upload the SSRS reports to SharePoint Server for the end users and Involved in Enhancements and modifications

●Administrated the created Reports by assigning permission to the valid user for executing the reports.

●Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS

●Developed SSIS packages using Fuzzy Look Up and Fuzzy Grouping for data cleansing purpose.

●Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.

●Developed Unit Test Plans for SSIS packages for checking the functionality of each component.

●Modified the existing SSIS packages to meet the changes specified by the users.

Tools & Technologies:

MS SQL Server 2012/2008 R2, T-SQL, SSIS, SSRS, Business Object 3.1, Oracle 11g, ODBC, Microsoft Excel

BCBS Detroit, MI

Duration: January 2014 – November 2014

Role: Sql developer/BI Developer/Data Modeler

Job Description:

BCBS is leading health insurance provider company in US. The project was to load data from heterogeneous sources to merge into the already existing Data warehouse where they have all information regarding Patients and services they provide.

Responsibilities:

●Designed SSIS packages to Extract data from different sources like SQL server 2008, MS Excel, MS Access, DB2 and transform and then load into Dimension and Fact tables in Data Warehouse using SSIS.

●Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.

●Interact with the Enterprise Data Warehouse team to facilitate and document the data mapping to the Reporting SQL Server environment.

●Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report, Analytical Cube or an Excel pivot table

●Produced operational reports in SSRS 2008 i.e. drill-down, drill-through, dashboard and matrix reports.

●Provided design, implementation and maintenance for custom reports and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS.

●Converted manual reports pasted together into parameter driven stored procedures to be used with Microsoft Reporting Services 2008.

●Created SSRS Data Model projects using Microsoft Visual Studio 2008 and using Report Builder for report server to create reports.

●Responded to ad hoc requests and special projects that require immediate attention while at the same time maintaining deadlines on existing requests.

●Worked with project manager and technical leads for resolution of technical issues.

●Defined appropriate measure groups and KPIs & deployed cubes.

●Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.

●Worked on formatting SSRS reports using the Global variables and expressions.

●Created parameterized reports, Drill down and Drill through reports using SSRS.

●Diagnoses and resolved data mart access and performance issues

●Responsible for the creation and maintenance of Analysis Service objects such as Cube, Dimensions, MDX queries, and KPI’s.

Tools & Technologies:

MS SQL Server 2012/2008 R2, T-SQL, SSIS, SSRS, SSAS, Erwin 7.2, Microsoft Access, Oracle 10g

PNC financial Group Pittsburg, PA

Duration: July 2012 – December 2013

Role: Senior MS SQL Server/SSIS/SSRS Developer/ Data Modeler

Job Description:

This project was to design, create, and administer the data from Oracle and Ms Access 2007 to SQL Server 2012 by creating various SSIS Packages, to be used for generating different reports depending on the business requirements.

Responsibilities:

●Worked with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.

●Responsible for creating database objects like Views, Store Procedure, Triggers, Functions etc. using T-SQL 2012/2008 to store data and to maintain database efficiently.

●Used ETL to implement the SCD transformation, to maintain historical data in data warehouse. Applied various data transformations like Data Conversion, Multicasting, Conditional Split, Derived column in SSIS.

●Developed and deployed data transfers packages using SSIS 2012/2008, also maintained the jobs running on Servers.

●Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Staging DB to Data warehouse and Data marts.

●Wrote SSIS Packages to migrate user’s logins, stored procedures, and functions.

●Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.

●Deploying, Testing and Scheduling SSIS packages using SQL Agent.

●Developed Custom Functions, Manual Running Totals and Complex Formulas for reports used calculations, sorts, filters and sections to enhance data presentation in reports.

●Created many Cascaded parameters in the reports using SQL SSRS 2012/2008. Developed many Tabular Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS 2012/2008).

●Highly involved in automating reports generated weekly and monthly basis for the client and business sales teams.

●Worked with production control team to deploy code and for schedule run in both staging while testing and production. Responsible for providing 24/7 on-call production support for daily job and ETL loads.

●As in development team, worked with DBA teams for database update and system restarts.

Tools & Technologies:

MS SQL Server 2012/2008 R2, T-SQL, SSIS, SSRS, Win 2003 Advanced Server, Erwin v7.2,

Barclays US Card Wilmington, DE

Duration: October 2011 – July 2012

Role: MS SQL Server Developer/SSIS/SSRS Developer/data modeler

Job Description:

Barclays is a universal bank and is organized within two business clusters: Corporate and Investment Banking and Wealth and Investment Management and Retail and Business Banking. The project involved designing a new database schema and migrating databases to Production environment, modifying database structures, providing support and guidance to operational models by checking for data quality and its consistency.

Responsibilities:

●Planned, Defined and Designed data based on business requirement and provided documentation.

●Gathered data and documenting it for further reference.

●Designed Database using Erwin data modeler.

●Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Cache Transform, Conditional Split and Derived column etc.

●Developed SSIS Packages using Look Up Values & implementing rules provided by Business in the mapping document.

●Developed SSIS packages using Fuzzy Look Up and Fuzzy Grouping for data cleansing purpose.

●Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.

●Developed Unit Test Plans for SSIS packages for checking the functionality of each component.

●Modified the existing SSIS packages to meet the changes specified by the users.

●Trained on building Conceptual, Logical and Physical data model.

●Created the conceptual model for the data warehouse with emphasis on insurance (life and health)

●Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model.

●Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on Daily basis.

●Reviewed the conceptual EDW (Enterprise Data Warehouse) data model with business users

●Created the Load packages for loading the CSV files from DB2 into SQL Server using SSIS 2008.

●Generated parameterized reports, sub reports, tabular reports using SSRS-2008.

●Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.

●Generated Sub-Reports, Drill down reports, Drill through reports and parameterized reports using SSRS 2008.

●Created reports to retrieve data using Stored Procedures that accepts parameters.

●Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard

●Responsible for Monitoring and Tuning Report performance.

●Configured the report viewing security for various users at various levels using Report Manager

●Scheduled report and exported in PDF format.

Tools & Technologies:

MS SQL Server 2008, SSRS, T-SQL, SSIS, Win 2003 Advanced Server, Erwin v7.2.

McKesson Health Solutions Newton, MA

Duration: January 2010 – September 2011

Role: SQL Developer/BI Developer/Data Analyst

Job Description:

McKesson health solutions are the leading company in the healthcare sector in the United State. The project was mainly on migration data by utilizing SSIS from database sources like Excel, MS Access, Flat File to MS SQL server and Generate Report using SSRS.

Responsibilities:

●Created SSIS package to export and import data from SQL Server to Access, text and Excel file. Used Event Handlers for Exception Handling in SSIS packages

●Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services

●Modified the existing SQL queries according to the requests and executed them to check the performance.

●Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes having Star/ Snowflake schemas using Dimensional data Modeling principles in SSAS

●Created data flow model using MS Visio

●Used SQL Server Profiler to trace the slow running queries and the server activity

●Scheduled Jobs and Alerting using SQL Server Agent

●Created stored procedures, views, triggers, user defined functions to incorporate the flow of business

●Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis

●Designed, Developed and Deployed reports in MS SQL Server environment using SSRS

●Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS

●Created SSRS reports to retrieve data using Stored Procedures that accept parameters

●Performed daily tasks including backup and restore by using MS SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor

●Documented all the new procedures, troubleshooting issues and solutions, Enhancement and changes in Daily and monthly running processes, and maintain the database for future reference

Tools & Technologies:

MS SQL Server 2008, SQL Server Reporting Services 2008, SQL Server Integration Services 2008, SQL Server Analysis Services 2008, Windows 2003/2000 and T-SQL.

Regions Financial Corporation, Birmingham AL

Duration: November 2008 – December 2009

Role: MS SQL Server Developer/ETL Developer

Job Description:

Regions Financial Corporation is a financial services company; the company provides retail and commercial banking, trust, securities brokerage and insurance products and services.

It provides benefits of modern IT infrastructure with powerful reporting capabilities via SSRS. Power User will leverage from analytics capabilities offered by tool in excel 2007 generate metrics/KPIs for strategic and corporate management whereas other business users will use canned reports for their operational analysis.

Responsibilities:

●Designing Data Model and implementing changes in the earlier phase of the project to accommodate business logic and dynamic nature of the front-end application.

●Designed and modeled Microsoft SQL Server 2005 data warehouse and data marts, including the modification of existing Microsoft SQL Server 2000 data warehouse and data marts.

●Used SSIS packages to roll our data to Live Tables and to Processing Database.

●Developed database objects such as SSIS Packages, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager

●Configure the SSIS Package for run time Parameters and Configured file

●Develop the Documents for Logging/Error Handling for SSIS Packages

●Integrate the SSIS package, converting all existing DTS packages of MS SQL 2000 to 2005 by adding extra SSIS task.

●Schedule Package using SQL Server Job for weekly/monthly basis.

● Used Checkpoint for avoiding re-executes Package from the first task.

●Develop the Slowly Changing Transformation to maintain the Historical Data.

●Handling the errors during data moving and Sequencing the task as per requirements.

●Perform T-SQL tuning and optimizing queries for Reports, which take longer, time in execution SQL Server 2005.

●Migrated some Crystal reports to SSRS reports manually

●XML result set from Stored Procedures to create custom XML file for third party data export.

●Extensive work on SSIS creating all the interfaces between front end application and SQL Server 2008 database, then from legacy database to SQL Server Database and vice versa.

Tools & Technologies:

SSIS, MS SQL Server 2008, Windows 2003



Contact this candidate