Resume

Sign in

SQL BI

Location:
Alpharetta, Georgia, United States
Posted:
November 02, 2018

Contact this candidate

Resume:

SUMMERY:

•Over * years of industry experience as a MS SQL Developer, Business Intelligence focus on financial area, Insurance, Health care offering various business solution strategies through SQL Server Integration, Analysis and Reporting Services (SSIS, SSAS, and SSRS).

•Adept in designing database in the logical and physical level and drawing various E-R diagrams in MS Visio.

•Vast experience in extracting, transforming and loading (ETL) data from OLTP (transactional) databases and other data sources, including heterogeneous and homogeneous sources into Data Warehouse, in SSIS using various tasks and transformations.

•Experienced in creating configuration files to deploy the SSIS packages across different environments.

•Skilled in error and event handling: Implemented check points, break points, event handlers, troubleshooting, and error handling in SSIS packages to improve usability and liability.

•Experience in creating jobs, SQL Mail Agent, Alerts and schedule SSIS Packages. Experience in transformation data from DB2 to SQL Server.

•Data migrations from text files, DB2, excel files to SQL server.

Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.

•Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.

•Expert in creating and modifying different types of ad-hoc reports including parameterized, linked, drilldown, drill-through, sub-report, matrix, tabular, and dashboard reports as well as Reports with complex join Queries in SSRS; in depth experience in creating multiple levels cascading prompt for both static and dynamic parameters.

•Experienced in using Power BI to do better data visualization and reports; using SharePoint to securely shared, collaborated files.

•Expert in programming Tables, Views, Stored Procedures, User Defined Functions (UDF), Constrains, Indexes, Temporary tables, CTEs and Triggers to optimize retrieval.

•Experience in Database Backup, Recovery and Disaster Recovery procedures.

•Strong communicating skills including interviewing, brainstorming; Being a good Teamwork player and with excellent analytical and problem solving abilities.

SKILL SET:

Databases

MS SQL Server 2000/2005/2008, MS Access

ETL Tools

MS SQL Integration Services(SSIS),MS SQL Reporting Services(SSRS), MS SQL Analysis Services(SSAS), DTS, Crystal Reports 9/10

Languages

C, C#, XML,, HTML, DHTML, T-SQL, PL/SQL

PROFESSIONAL EXPERIENCE:

BNY MELLON New York, NY

Business Intelligence Developer Nov 2017 – Oct 2018

Responsibilities:

•Used SDLC approach to create multi-dimensional data warehouse which included snowflake schema, data marts, fact tables and dimension tables.

•Designed and developed SSIS packages using various control flow and data flow items to extract, transform and load data from different data sources like Excel, Access, Flat files, and OLE DB source into data warehouse.

•Used many transformations like look up, audit, slowly changing dimension, etc.

•Added measures, calculations, dimensions, attribute relationships to the multidimensional cubes and wrote MDX queries.

•Deployed and supported SSIS packages to production server, and jobs were scheduled run the packages to load data automatically.

•Identified long running stored procedures using execution plan and optimized queries for more effective data retrieval.

•Scheduled and monitored all maintenance activities including database consistency check, data backup & restore strategy, index defragmentation, statistics updates.

Environment: MS SQL 2008, T-SQL, MS SQL Data Tools (SSIS, SSAS), MS Office 2007, Windows XP, MS Access.

CONAGRA FOODS Naperville, Illinois

Business Intelligence Developer Oct 2016 - Nov 2017

Responsibilities:

• Worked extensively with the users, different levels of management; conducted formal interviews and JAD sessions to identify requirements, functional specifications and database specifications.

•Designed and developed SSIS Packages to extract, cleanse, transform and load data from OLTP into data warehouse.

•Used slowly changing dimension to monitor changes, add derived column to extract required information.

•Developed, monitored, scheduled and executed SSIS package by using MS BIDS and SQL Server Agent including Scheduled Jobs, E-mail Notifications, Error Alerts and Error Logs as required; configured SQL mail agent for sending automatic emails with Success/Failure reports to assigned recipients.

•Defined and deployed complex SSAS Cubes with multidimensional hierarchies based on OLAP reporting requirements; Added measures, calculations, dimensions, attributes relationships, etc.

•Developed and extended SSAS Cubes, Partitions, KPIs, Perspectives, Actions, Data Mining Models, deploying and processing SSAS objects.

Environment: MS SQL Server 2012, Microsoft Visual Studio 2010 (SSIS, SSAS), Windows 7, MS Office 2010, MS Visio 2010, SharePoint 2010.

ASSURION San Mateo, CA

MS SQL Developer SSIS/SSRS/SSAS Developer Nov 2014 – June 2016

Responsibilities:

Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.

Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).

Build ETL processes utilizing SSIS and DTS, including FTP data from remote location, transform it, mart it to data warehouse and provide proper error handling and alerting.

Created SSIS package to load data from Flat File to Data warehouse and Report-Data mart using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension.

Involved in SSIS Packages to transfer data from various sources like Text Files, XML (Extensible Markup Language) Files, SQL Server, Excel and Access to SQL Server.

Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.

Configuration of Script task in Control flow using C# code for the ETL transformations.

Created SSIS (SQL Server Integration Service) packages to extract data from OLTP to DW systems and scheduled Jobs to call the packages and Stored Procedures.

Wrote T-SQL queries, Stored Procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data.

Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.

Created SQL server Analysis Projects and created multi-dimensional databases and OLAP cubes and dimensions for the analysis of capacity planning task in specific areas for departmental manager using SSAS. Developed the SSAS cube based on Kimball data warehousing methodologies.

Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software and improve the performance.

Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2008. Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries. Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008.

Designed and developed various custom defined reports using SQL Server Reporting Services (SSRS) and deployed them on SharePoint 2007 Portal.

Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script. Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Environment: MS SQL Server 2008/2005,SSIS 2008/2005, SSRS 2008/2005, SSAS 2008/2005, Windows NT/2003, Microsoft, XML

VERTEX DATA SOLUTIONS Bangalore, India Jr.SQL Server Developer Oct 2007 - Dec 2008

Responsibilities:

Interacted with Team and Analysis, Design and Develop database using ER Diagram, Involved in Design, Development and testing of the system.

Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes).

Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.

Implemented Exceptional Handling.

Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports

Creating and automating the regular Jobs.

Tuned and Optimized SQL Queries using Execution Plan and Profiler.

Rebuilding Indexes and Tables as part of Performance Tuning Exercise.

Involved in performing database Backup and Recovery.

Worked on Documentation using MS word.

Environment: SQL Server 2005, SQL, T-SQL, Visual Basic 6.0/5.0, Crystal Reports 7/4.5, ASP/VB.NET

EDUCATION:

Master of Digital Electronics

B.V.B College of Engineering and Technology.



Contact this candidate