| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Sr. MS SQL Server ETL SSIS SSAS SSRS Developer
Email: EMAIL AVAILABLE
Phone: PHONE NUMBER AVAILABLE
PROFESSIONAL SUMMARY:
8+ years of IT experience in the development, use, analysis and management of MS SQL Server 2005/2008R2/2012/2014 databases, ETL and Business Inteligence solutions.
Extensive experience in MS SSIS 2005/2008R2/2012, Analyze and Design SSIS Packages, building cubes using SSAS, developing reports using SSRS and its different tools like SSMS, BIDS, TFS, SQL Profiler, Execution Plan and Visual Studio.
Hands on experience in dealing data from heterogeneous source systems such as Flat Files (.csv files), Excel Files, Oracle 11g/10g, MS SQL Server, IBM DB2, FTP Server and XML Source and load the data into target ODS, data marts and data warehouses.
Experience in using several control flow tasks sequence container, For Loop, For Each Loop, ActiveX Script Task, CDC task in SSIS 2012, data flow task, Bulk Insert Task, Execute SQL, File System Task, FTP Task and Script Task, Several Data Flow Transformations Look Up, Cache transformation, Checksum transformation, Conditional Split, Derived Column, Row Count, Script Component, Merge Join and Union All.
Experience in SSIS variables, transaction support feature, transaction isolation levels, precedent constraints, configuring Error Handing, Logging and Event Handling.
Experience with Package level configurations (XML Package configurations in 2008R2) and Project level configuration (managed environment variables inside SSMS 2012).
Experience with MS SQL SSIS 2012 new features including Integration Services Catalogue, execute the SSIS package through the stored procedure, SSIS_DB and ETL_Audit databases in tracking the ETL processes.
Experience in using project parameters in the SSIS 2012 project level configuration while deploying the SSIS projects to the SSIS Integration services catalogue SSIS-DB, validate, test and execute the SSIS packages before the deployment by switching to the test servers using a project parameter.
Experience in transforming the data from one server to other servers using BCP (Bulk Insert Program) and SSIS.
Extensive experience with SSIS performance tuning using counters, adjusting fast load techniques, error handling, event handling, re-running of failed packages using checkpoints, trouble shoot using break-points and other tuning techniques.
Experience in maintenance and administration of ETL processes by creating SQL Server Agent ETL jobs with multiple steps, Alerts, SQL Mail Agent, and schedule SSIS packages.
Extensive experience in developing cube based and relational based reports using SSRS.
Extensive experience in developing SSRS reports from SSAS cube by writing MDX queries and connected to SSAS linked server from a stored procedure and used the stored procedure in dataset of the SSRS report.
Extensive experience in connecting to SSAS directly from SSRS using new SSAS connection string and developed the different types of Tabular and Matrix SSRS reports.
Very good experience in working with several types of SSRS reports including drill-down, drill through, sub reports, tablix, matrix, charts, graphs, gauges, parameterized, cascading, conditional, Power view and Excel PowerPivot also working with front end UI application dashboard portals.
Well versed in Performance Point Server 2007. Designed dashboards, Scorecards and reports using multiple KPI s, OLAP charts and Reporting Services reports with PPS.
Experience in deploying the SSRS reports into SharePoint integrated mode and wire the report into sepcific business users based on the parameters.
Excellent experience in creating parameterized SSRS reports.
Excellent experience in T-SQL to write: stored procedures, views, functions, CTE s, recursive CTEs, Triggers, OPENQUERY, CURSORS, WHILE LOOPS, indexes (clustered and non-clustered), DDLs, DMLs and relational database models.
Excellent knowledge in OLTP transactional, relational and OLAP multi-dimensional databases (ROLAP, MOLAP etc.), DataMart s, Data warehouses, ODS, Dimensional Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions.
Extensively followed the advanced concepts of Ralph Kimball and Bill Inman methodologies and advanced dimensional data modeling concepts large dimensions, SCD s (SCD1, SCD2), Degenerate Dimension, Fact less Fact tables, transactional grain, periodic snapshot grain and accumulating snapshot grain, Families of stars, conformed dimensions and Facts.
Strong knowledge on RDBMS concepts, Conceptual, Logical and Physical models, Database Architecture, Data Mapping, Table Normalization (3NF), De-Normalization, DDL and DML.
Possess excellent oral / written communication and interpersonal skills.
Good ability to quickly grasp and learn new concepts and technologies.
Currently located in Plano, TX (75024).
TECHNICAL SKILLS:
Operating Systems: MS-DOS, Windows 95/98/NT 4.0/XP/2000/2003 Server, UNIX
RDBMS/Databases: MS SQL Server 2005/2008R2/2012/2014, Oracle 11g /10g, IBM DB2 UDB, IBM DB2 Z/OS mainframes,Teradata and No SQL databases HP Vertica
Data modeling and ETL Tools: MS SSIS, Informatica, Erwin and Power Designer v15.0
Reporting Tools: SSRS and Business Objects
BI Tools: Power BI, MS Excel PowerPivot, PowerView, PowerQuery, Qlikview, Tableau
Languages: T-SQL,PL/SQL, HTML and VB-Script and C#
Web Technologies: Microsoft Technologies: Sharepoint 2010, VB.Net, ASP.Net
EDUCATION:
Bachelor s degree in Computer Science and Engineering from JNTU Hyderabad India.
Master of Science in Information Systems from Texas A&M International University, Laredo, TX, USA.
PROFESSIONAL EXPERIENCE:
Great American Insurance Group
11001 Lakeline Blvd Austin, TX 78717 Jun 14 Present
Sr MS SQL Server (ETL SSIS SSAS SSRS) Deveoper
The Great American Insurance Group (GAIG) is a subsidiary of American Financial Group, Inc. (AFG) which is a Fortune 500 company and AFG provides 100 s of innovative Specialty Property & Casualty Insurance products through GAIG and manage the specific risks of the customer s business. The project is in LTC (Long Term Care) division, my role is to create ETL Process to extract data from disparate sources and populate summary data structures, analysis cubes and deliver high performance and integrity business intelligence reporting.
Responsibilities:
Participate in the team business requirements gathering and analyze, understand and convert them into database solutions.
Design ETL Packages with Microsoft SSIS 2012 to pull data from various sources like flatfiles, excel, Oracle, DB2 and SQL Server to individual Data marts which ultimately go into Enterprise Data Warehouse (EDW).
Cleanse Data while loading and write logic to perform different kinds of transformations like Derived Column, Conditional Split, Lookup, Data Conversion, SCD s, CDC(Change Data Capture) etc.,
Extensively worked on CDC (Change Data Capture) at the database level and used control flow items SSIS 2012 CDC(Change Data Capture) task, CDC Split task into INSERT, DELETE and UPDATE in SSIS 2012.
Wrote complex Stored Procedures, functions and triggers as and when needed to convert data logically as per the business requirements.
Extensively used Package Configurations and project level configurations while deploying the SSIS packages from DEV Stage, Stage Prod environments.
Extensively used C# in script component of SSIS.
Initially loaded data into staging tables using different SSIS control flow tasks, loop containers and data flow tasks, then moved the data into dimension and fact tables.
Developed reports directly connecting to SSAS from SSRS and designed several reports.
Heavily worked on SSRS report performance, store procedure tuning, table partition, MDX based queries, cube partition and UI tuning.
Developed SSAS cubes with multiple dimension tables, facts, calculated measures and developed SSRS reports using MDX queries.
Developed tablix, matrix, graphs, charts, sub reports, parameterized, drill through, drill up and drill down reports.
Heavily worked on new reports, existing reports, report performance issues and report support issues for the different partner UI dashboards.
Tuned the SSRS reports using the concepts of parameter sniffing, aggregated calculation in stored procedures instead in the report tablix, sorting in SP instead in tablix and other SP tuning techniques to improve the performance for the large volumes of data.
Used SQL Profiler, Actual and estimated execution plans to troubleshoot the Stored Procedure Table Scan, Index Scan, Index Seek, Key Lookup, loop and Sort etc. issues.
Developed the dashboards in Excel PowerPivot, sharepoint webparts, and demonstrated into Power BI and provided the ad-hoc structure to the business users.
Performed intensive data analysis on large data volumes, testing for quality assurance, and migrating releases into stage and production environments.
Environment: MS SQL Server 2014/2012, SSRS 2012, SSAS 2012, SSIS 2012, Oracle 11g/10g, MS Visual Studio 2012, Microsoft Excel, Power BI, Team Foundation Server, Agile Methodology.
DMEautomotive Jacksonville FL Aug 12 Jun, 2014
MS SQL Server (ETL SSIS SSAS SSRS) Developer / Data Analyst
DMEautomotive Inc. (DMEa) is one of the fastest growing automotive direct marketing companies in the automotive marketing industry. The main Objective of the project Red Rocket Solutions is to give a single view of the truth behind all of direct marketing efforts, identify the most productive customer segments and increase their return on investment. My role in this project is to design ETL packages, move data into dimension and fact tables, and generate real time dashboard reports which helps to see latest results, suggestions next month campaigns and for the future business decision making process.
Responsibilities:
Participating in database business requirements gathering for different business partners including AutoNation, Southeast Toyota, Passport Nissan, Aftermarket, Driver Connect, DirectToDealer, Jiffy Lube, Big O Tires and Brandon Honda projects.
Moved Flatfile .csv, Excel and other OLTP sources data into RRS_ETL databse, and moved from RRs_ETL to Staging Area RRS_Campaign Manager, performed Address Cleansing using Melissa Data and Google Analytics, VIN Cleansing and apply specific business rules using SSIS dataflow transformations and load the data into FACT table.
Downloaded SSIS GoogleAnalyticsSource plugin and read the data into dataflow task directly from Google Analytics.
Configured Dimensions, Metrics and Segments in SSIS GoogleAnalyticsSource which are required to perform address cleaning.
Initially moved the files from FTP to ETL database, ETL database to Master_Tables, Master_to Stage, and Stage to DWH.
Wrote complex relational based Stored Procedures, functions and triggers as per the business requirements used then in SSIS Execute SQL task in the ETL process.
Initially loaded data into staging tables using different transformations, control flow tasks, loop containers and data flow tasks, then moved the data into dimension and fact tables.
Used SSIS CDC task to move data from EDW to DataMart databases.
Implemented SSIS job with multiple steps in SQL Server agent and performed FTP to Stage, Stage to DWH, and DWH to DataMart using CDC.
Once the data is in place, developed the SSAS cube Universal Campaign Manager Cube right from the scratch with multiple cube dimensions, hierarchies, measure groups and calculated measures and developed SSRS reports using MDX queries embedded within the Stored Procedure with SSAS linked server catalogue.
Worked on copy database, backup and restore database wizards and worked on the optimization of SQL queries which resulted in substantial performance improvement.
Worked on SQL Server Integration Services Catalogue (SSIS DB, ETL database, Parameters and environments), SQL Server Security, SQL Server Management and SQL Server Agent.
Worked on SQL Server jobs, scheduled jobs based on hourly, daily and weekly schedules, executing the ETL processes in order, and worked job failures and troubleshoot the jobs.
Developed Reports Using SSRS on statistical data during migration of data and integrated them with Visual Basic applications.
Designed reports using Pivot-tables, bar-charts, Line-charts and Pie-charts on data from cubes and SQL Server in Excel.
Involved in the optimization of SQL queries which resulted in substantial performance improvement for the conversion processes.
Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
Created reports in SSRS with different type of properties like chart controls, filters, row groups, column groups, filters, intercative sorting and SQL Parameteres.
Created different Parameterized Reports for Campaign Manager which consists of report of marketing efforts made by the weekly campaign including marketing via mail, e-mail, phone call and survey call counts.
Environment: MS SQL Server 2008R2 & 2012, SSIS 2012, SSRS, SSAS, Oracle 11g/10g, MS Visual Studio 2008 & 2010, Excel Power Pivot, Azure, Data Factory, SQL data Warehouse.
AmeriGroup HealthCare Corporation Virginia Beach, VA Apr 12 Aug 12
Sr. MS SQL Server Developer
Responsibilities:
Working with the Business Analysts and Business Users to identify information needs as per our project requirements.
Design and maintain MS SQL SSIS Packages, T-SQL Stored Procedures, scripts, and code for high performance.
Created cubes using SSAS and SSRS reports and worked on tuning SSRS reports, T-SQL stored procedures, SSIS packages and delivered highperformance reports.
Environment: MS SQL Server 2005, SSIS, SSRS, Oracle 11g/10g, IBM Rational Robot, IBM Predictive Modeling, PL/SQL, Factes Claims Processing, MS Excel, MS Visual Studio.Net, C#.
JOHN DEERE & COMPANY (Head Quarters), Moline, IL Apr 09- Feb 12
SQL Server Developer
Responsibilities:
Worked with Data Modeler to gather business requirements from the business users.
Worked ETL SSIS for transferring and reviewing data from heterogeneous sources like (Source Databases, FTP Server and Excel, CSV, flat file, Text Format Data).
Developed T-SQL queries, triggers, functions, cursors and stored procedures.
Created complex SSAS cubes named Reporting Consolidated BIWarehouse with multiple fact measures groups (Invoices, Opportunities, Pending Sales and GLTransaction) and multiple dimension hierarchies based on the OLAP reporting needs.
Designed, developed, created and tested PivotTable/PivotChart reports based on OLAP cubes and offline cubes for business analysts.
Interacted with Business Users to help them understand how to generate reports/look at the business data with various drill down options using Excel 2003/Excel 2007 connecting to SQL Server Analysis Services (SSAS).
Heavily worked on database performance tuning and query optimization, data integrity and statistics.
Environment: SQL Server 2005/2008, T-SQL, SSIS, SSAS, SSRS, Informatica, Oracle 11g/10g, PL/SQL, Microsoft Visio, SQL Profiler.
Praxair Inc. 175 East Park, Tonawanda, Buffalo, NY Nov 08-Feb 09
SQL Server Developer
Responsibilities:
Worked as part of a team for gathering and analyzing Business Requirements
Participated actively in designing the system database structure
Developed SSIS packages to extact data from different sources & loaded into SQL Server.
Generated Reports using SSRS Tablix, matrix, global variables, expressions and functions.
Environment: SQL Server 2005, T-SQL, Visual Studio, SSIS, SSAS, SSRS, Report Builder, SQL Profiler, Query Optimizer, Erwin, Team Foundation Server 2005, Oracle, PL/SQL.
OIT (Office of Information Technology) TAMIU Laredo TX May 07 Oct 07
Role: RDBMS Database Developer/Programmer
Responsibilities:
Understanding of data modeling fundamentals and techniques.
Installation and configuration of SQL Server database.
Creation of databases & objects like tables, views, stores procedures and triggers.
Worked extensively on SQL & Stored Procedures programming.
Environment: SQL Server 2005 and T-SQL |
