SARABJEET SINGH

PROFESSIONAL SUMMARY:

●Over 14 years of IT experience in Sr. ETL/BI Developer, Design, Development, System Analysis and Support of MS SQL Server 2016,2014,2012,2008 R2, 2005, 2000, 7.0, MS-Access in Development, Test, Production and Replication & Cluster environments.

●Experience in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SSRS, Power BI for developing reports of different type.

SQL Server Reporting Services (SSRS).

●Strong development skills with Azure Data Lake, Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage Explorer

●Experience managing Big Data platform deployed in Azure Cloud

●Implemented Copy activity, Custom Azure Data Factory Pipeline Activities for On-cloud ETL processing

●Knowledge of Relational Database Management systems and Data Modeling.

●Worked on configuring Service Broker for message Queuing system.

●Experience in Database Backup, Logshipping, Replication Recovery and Disaster Recovery procedures.

●Experience with Data Transformation Services, Batch processes, Import/Export and Backup/Restore.

●Experience in Performance Tuning, Query Optimization, Client/ Server Connectivity, Database Consistency Checks using DBCC Utilities.

●Hands on experience in Troubleshooting database issues.

●Use SQL Azure for maintaining application databases (Storage, Container).

●Experience in writing and debugging Stored Procedures, Views, triggers, Functions using T-SQL Scripts

●Extensive experience in creating business, functional and technical documentation.

●Excellent verbal, written communication and presentation skills, problem solving and conflict resolution skills.

●Maximum Team Handle on Onsite to Offshore range between 10 -35 including Manager as Team Lead.

●Experience on working with .Net and Java Applications.

TECHNICAL SKILLS:

RDBMS: MS SQL Server 6.5, 7.0,2000, 2005 and 2008, 2008 R2,2012,2014,SQL AZURE DB2, MS Access 2000/97and Oracle.

Programming: C, C#, C++, PL/SQL, T-SQL, Java, Java Script, COBOL, ASP, HTML

Perl script, and Visual Basic, PowerShell, PowerB1, SQL Azure.

Clouding

Operating Systems: Windows 2000, Workstation, Windows NT/XP/95/98, MS DOS, UNIX

Applications: MS Office, MS Visio, Dream Weaver

Tools: Erwin, NetIQ, TFS, Bitbucket, GitHub, Clustering, Remedy, Attunity(Qlik Replicate), NT Performance monitor/System monitor, TSQL, SQL Profiler, SQL Query Analyzer, OSQL, JIRA

Certifications: Microsoft Certified Professional (MCP)

PROFESSIONAL EXPERIENCE:

Nov 2019 to Present

UPS Wayne New Jersey

Sr SQL Developer/BI Developer/Sr PowerBI-Developer/Lead

●Use Power BI tools to create Data Sets for Reports like Matrix, Tabular, Drilldown, Navigational, Parameterized, sub reports, pie -charts.

●Generated score cards with executive summary dashboards to display performance monitoring measures with

●Delivered on-demand reports in multiple rendering formats with standard and data driven subscriptions.

●Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

●Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.

●Write Power QUERY for Transforming Data.

●Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.

●Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

●Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

●Use power Automate to refresh the data for the Dashboard.

●Implemented Copy activity, Custom Azure Data Factory Pipeline Activities

●Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell

●Creating SSIS package for loading data from different Data sources (MS Access, Excel SQL 2000).

●Building developing Dynamic SSIS package and writing expression to for dynamic parameter.

●Developing SSIS package for incremental and full loading of data to Data warehouse.

●Building developing Dynamic SSIS package and writing expression to for dynamic parameter.

●Developing database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.

●Modifying the existing Store procedures, Function, Triggers, CTE.

●Improving Performance of nested queries and Store procedures and other objects.

●Deployment, scheduling and Running SSIS packages on SQL server Catalog.

●Creating dynamic SSIS packages along with XML configuration file.

●Creating SSIS packages for importing data through different data sources (Excel, CSV, SQL, Oracle, Teradata).

●Use TFS for code Versioning.

●Writing PL/SQL script for retrieving data from Oracle databases.

●Developing SSIS by using Merge join, Conditional Split, pivot or Unpivot task to output the data by using complicated logics.

●Writing Expression for Dynamic parameter generated during run time of SSIS packages.

●Security of SSIS packages.

●Created Databases to load data from Azure storage blob to Azure SQL, to load from web API to Azure SQL and scheduled web jobs for daily loads

●Worked on creating different activities for pipeline in data factory for processing and loading the data .

●Worked on adding new columns or modifying the existing data types in the data factory for activities.

●Worked on publishing the jobs on the server in the Azure sql server.

●Worked on importing or migrating databases and object to the sql server dataware house in Azure sql server.

●Used T SQL for creating dataset, Calculations,Derived Columns in the report.

●Used Dax for creating cards and building Bar graphs reports

●Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.

Sept 2018 to Sept 2019

DHR Alabama

Sr SQL Developer/BI Developer/Sr PowerBI-Developer/Lead

●Use Power BI tools to create Data Sets for Reports like Matrix, Tabular, Drilldown, Navigational, Parameterized, sub reports, pie -charts.

●Generated score cards with executive summary dashboards to display performance monitoring measures with Tableau.

●Delivered on-demand reports in multiple rendering formats with standard and data driven subscriptions.

●Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

●Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.

●Write Power QUERY for Transforming Data.

●Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.

●Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

●Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

●Implemented Copy activity, Custom Azure Data Factory Pipeline Activities

●Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell

●Created Databases to load data from Azure storage blob to Azure SQL, to load from web API to Azure SQL and scheduled web jobs for daily loads

●Worked on creating different activities for pipeline in data factory for processing and loading the data .

●Worked on adding new columns or modifying the existing data types in the data factory for activities.

●Worked on publishing the jobs on the server in the Azure sql server.

●Worked on importing or migrating databases and object to the sql server dataware house in Azure sql server.

●Used T SQL for creating dataset, Calculations,Derived Columns in the report.

●Used Dax for creating cards and building Bar graphs reports

●Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.

●Implemented code check-in/check-out and managed multiple versions of complicated code within TFS.

●Error Handling, Package Logging and Configuration of packages

●Use TFS for code Versioning.

●Gathering Business Requirements, understanding workflow, Impact Analysis and Technical Specification Documentation.

●Writing T-SQL script for databases and tables.

●Building developing Dynamic SSIS package and writing expression to for dynamic parameter.

●Developing database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.

●Modifying the existing Store procedures, Function, Triggers, CTE.

●Improving Performance of nested queries and Store procedures and other objects.

●Creating SSIS package for loading data from different Data sources (MS Access, Excel SQL 2000).

●Building developing Dynamic SSIS package and writing expression to for dynamic parameter.

●Scheduling and deploying the packages on SQL Server.

●Use power Automate to refresh the data for the Dashboard.

●Creating Custom and Matrix reports as well Pie charts by SSRS.

●Involved in Error Handling, Package Logging and Configuration of packages

●Create database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.

●Data cleansing, Extraction, Transformation and Loading of Data through SSIS packages

●Creating parameterized as dynamic reports from cubes using Expressions.

●Deployment, scheduling and Running SSIS packages on SQL server.

●Creating DTS Packages to import & export data from text files MS SQL Server databases

●Creating cubes, performance of cubes for MOLAP storage option.

●Involved in writing MDX query in SSAS management Studio for Slicing and Dicing of Cube.

●Involved in Writing MDX query for creating Datasets for SSRS reports.

●Creating Expressions and Dynamic variables in SSIS.

●Creating parameterized as dynamic reports from cubes using Expressions.

●BCP in and out of data from one environment to another environment.

●Use TFS for code Versioning.

●

Nov 2017 to August 2018

KPMG New Jersey

Sr SQL Developer/BI Developer/PowerBI/Lead

Description: This project is to implement daily incremental Pulling of all the business users data of Everest like Contract,Submission, Claims, Accounting Transaction Data from Upstream system to downstream system by using incremental ETL and Data is consumed by different users for generating different Claim reports through Power BI and SSRS tool.

Responsibilities:

●Gathering Business Requirements, understanding workflow, Impact Analysis and Technical Specification Documentation.

●Dimension Modeling design. Design Dimension and Fact Tables Especially Star Schema for creating Fact and Dimension tables.

●Developing SSIS package for incremental and full loading of data to Data warehouse.

●Create database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.

●Deployment, scheduling and Running SSIS packages on SQL server Catalog.

●Creating dynamic SSIS packages along with XML configuration file.

●Creating SSIS packages for importing data through different data sources (Excel, CSV, SQL, Oracle, Teradata).

●Use TFS for code Versioning.

●Worked on AWS pipelines to import data from csv and excel files to AWS sql server.

●Worked on processing and transforming the data in AWS sql server environment.

●Worked on deployment of new objects from source Dev server to Production server in AWS clouding environment.

●Writing PL/SQL script for retrieving data from Oracle databases.

●Building developing Dynamic SSIS package and writing expression to for dynamic parameter.

●Developing database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.

●Modifying the existing Store procedures, Function, Triggers, CTE.

●Improving Performance of nested queries and Store procedures and other objects.

●Developing SSIS by using Merge join, Conditional Split, pivot or Unpivot task to output the data by using complicated logics.

●Writing Expression for Dynamic parameter generated during run time of SSIS packages.

●Security of SSIS packages.

●Use Power BI tools to create Data Sets for Reports like Matrix, Tabular, Drilldown, Navigational, Parameterized, sub reports, pie -charts.

●Generated score cards with executive summary dashboards to display performance monitoring measures with Tableau.

●Delivered on-demand reports in multiple rendering formats with standard and data driven subscriptions.

●Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

●Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.

●Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.

●Utilized Power Query in Power BI to Pivot and Unpivot the data model for data cleansing and data massaging.

●Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

●Deployed report from Development to Production environment through TFS.

●Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.

●Implemented code check-in/check-out and managed multiple versions of complicated code within TFS.

●Error Handling, Package Logging and Configuration of packages

●Use TFS for code Versioning.

●PL/SQL code using TOAD for retrieving data from Oracle.

Environment:

MS SQL SERVER 2016 R2, 2012, MS SQL SERVER 2008 R2, SQL Server 2005, Oracle, MS SQL Server 2005/2008, SSIS, PowerBI, Microsoft Visual Studio 2008, SQL Profiler, Microsoft Visio, MS Office 2003, Excel 2003, Windows NT/2003.

Nov 2016 to Oct 2017

GE INTEL Care Innovations

Louisville Kentucky

Sr SQL Developer/BI Developer/Lead

Description: This project is implemented to provide service to all the health care clients through US. The process is to monitor all the patients remotely and bring their health details to internal system by Bluetooth which can access by the Clinicians to start giving the instruction to patients based on the report generated.

Responsibilities:

●Writing Expression for Dynamic parameter generated during run time of SSIS packages.

●Security of SSIS packages.

●Developed Dashboards with different Charts and Slicing and dicing of report.

●Deployed report from Development to Production environment through TFS.

●Formatted dashboards, multiple chart types, trends, and KPIs with Power View to support analyses.

●Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling.

●Building developing Dynamic SSIS package and writing expression to for dynamic parameter.

●Developing database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.

●Modifying the existing Store procedures, Function, Triggers, CTE.

●Improving Performance of nested queries and Store procedures and other objects.

●Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.

●Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.

●Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line better business analysis

●Optimized report performance with caches and snapshots.

●Use SQL Azure for maintaining application databases (Storage, Container). Backup using SQL BLOG.

●Error Handling, Package Logging and Configuration of packages

●Involved in writing MDX query in SSAS management Studio for Slicing and Dicing of Cube.

●Involved in Writing MDX query for creating Datasets for SSRS reports.

●Use Power BI tool to create Data Sets for different types of reports like Pie chart, Dashboard, navigational drilldown reports from different sources like CSV, EXCEL, SQL etc.

●Used DAX and TSQL for generating expressions and Results set along with derived Columns .

●Creating Expressions and Dynamic variables in SSIS.

●Creating parameterized as dynamic reports from cubes using Expressions.

Environment:

MS SQL SERVER 2014, Oracle, MS SQL Server 2005/2008, SSIS, SSRS, Power BI,Microsoft Visual Studio 2012, SQL Profiler, Microsoft Visio, MS Office 2003,Excel 2003, Windows NT/2003.

Oct 2015 to Oct 2016

Bank of Tokyo, NYC

Sr SQL Developer/BI Developer/Lead

Description: This project was implemented to bring all the security data (Bonds, Mutual Funds), Position and Stocks, Repo, Derivatives, Call and Put on, Trading, a central repository to build DataMart’s for customized and Dashboard reporting. This enhances the reports rendering performance time both for existing and, Reports. The Bank Business was critically involved in merger acquisition of Union Bank which involved in integrating their Data Model to MUFS existing Model.

Responsibilities:

●Involved in Gathering Business Requirements, understanding workflow, Impact Analysis and Technical Specification Documentation.

●Migration from Oracle to SQL Server 2012.

●Involved in writing T-SQL script for databases and tables.

●Building developing Dynamic SSIS package and writing expression to for dynamic parameter.

●Developing database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.

●Modifying the existing Store procedures, Function, Triggers, CTE.

●Improving Performance of nested queries and Store procedures and other objects.

●

●Data Migration from Oracle to SQL Server 2008R2.

●Create database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.

●Involved in creating SSIS package for loading data from different Data sources (MS Access, Excel SQL 2000).

●Building developing Dynamic SSIS package and writing expression to for dynamic parameter.

●Scheduling and deploying the packages on SQL Server.

●Creating cubes, performance of cubes for MOLAP storage option.

●Involved in writing MDX query in SSAS management Studio for Slicing and Dicing of Cube.

●Involved in Writing MDX query for creating Datasets for SSRS reports.

●Use Power BI tool to create Data Sets by creating power views from different sources like CSV, EXCEL, SQL ETC.

●Creating Expressions and Dynamic variables in SSIS.

●Creating parameterized as dynamic reports from cubes using Expressions.

●Creating cubes, performance of cubes for MOLAP storage option.

●Involved in writing MDX query in SSAS management Studio for Slicing and Dicing of Cube.

●Involved in Writing MDX query for creating Datasets for SSRS reports.

●Use Power BI tools to create Data Sets by creating power views from different sources like CSV, EXCEL, SQL ETC.

●Creating Expressions and Dynamic variables in SSIS.

●Creating parameterized as dynamic reports from cubes using Expressions.

●Error Handling, Package Logging and Configuration of packages

●Scheduling and deploying the packages on SQL Server.

●Use TFS for code Versioning.

●Involved in creating Custom and Matrix reports Pie charts as well by SSRS.

●Developed Parameterized, Navigational, Sub reports, Tabular Reports using dataset created from OLTP Database to Cubes.

●Involved in creating both Data and Dimensional Modelling for designing Databases for OLTP and OLAP system.

●Involved in improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.

●Scheduling and working on performance of reports.

●Involved in implementing the data model using .Net Applications.

Nov 2014 to Sep 2015

CIT, New Jersey

Sr SQL Developer/BI Developer

Description: This project was implemented for wide range of strategic transactions, including mergers, acquisitions, divestitures, spin-offs, asset purchases and dispositions, joint ventures, corporate defense assignments, restructurings and reorganizations. The CIT business is a critical component of the firm's globally integrated investment banking model.

Responsibilities:

●Writing T-SQL script for databases and tables.

●Building developing Dynamic SSIS package and writing expression to for dynamic parameter.

●Developing database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.

●Modifying the existing Store procedures, Function, Triggers, CTE.

●Improving Performance of nested queries and Store procedures and other objects.

●Creating SSIS package for loading data from different Data sources (MS Access, Excel SQL 2000).

●Data cleansing, Extraction, Transformation and Loading of Data through SSIS packages

●Creating parameterized as dynamic reports from cubes using Expressions.

●Deployment, scheduling and Running SSIS packages on SQL server.

●Building developing Dynamic SSIS package and writing expression to for dynamic parameter.

●Scheduling and deploying the packages on SQL Server.

●Creating Custom and Matrix reports as well Pie charts by SSRS.

●Involved in Error Handling, Package Logging and Configuration of packages

●Creating cubes, performance of cubes for MOLAP storage option.

● Use TFS for code Versioning.

●Used Attunity(Qlik Replicate) for replication.

●Involved in writing MDX query in SSAS management Studio for Slicing and Dicing of Cube.

●Involved in Writing MDX query for creating Datasets for SSRS reports.

●Use SSRS tools to create Data Sets by creating power views from different sources like CSV, EXCEL, SQL ETC.

●Creating Expressions and Dynamic variables in SSIS.

●Creating parameterized as dynamic reports from cubes using Expressions.

●Create database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.

●Creating DTS Packages to import & export data from text files MS SQL Server databases

●BCP in and out of data from one environment to another environment.

●Production support for all kind of technical issues.

●Improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.

Jan 2014 to Oct 2014

Barclays Capital, Jersey City

Sr SQL Developer/BI Developer

Description: This project was based on Wholesale Credit Analytics and Solutions team (WCAS) and developing a new platform to aid development of wholesale Credit Risk Models including BASEL, CCAR forecasting, Loan Loss Reserves, Economic Credit Capital and ratings and also to provide strategic insights into portfolio performance and analytics. The platform will host all TCP credit data, Derivatives, AFS and Margin Lending data inclusive of all reference data, financial data, legal agreements and other external data.

Responsibilities:

●Gathering Business Requirements, understanding workflow, Impact Analysis and Technical Specification Documentation.

●Writing T-SQL script for databases and tables.

●Creating SSIS package for loading data from different Data sources (MS Access, Excel SQL 2000).

●Building developing Dynamic SSIS package and writing expression to for dynamic parameter.

●Scheduling and deploying the packages on SQL Server.

●Creating Custom and Matrix reports as well Pie charts by SSRS.

●Involved in Error Handling, Package Logging and Configuration of packages

●Create database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.

●Data cleansing, Extraction, Transformation and Loading of Data through SSIS packages

●Creating parameterized as dynamic reports from cubes using Expressions.

●Deployment, scheduling and Running SSIS packages on SQL server.

●Creating DTS Packages to import & export data from text files MS SQL Server databases

●Creating cubes, performance of cubes for MOLAP storage option.

●Involved in writing MDX query in SSAS management Studio for Slicing and Dicing of Cube.

●Involved in Writing MDX query for creating Datasets for SSRS reports.

●Creating Expressions and Dynamic variables in SSIS.

●Creating parameterized as dynamic reports from cubes using Expressions.

●BCP in and out of data from one environment to another environment.

●Use TFS for code Versioning.

●Production support for all kind of technical issues.

●Improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.

●Created the backup schedule for production, test and development servers.

●Involved in creating Table Partioning for large tables by Partition Schemas and Partition Functions

●Involved in creating indexes (Clustered and Non-Clustered) for improving the server performance

May 2013 to Dec 2013

Ohio Department of Insurance, OH

Sr SQL Developer/BI Developer

Responsibilities:

●Building developing Dynamic SSIS package and writing expression to for dynamic parameter.

●Writing T-SQL script for databases and tables.

●Creating SSIS package for loading data from different Data sources (MS Access, Excel SQL 2000).

●Scheduling and deploying the packages on SQL Server.

●Error Handling, Package Logging and Configuration of packages

●Create database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.

●Designing Dimensional modelling specially Star Schema for creating Fact and Dimension tables.

●Creating Attributes and Dimension hierarchy in cube

●Creating Cubes and Hierarchies between different attributes and Dimension.

●Creating parameterized as dynamic reports from cubes using Expressions.

●Writing MDX query against cubes to browse data and creating reports from Cubes.

●Writing Calculations, named sets, KPI, Translation for cubes to use them for reports and browsing data

●Creating cubes, performance of cubes for MOLAP storage option.

●Involved in writing MDX query in SSAS management Studio for Slicing and Dicing of Cube.

●Involved in Writing MDX query for creating Datasets for SSRS reports.

●Use Power BI tools to create Data Sets by creating power views from different sources like CSV, EXCEL, SQL ETC.

●Building developing Dynamic SSIS package and writing expression to for dynamic parameter.

●Developing database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.

●Modifying the existing Store procedures, Function, Triggers, CTE.

●Improving Performance of nested queries and Store procedures and other objects.

●

●Creating Expressions and Dynamic variables in SSIS.

●Creating parameterized as dynamic reports from cubes using Expressions.

●Data cleansing, Extraction, Transformation and Loading of Data through SSIS packages

●Involved in Gathering Business Requirements, understanding workflow, Impact Analysis and Technical Specification Documentation.

●Involved in importing XML data from XML Document to SQL Server through XML Nodes and XML query.

●Involved in Deployment, scheduling and Running SSIS packages on SQL server.

●DTS Packages to import & export data from text files MS SQL Server databases

●Creating Dynamic and parameterized reports using expression and mdx query from cube.

●Writing shell scripting for UNIX data

●Custom and Matrix reports as well Pie charts by SSRS.

●Created the backup schedule for production, test and development servers.

June 2012 to April 2013

Speedway, Ohio

Sr SQL Developer/BI Developer/Lead

Description: This project was implementing to migrate all the Credit Cards accounts of consumer all over the 250 location in East coast to central repository server based in Enon Ohio. The aggregation of the total expenditure of individual customer to repay the percentage rebate to their account.

Responsibilities:

●Developing SSIS package for incremental and full loading of data to Data warehouse.

●Data cleansing, Extraction, Transformation and Loading of Data through SSIS packages by using Fuzzy looks up task

●Data Migration from Oracle to SQL Server 2008R2.

●Create database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.

●Deployment, scheduling and Running SSIS packages on SQL server.

●Creating dynamic SSIS packages along with XML configuration file.

●Creating SSIS packages for importing data through different data sources (Excel, CSV, SQL, Oracle, Teradata).

●Writing PL/SQL script for retrieving data from Oracle databases.

●Developing SSIS by using Merge join, Conditional Split, pivot or Unpivot task to output the data by using complicated logics.

●Writing Expression for Dynamic parameter generated during run time of SSIS packages.

●Security of SSIS packages.

●Use TFS for code Versioning.

●Error Handling, Package Logging and Configuration of packages

●Dimension Modeling design. Design Dimension and Fact Tables especially Star Schema for creating Fact and Dimension tables.

●Used Attunity(Qlik Replicate) for replication.

●Creating cubes, performance of cubes for MOLAP storage option.

●Involved in writing MDX query in SSAS management Studio for Slicing and Dicing of Cube.

●Involved in Writing MDX query for creating Datasets for SSRS

Contact this candidate