SAIKUMAR M

aczity@r.postjobfree.com

510-***-****

PROFESSIONAL SUMMARY:

7+ years of experience in database design, development and administration with MS SQL

Extensive experience in SQL service integration services (SSIS) for ETL

(Extraction,Transformation and Loading), reporting services (SSRS) for creating different types

ofreports and analysis services(SSAS) for design and development of complex cubes.

Excellent backend skills in creating SQL objects (Tables, Complex Stored Procedures,Effective

Functions, Views, Indexes, Triggers, Rules) and SQL Performance Tuning tofacilitate efficient

data manipulation and consistency.

Experience in logical and physical Dimensional Modeling, ER Modeling, Star Schema /Snowflake

Schema, Fact and Dimensional tables and Operational Data Store (ODS).

Development of Multi-dimensional Objects (Cubes, Dimensions) using Analysis Services (SSAS).

Excellent Transact- SQL / T-SQL programming skills with experience in developingSQL queries, sub

queries using Joins, Aggregate functions and User defined functions.

Well versed with the knowledge of RDBMS, data warehousing (OLTP and OLAPsystems),System

Development Life Cycle (SDLC), and Waterfall model.

Highly skilled in Data Modeling, Data Mining, Data Mapping, Table

Normalization,Optimization and Tuning.

Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS and SSISpackages using

SQL Server Management Studio and Control-M Workload

Automation tool.

Developed complex win forms using VB.Net and Oracle 12.1.

Developing distributed application using web services in vb.net

Excellent knowledge in dealing with Delegates, Assemblies, User Controls and Custom Controls in

VB .Net

Experience in resolving complex issues and error handling in SSIS, Unit Tests and UserAcceptance

Tests.

Proficient in writing SSIS script/script component task using c#, VB script forcustomized data

manipulation of complex SSIS packages.

Microsoft COSMOS, SCOPE technologies for data/stream analysis.

Creating/maintaining scope scripts and jobs to generate daily stream file on COSMOS of evidence.

Expert in designing enterprise reports using reporting services (SSRS) like Dashboards,Tabular,

Matrix, Drill down, Drill through, Sub reports and Ad-Hoc reporting. Createdmultiple value

parameters, cascading prompts, dynamics reports.

Extensive experience in rendering reports, managing subscriptions, creating reports withreport

builder, report snapshot and report cache.

Experience in providing SSRS server level, item level security and accessibility tovarious reports in

multi-user environments.

Proficient in Database Installation, Configuration, Maintenance, Monitoring, Backup andDisaster

Recovery procedures and Replication.

Responsible for building Power BI Dashboards for 3M Digital Marketing team using Tabular and

Multi dimensional Models. Design and model data sets with Power BI desktop based on measure and

dimension requested by customer and dashboard needs.

Good understanding of Integrations including Web Services, SAAS, Workday Architecture,

Business Process Framework.

Installed On premise data gateway and scheduled daily data refresh in Power BI.

Worked on Windows Azure Infrastructure as A Service Platform (IAAS)/(PAAS).

Extensive experience in analysis, design, application programming on Oracle. Experience in database

Backup & Recovery.

Good knowledge on delivering predictable performance, scalability, business continuity, data

protection using Microsoft Azure SQL Database.

Worked with Oracle DBA in migration project and supported oracle databases

Strength Finder s top 5 strengths: Maximize, Achiever, Responsibility, Deliberative,and Strategic.

Outstanding problem solving, analytical, technical leadership, communication, Time management

skills and quick learning capability to new technologies.

Technical Skills:

Databases Tools SQL Enterprise Manager, Query Analyzer, SQL

Server Management Studio, Business

Intelligence Development Studio, SQL Profiler,

SQL Server Analysis Service (SSAS)

ETL Tools SQL Server Integration Services (SSIS), Data

Transformation Services (DTS)

Programming T-SQL, PL-SQL, C, MYSQL

Database MS SQL Server 2016/2012/2008R2/2005/2000,

MS Access,

Reporting Tools SQL Server Reporting Services (SSRS),

MS Access, MS Excel, Crystal Reports.

Operating Systems Windows 2008 R2, Windows NT 2000/2003

Server, Windows XP/7.

Jarden corporation, Boca Raton, Florida Mar 16 Current.

SQL Developer/Production Support:

Jarden Corporation is a provider of a range of consumer products. The Company operates in three business

segments: Outdoor Solutions, Consumer Solutions and Branded Consumables. Its segments manufacture or

source, market and distribute a number of brands, including Outdoor Solutions, Consumer Solutions, and

Branded Consumables.

Responsibilities:

Collected business requirements from users and translated them as technical specs and design docs

for development.

Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes,

Tables, Views and other T-SQL code and SQL joins for applications.

Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational

database models, data dictionaries, and data integrity.

Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.

Extensively used SSIS to move data from text files to SQL Server.

Responsible for building Power BI Dashboards for 3M Digital Marketing team using Tabular and

Multi dimensional Models. Design and model data sets with Power BI desktop based on measure and

dimension requested by customer and dashboard needs.

Good understanding of Integrations including Web Services, SAAS, Workday Architecture,

Business Process Framework.

Installed On premise data gateway and scheduled daily data refresh in Power BI.

Worked on Windows Azure Infrastructure as A Service Platform (IAAS)/(PAAS).

Extensive experience in analysis, design, application programming on Oracle. Experience in database

Backup & Recovery.

Good knowledge on delivering predictable performance, scalability, business continuity, data

protection using Microsoft Azure SQL Database.

Worked with Oracle DBA in migration project and supported oracle databases

Views using T-SQL in Development and Production environment for SQL Server 2008.

Primary duties were to assess infrastructure, deployment, processes and validity of data in SQL

Server 2014.

Created Quality Assurance stats reports using SSRS

Created SSIS packages for new projects utilizing Business Intelligence Development.

Writing complex Stored Procedures to meet the business requirements.

Using SQL Profiler to estimate the Slow Running queries and performance tuning purpose.

Report parameters included single valued parameters, multi-value parametersthat also consist of

different parameter types like hidden, internal, default (queried and non-queried parameters).

Created data sources, connection strings and defined the datasets for generating the report.

Worked on all types of report types like tables, charts, sub reports etc.

Used VB.Net to define and implement Business Logic Layer and Data Access Layer.

Created OOPs objects like Collections, Interfaces implementations using VB.Net Generics for

extracting data

User interface screens developed using VB.NET.

Participated in the conversion of VB system into MVC VB based architecture

Created Linked reports, Ad-hoc reports etc based on the requirement. Linked reports are created in

the Report Server to reduce the repetition the reports.

Developed, monitored and deployed SSIS packages.

Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables

with incremental load.

Created logging for ETL load at package level and task level to log number of records processed by

each package and each task in a package using SSIS.

Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages through Active Batch Job

Scheduler.

Created subscriptions to provide a daily basis reports. Used Reporting Services (SSRS) to schedule

reports to be generated on predetermined time.

Environment:

MS SQL Server 2008 Visual Studio, MS SQL Server 2000/2008R2/2016 SQL Integration Services,

VB.net, SQL Query Analyzer, Import & Export Wizard.

Charter Communications- Charlotte, NCApr 15 Jan 16

MS SQL Server SSIS/ SSRS Developer:

Responsibilities:

Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML

files etc.) and then loaded the data into destination tables by performing different kinds of

transformations using SQL Server Integration Services (SSIS).

Created SQL Objects like Complex Stored procedure, trigger, functions, views and tables

Performance tuned Stored Procedures & long running queries by looking at query plans, IO

Statistics, Joining Techniques and Indexes.

Modified various MDX Calculations in cube.

Created different roles for the security in cube.

Interacted with user groups for delivering Enterprise Reports using SSRS 2008 R2 reports for

various reporting needs.

Developed Complex SSRS Reports involving Sub Reports (Matrix/Tabular Reports, Charts and

Graphs).

Created static reports in Excel with Graphs and trends for month end.

Created partitions for various counties and designed aggregations (manual & usage based), relations

and attribute hierarchies in the SSAS cubes.

Responsible for building Power BI Dashboards for 3M Digital Marketing team using Tabular and

Multi dimensional Models. Design and model data sets with Power BI desktop based on measure

and dimension requested by customer and dashboard needs.

Good understanding of Integrations including Web Services, SAAS, Workday Architecture, Business

Process Framework.

Supporting VB.NET applications that support the engine assembly.

Created asynchronous VB.NET application that allowed editing downloading of information to

PLCs. The application used Entity Framework for accessing the SQL database.

Upgraded VBA applications to VB.Net utilizing Visual Studio Tools for Office.

Installed On premise data gateway and scheduled daily data refresh in Power BI.

Worked on Windows Azure Infrastructure as A Service Platform (IAAS)/(PAAS).

Extensive experience in analysis, design, application programming on Oracle. Experience in database

Backup & Recovery.

Good knowledge on delivering predictable performance, scalability, business continuity, data

protection using Microsoft Azure SQL Database.

Good Hands on experience writing Scope Scripts for Cosmos (Big Data) Azure Services and cloud

services.

Converting unstructured streams in Cosmos (Raw Data which are in Binary form) to structured

stream (readable stream) and performing required aggregation on that Data using scope studio by

writing scope scripts

Worked with Oracle DBA in migration project and supported oracle databases

Created Dashboards, Score Cards and KPI's for various reporting needs.

Involved in testing the data with Business Analysts and testing team.

Interacted with end-users and customers during various phases of the Implementations (ETL,

Reporting, Production Support, Enhancements and bug fixes).

Environment:

MS SQL Server 2012/2008R2 SQL Integration Services 2012, MS SQL SSRS, SSIS, VB.net Windows

2003 Advanced Server.

Mind Grid Technologies Hyderabad, TelanganaSep 12 Dec 14

MS SQL Server Developer:

Responsibilities:

Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Developed Custom Logging so user can know when a row is inserted in custom logging Table by

every SSIS package that executes.

Created SSIS packages to extract, transfer and load data into the data warehouse on a daily basis.

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

Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server

2012, Flat files etc.

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

Created SQL Server Reports based on the requirements using SSRS 2012.

Worked on Drill through Report links and Hyperlinks to jump to other reports and web pages using

Microsoft SQL Server Reporting Services (SSRS).

Created and scheduled SQL jobs to run SSIS packages on a daily basis.

Expert Knowledge of Integration Services (SSIS) and Reporting Services (SSRS). Worked

Extensively on ETL process using SSIS packages.

Experience in Developing, Deploying and MonitoringPackages for ETL Tasks using SSIS, DTS

Import/Export Utility, BCP (Bulk Copy Program) and DTS Packages.

Involved in implementing SSIS package security, protecting packages, executing, monitoring and

managing them.

Developed the server side code using C#, VB.Net

Migrated the entire application from Version2 (ASP, VB Script) to Version3 (using Web Services,

XSLT and VB.net)

Designed and developed web forms using ASP and VB Script

Created various Tabular and Matrix Reports using SSRS.

Created reports to retrieve data using Stored Proceduresthat accept parameters. And also converted

various Stored Procedure based reports into SSRS based reports to improve the efficiency and

flexibility of reports

Developed a Tabular Reports, ad-hoc reports using SSRS Report Designer.

Strong Experience in developing reports using Query Studio & Report Studio.

Schedule, Monitor and control Access of users by creating groups.

Worked on for loading data from source to destination.

Wrote optimized T-SQL Stored Procedure to improve performance, preserve referential integrity and

provide application functionality

Environment:

MS SQL Server 2008 Enterprise Edition, MS Access, DTS, Query Analyzer, BCP, SQL

Profiler, VB.net, Erwin 4.1, Business Objects 6.5, Import & Export Data, Windows 2000 Server.

Innvectra Hyderabad, TelanganaJun 10 - Sep 12

SQL Server Developer:

Responsibilities:

Designing the Databases, Developing Business Intelligence Analysis, Implementation and Reporting

with Microsoft SQL Server 2005/2008/2008R2/2012.

Use of Extract, Transform and Load (ETL) using SQL Server Integration Services (SSIS)

Packages for integrating data using OLEDB connection from varied sources by using multiple

transformation secluding Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.

Creating Simple to Parameterized Dynamic Reports and Complex Reports including Tabular

Reports, Matrix Reports, Charts, Graphs, and Sub-reports using SSRS in Business Intelligence

Development Studio (BIDS)/Data Tools

Creating SSIS Packages for uploading of different formats of files and databases into SQL Server

Data Warehouse using SQL Server Integration Services.

Create Data Flow Diagrams, Data Mapping From Source To Stage And Stage To Target Mapping

Documents Indicating The Source Tables, Columns, Data Types, Transformations Required And

Business Rules To Be Applied.

Plan, Define and Design Data based on Business Requirements and provide documentation.

Create new Database objects like Procedures, Functions, Packages, Triggers, Indexes using T-SQL

in development and production environment for SQL Server.

Migrating the Data from one environment to another.

Use of SQL Server Integration Services (SSIS) and Reporting Services (SSRS)

Performance Tuning, SQL Programming, Troubleshooting, SSIS/DTS Package Configuration,

SSRS.

Environment:

MS SQL Server 2005, MS Access, DTS, Erwin, SQL Query Analyzer, SQL Developer.

EDUCATION QUALIFICATIONS:

Bachelor of Technology in Information Technology Jawaharlal Nehru Technological University Hyderabad,

India.

Contact this candidate