SUMMARY

• 10+ years of experience in DW/BI (SQLServer DBA, SSIS, SSRS, and SSAS & Clover ETL - Endeca), with specialized focus on data architecture and ETL Design on tools such asSQLServer Business Intelligence (SSIS, SSRS & SSAS) … with Microsoft Technologies.
• Extensive working knowledge in SSIS/SSRS/SSAS … MSSQLServer … .NET, ASP, VB, ActiveX Component, JavaScript, VBScript and IIS.
• Experience inSQL, PL/SQLProgramming and T-SQL.
• Worked in various domain like Insurance (General Insurance), Information Media & Entertainment,
• Manufacturing & Logistics, Travel (Airline Ticket) and CMS (Content Management System).
• Ability to work under aggressive time schedules
• Achievement of goals in the areas of product performance reliability, customer satisfaction and production quality.
• Strong analytical and statistical skills for design of experiment, data analysis, and reporting.
• Proven ability to deal with clients from Project Scope to Deployment.
• Good Understanding of SDLC.
• System Analysis (SDLC), Design, Scheduling using MS Visio
• Having experience of gathering Requirements, Designing, and Planning/Scheduling and Developing.
• Database coding and implementation
• Excellent hands on experience inSQLserver Programming in all versions onSQLServer.
• Expert in developing stored procedures, Views, UDFs, Triggers, Performance Monitoring.
• Extensive knowledge in TuningSQLqueries & improving the performance of the Database.
• Exposure toSQLServer Database Administration tasks.
• Transformed data from various data sources using OLE DB connection by creating various SSIS/DTS packages.
• Created Reports with complex formulas and query the database for Business Intelligence.
• Good Business and System analysis skills to understand the requirements for the client applications
• Decision support systems analysis, design and construction
• Played an efficient role in customer interaction & fulfilled business requirements with quality deliverable.
• Define project success criteria and disseminate them to involved parties throughout project life cycle.
• Had provided efficient support during critical phases and received appreciation from the client.
• Implemented High availability cluster 2014 asSQLtechnical team lead.Implemented and converted database to column indexes, In-Memory OLTP format for faster database retrieval and processing
• Implemented and maintained SOX compliance requirement and restrictions in enterprise databases systems.
• Responsible for payroll, workflow, data warehouse, logistic, rebate system and voice-distribution databases maintenance, implementation, security and performance.
• Design, develop and implemented cluster service for windows & database data warehouse
• Database performance tuning, performance tracking & monitoring, proactively resolve potential bottleneck issues related to hardware or software.
• Implemented server active/active cluster environment, data mirroring for online ordering autantication, and log shipping for internal inventory/logistic applications.
• Design & developed ETL packages for data warehouse and payroll system.
• Developed workflow ETL packages for Perceptive Enterprise workflow system betweenSQL
• Project lead for Account Payable data warehouse project development and implementation.
• Responsible for design, development, implementation and maintenance of internal data warehouse consist of sales, AP, inventory, logistic and time attendance.
• Developed and optimized indexes, complex views, constraints, triggers, and stored procedures for large MSSQLServer database.
• Created and developed the stored procedures, triggers, views, and user defined functions to handle complex business rules, activity log, error log, and audit analysis
• Developed and created data dictionary, tables, views, indexes, and functions advanced queries for databases by using Query Analyzer andSQLServer Enterprise Manager
• Generated databaseSQLscripts and deployed databases including installation and configuration
• Developed and implemented maintenance stored procedures
• Developed and implemented disaster recovery and archiving procedures
• Consolidated databases to accommodateSQLServer 2012 new license policies.

TECHNICAL SKILLS

OS: Windows 8&7, Windows NT, Windows 9x, … XP

Web Technologies: ASP.NET, ASP, Web Servers IIS

Scripting Languages: JavaScript, VB Script

Language: C,C++,JAVA

Web Language: HTML, DHTML, XML

Database: SQLServer … MS-Access, Oracle 11g & SybaseBI & ETL Data Warehousing, SSIS (SQLServer … DTS, Informatica, Clover ETL- EndecaGUI Visual Basic 6.0, TFSMultimedia Interdev, Dreamweaver

Technologies: ASP.Net,SQLServer 2000, JavaScript, HTML

Others: Performance TuningCapacity PlanningInstallation, Upgrade, & MigrationODBC, OLE DB, DTS

PROFESSIONAL EXPERIENCE

Sr.SQLDeveloper

Confidential, NJ

Responsibilities:

• Requirement gathering, Functional & technical specifications for end user and end client applications, Re-Engineering and capacity planning.
• Involved in database Schema design and development.
• Migrated Database fromSQLServer 2005 to 2008.
• Experience in using T-SQLfor creating stored procedures, indexes, cursors and functions.
• Generated server side T-SQLscripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Creating tables, indexes and designing constraints and wrote T-SQLstatements for retrieval of data and involved in performance tuning of T-SQLQueries and Stored Procedures.
• Executed stored procedures using BATCH files.
• Developed stored procedures and functions for designing various reports.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Used Batch Files to Import Data from other Data Base.
• Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Wrote the ETL scripts to load the data into database from various source files. Experienced in error handling and troubleshooting the scripts in failure to load the data into database.
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Created packages in SSIS with custom error handling and worked with different methods of logging in SSIS.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve PII user data from the Flat files on monthly and weekly basis.
• Expert in SSIS Deploying and Scheduling
• Identified and Defined Key Performance Indicators in SSAS …
• Process SSAS cubes to store data to OLAP databases
• IntegrateSQLServer 2005 reporting services with Microsoft Share point Portal Server to deliver automatically generated reports to the Share Point portal.
• Defined report layouts for formatting the report design as per the need.
• Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, usingSQLServer Reporting Services.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created reports and Dash boards using Microsoft Performance Point service.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• In depth knowledge in SSRS for report generation to create various types of reports and also to develop different SSIS packages.
• Administrated the created Reports by assigning permission to the valid user for executing the reports.

Environment: SQLServer … Enterprise Edition, SSIS, SSRS, MS PowerPoint, MS Project, Oracle, PL/SQL, C#, VB.Net, XML, Visual Studio 2008 & 2005, MS Visio 2007, Tortoise SVN.

SQLServerDeveloper

Confidential, NJ

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Designed ER diagrams (Physical and Logical using Erwin) and mapped the data into database objects.
• Upgraded MSSQLServer 2005 database to MSSQLServer 2008, by using Detach/Attach, Back up & Recovery.
• Developed stored procedures, functions, views and triggers.
• Migrated SSIS packages fromSQLserver 2005 toSQLserver 2008
• Converted crystal reports toSQLServer reports using Reporting Services.
• Used various SSIS tasks such as Conditional Split, Derived Column, data validation checks during Staging, before loading the data into the Data warehouse.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Used Merge in development, test and production for changing the referenced data.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created SSIS package to get data from different sources consolidate and merge into one single source.
• Configured and maintained Report Manager and Report Server for SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using MS Reporting services.
• Performed T-SQLtuning and optimization of queries for reports that took longer execution time using MSSQLProfiler, Index Tuning Wizard andSQLQuery.
• Performed Documentation for all kinds of reports, DTS and SSIS packages.
• Responsible for creating fact and dimension tables, build cubes using SSAS.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Created indexes, constraints and rules on database objects.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.
• Experienced in making technical specifications report by gathering information from end user.

Environment: Windows XP Professional,SQLServer … SQLReporting, Business Intelligence Studio, Visual Studio … OLE DB, DTS Package, SSIS.

SQLServer BIDeveloper

Confidential, PA

Responsibilities:

• Implemented Complex Stored Procedures and automated them usingSQLServer Agent
• Experienced using Sharepoint to enhance collaboration among the team members.
• Programmed Triggers (Instead Of and After) for Auditing Purpose
• Played role in design of scalable, reusable, and low maintenance ETL templates.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms such as
• Lookup, Fuzzy grouping and Row Count Transformations and type 1 and type 2 slowly changing dimensions
• Managing the security of the servers, creating the new logins and users, changing the roles of the users.
• UsedSQLServer Profiler to trace the slow running queries and tried to OptimizeSQLqueries for improved performance and availability.
• Created SSIS packages for application that would transfer data among servers and perform other data transformations.
• Generated country wise, region wise reports using global variables, expressions and functions using SSRS.
• Scheduled the same SSIS packages by creating the corresponding job tasks
• Created Scorecards and added them to dashboard using Dashboard Designer and deployed the dashboard to SharePoint.
• Defined report parameters and wrote queries and procedures for drill down and parameterized reports using SSRS.
• Created and design the multiple dimensions and fact table for business report purpose.
• Created Report Snapshots to improve the performance of SSRS
• Generated parameterized/Drilldown reports to enable/disable the parameters based on user selection in SSRS
• Regular responsibilities for updating dimensional databases
• Performance tuning, writing stored procedures, indexes

Environment: MSSQLServer 2008, T-SQLMS Excel … MicrosoftSQLServer Integration Services (SSIS), MicrosoftSQLServer Reporting Services (SSRS), VB, VB.NET, MicrosoftSQLServer Analysis Services (SSAS),SQLServer Data Tools.

MSSQLServerDeveloper/ SSRSDeveloper

Confidential, IL

Responsibilities:

• Created ETL packages using Heterogeneous data sources (SQLServer, ORACLE, Flat Files, Excel source files, XML files etc.) and tan loaded the data into destination tables by performing different kinds of transformations using SSIS.
• Used different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc.
• Used Event Handlers for Custom Logging using Complex Store Procedures for various events (On warning, On Pre and Post Execution, On Task Failed etc.)
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Used Configuration files for changing variables and setting the priority levels for those transcripts based on the level of urgency / requirement.
• Created OLAP models based on Dimensions and Facts for efficient loads of data.
• Scheduled the reports to refresh and run on daily, weekly and monthly basis in the report manager.
• Developed MDX Queries in order to perform drilldown reports and for calculating measures and dimensions.
• Implemented perspectives and KPI using calculated measures based on requirements.
• Identified and defined the datasets for Report generation.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using Reporting Services.

Environment: MSSQLServer … T-SQL,SQLServer Integration Services (SSIS),SQLServer Data Tools,SQLServer Reporting Services, SQLServer Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel.

MSSQLServerDeveloper

Confidential TX

Responsibilities:

• Worked on Client/Server tools likeSQLServer Enterprise Manager and Query Analyzer to AdministerSQLServer.
• Involved in writing T-SQLprogramming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.
• Performed complex queries, triggers and stored procedures, views and user defined function and updated Database Statistics and Re-indexing.
• Involved in performance tuning using indexing (Clustered Index and Non-Clustered index) by minimizing table scans.
• Created Database Maintenance Planner for the Performance ofSQLServer which covers Database Integrity Checks and routine backups.
• Planned the complete back up of the Database and Restore the Database from Disaster Recovery.
• Coordinated with the supervisor to design and implement database logical and Physical Schemas.
• Worked on DTS Package, DTS Import/Export for transferring data from DB2 Database and Data migration (import & export - BCP) from Text toSQLServer.

Environment: MicrosoftSQLServer 2000, HTML, Microsoft Visio 2000, Microsoft Visual SourceSafe, Query Analyzer,SQLprofiler and Windows 2000/XP, T-SQL.