Data Ssis

PROFESSIONAL SKILLS

Microsoft Certified MSBI Lead with 13 + years of experience in various Retail, Educational, Energy Utilities and financial industries.

Experience in Data warehousing tools like SSIS,SSRS,SSAS

Experience in cloud -Microsoft azure

Experience in PowerBI Reports

Experience in Data Marts, Data warehousing, OLAP using the Dimensional Modeling techniques such as Star schema and Snow flake schema, Fact and Dimension Tables using Multi-Dimensional Analysis Services (SSAS).

Experience in Data modelling for the enterprise data warehouse.

Executed end-to-end data quality controls and reports.

Developed and maintained end-to-end data quality controls and reports, including new metrics and control models in accordance with business/regulatory requirements.

Experience in framing ETL jobs and design

Experience in Performance tuning in database level, ETL and analytical model by following approaches like Partitioning, indexing, etc.

Experience in various software programming and record management tools.

Experience with using of agile methodology for Project management.

Good experience in delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.

Experience in Big data platform.

Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).

Developed Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model using Report Builder.

Expertise in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).

Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS 2012/2008R2/2008.

Experience in creating SSIS package to load data from Flat Files to SQL Server using various types of transformations like Lookup, Multicast, Derived Columns, Condition Split, Term Extraction, Aggregate, for transferred data modifications and dataflow tasks, for loop container, for each loop and sequence container.

Created different types of reports such as Conditional, Drill-down, Summary and Sub reports, and formatted them and Performed unit testing at various levels.

Defining data warehouse (star and snow flake schema), fact table, cubes, dimensions, partition and aggregation using SQL Server Analysis Services.

Experience in migration of SSRS reports from SQL 2005toSQL 2008.

Experience in Microsoft APS parallel Datawarehouse(PDW) and Alteryx.

Good experience in delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.

EDUCATION

Bachelor of Engineering in Computer Science affiliated to Anna University Chennai, India passed out in 2005.

Diploma in Computer Technology affiliated to Technical education board, Kerala, India in 2002.

TECHNICAL SKILLS

ETL tools : SSIS, Alteryx

Reporting Tools : SSRS, Crystal reports, PowerBI

Programming Languages : C#, VB, VB.NET, UNIX

Databases : Sql Server, Oracle, Netezza

Utilities : putty Session, Jira, Service Now, Rally

Version Control Tools : TFS, ACCUREV, GITHUB

WORK EXPERIENCE

Solution Lead/Architect – Ford Motor Company, Michigan

From July 2018 to present

MS SQL Server/ SSIS/ SSRS/SSAS/Microsoft APS/Alteryx

Work on to Global Order to Delivery (GOTD) program with Global Order Bank and Order Analytics Repository (OAR) applications.

Provide Application Development and Support for database and service capabilities that permit the retention of key vehicle order management and order generation data.

Wok with the data will be used to analyze order generation capabilities, permit the visualization of key measures, provide inventory information for unique marketing and sales customer experiences, and to identify opportunities for business and technical improvements.

Develop and support Microsoft SQL server 2012 or later and SSIS.

Responsible for Start Schema design and implementation.

Use SQL Server Integration Services (SSIS), including Package Automation across environments, Package Configuration encryption, Logging and Error handling, Microsoft SQL Server Analytics development experience, Implementation of Relation data warehouses.

Responsible for troubleshooting in analytics environment.

Created Database Objects – Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.

Alone designed, developed and deployed the project and also developed and published the reports based on the business needs.

Supported several projects by recreating packages, troubleshooting failures etc.

Created SSRS Reports for reconciliation purpose.

Worked on creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).

Deployed and Generated SSRS reports using the Reporting Services and Report Manager.

Design and development of SSAS cubes.

Senior Technology Specialist – Pearson Education, New Jersey

From January 2018 to July 2018

MS SQL Server/ SSIS/ SSRS/SSAS

Requirement Analysis and Preparation of Specification document (HLD, DLD).

Managed requirements and design phase towards identifying mutually agreed solutions with technical and business partners

Developed and managed Integration platforms for the various Educational source data.

Extraction, transformation and load of Murex DataMart data into Integration platform using SSIS

Implemented ETL frame work for SSIS in marketing strategy Management platforms and data model design.

Developed Integration Platform tool using SSIS for multiple source and target systems.

Data modelling.

Creation of Microsoft SQL server SQL Procedures.

Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.

Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task.

Used Script Tasks for complex data transformation tasks.

Elicit the new/Changed Requirements by coordinating with the business.

System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.

Used various SSIS tasks such as Conditional Split, Derived Column, Lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse

Technology Lead– Direct Energy, Newjersey from May 2016 to December 2017

MS SQL Server/ SSIS/ SSRS/SSAS/PowerBI

Analyze & understand the requirements.

Data modelling.

Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.

Worked on SSAS storage and partitions, and Aggregations, calculation of queries with MDX, developing reports using MDX and SQL.

Defined cubes, dimensions, user hierarchies, aggregations in an OLAP environment (SSAS).

Designed Cube partitioning and incremental synchronization for SSAS cubes.

Used various SSIS control flow tasks such as Execute SQL task, File system task, for each loop, and sequence containers, send-mail task.

Designed reports, Graphs and deployed reports to web applications using SSRS.

Developed Power pivot, Power View reports based on the requirements.

Created SharePoint site and published reports on SharePoint site.

Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report service (SSRS).

Worked in Microsoft azure cloud environment.

Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes using dimensional modeling standards in SQL server.

Implemented SSAS Cubes, Facts and Dimension tables to perform analysis services.

Gathered report requirements and determined the best solution to provide the results in a Reporting Services.

Designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).

Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.

Created Parameterized reports and Linked reports with thorough knowledge of reporting service.

Generated various reports with drilldowns, calculated members, dropdowns from the cubes

Experience in PowerBI reports.

Technology Lead – MetLife Insurance at offshore location (Cognizant, India) from March 2014 – April 2016

MS SQL Server/ SSIS/ SSRS/SSAS

Lead to the MSBI Project

Coordinated and designed data flow capturing.

Risk assessment with varying loads.

Participated in design sessions and provided value feedback and suggestions to improve the design.

Organizational standards maintainability and documentations,

Analyzing issues or defects encountered in production data and reporting.

Setting new protocols and their implementation for Defect Prevention in deliverables.

Major responsibilities include getting requirements from the user, writing stored procedures for reports and developing reports using SSRS. Maintaining proper documentation of the reports for future reference.

Involved in writing complex stored procedures to get data from database.

Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.

Developed unlinked, on-demand sub reports and linked sub reports using shared variables and complex reports like cross-tab, drill down and hierarchical reports.

Gathered business requirements from business users and clients to develop various reports.

Migrated data from Heterogeneous data sources (Excel, Flat File and CSV file) to centralized SQL server database using SQL server integration services (SSIS) to overcome transformation constraints.

Used various SSIS control flow tasks such as Execute SQL task, File system task, for each loop, and sequence containers, send-mail task.

Technology Analyst – Mothercare-UK at offshore location (Infosys, India) from January 2012 – February 2014

MS SQL Server/ SSIS/ SSRS/SSAS

Elicit the new/Changed Requirements by coordinating with the business.

Identify the reusable components, Database Design.

Prepare and Review the Design artifact.

Conduct Code & Functional reviews for the team.

Created components, tools, techniques, methods and procedures used in an on On-Line Analytical Processing (OLAP) environment

For accessing and translating data into understandable and usable business information using SSAS.

Carried out Production support which involves the daily data loads and report generations.

Fix production faults and meet the support SLA’s for fixing the production issues.

Implemented the Error handling in the Stored Procedures and also Modified existing stored procedures according to the requirement.

Created Database Objects – Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.

Used Joins and sub-queries for complex queries involving multiple tables from different databases.

Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Technology Analyst – Ralph Lauren-USA at offshore location (Infosys, India) from January 2011 – December 2011

MS SQL Server/ SSIS/ SSRS/SSAS

Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.

Wrote queries for Drill down reports to get the dataset required to build the report and Created Tablix, Drill down and drill through reports, multi value parameter reports.

Identified and included report parameters for parameterized report.

Wrote complex SQL queries and procedures to create reports using SSRS from the relational database.

Generated monthly and quarterly reports as bar charts for the management using different techniques like Data Filtering, Adding Interactivity, Deploying Reports to report server using SSRS.

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

Administered user, user groups, and scheduled instances for reports in Tableau.

Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL.

Configured the report server and generated the report models for user interactions.

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

Developed and maintained system documentation, diagrams and flowcharts.

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

Tested and analyzes each component/phase of the systems development life cycle including the requirements, design and development.

Elicit the new/Changed Requirements by coordinating with the business.

Identify the reusable components, Database Design.

Prepare and Review the Design artifact.

Software Engineer – BBTC at offshore location (Ismart, India) from October 2006 – December 2010

MS SQL Server/ SSIS/ SSRS

Developing User reports using Crystal reports

Database Maintenance

Developing complex stored procedures in SQL server.

Migration of Sql server 2000 to 2005

Project Implementation and Support

Sustained Process Compliance throughout the Project

Developed, deployed, and monitored SSIS Packages.

Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.

Unit testing and SIT

Performance Tuning

Create user guide for end user.

CERTIFICATIONS

Microsoft Certified Solution Expert(MCSE)

70-461: Querying Microsoft SQL Server 2012/2014

70-462: Administering Microsoft SQL Server 2012/2014 Databases

70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

70-466: Implementing Data Models and Reports with Microsoft SQL Server

70-467: Designing Business Intelligence Solutions with Microsoft SQL Server

Domain Certifications

RETL Basics of CPG Retailing Certification

RETL Basics of Transportation and Logistics Certification

REWARDS AND RECOGNITION

Awarded with “Exceeds all expectations” Award in Cognizant 2016 for Excellency globally.

Received “Certificate of Excellence” award from CTS-Direct energy.

Received outstanding performer award from Infosys

Conducted training on SSIS, SSRS, and SSAS for Cognizant and trained almost 200 plus associates.

LinkedIn Profile: www.linkedin.com/in/geo-george-11512a18

Contact this candidate