SUMMARY

• 9 + years of IT experience in analysis, design, implementation & administration of business intelligence solutions with Microsoft SQL server 2012/2008/2005 in development, testing & production environment.
• Expertise in design and development of SSIS (ETL) packages.
• Expertise in generating Crystal reports, Ad hoc reports, tabular reports, Matrix reports, Drill - down reports, Cascaded reports, List reports, Parameterized reports, Sub reports and mentoring end user report writers using SSRS
• Extensive experience in Requirement Analysis, Work flow analysis, Design, Development & Implementation, Testing & Deployment of complete software development life cycle (SDLC) in field of Desktop Applications, Microsoft web and client/server technologies.
• Extensive experience in Relation Data modelling for creation logical and physical design for databases and proficient in creating E-R diagram using Erwin and Visio.
• Strong concepts of Data Warehousing, strategies for ETL, identifying metrics, dimensions, hierarchies and design dimensional schema (Star, Snowflake) and implementing slowly changing dimension etc.
• Highly proficient in writing functional specifications and translating business requirements to technical requirements
• Excellent T-SQL development skills to query complex relational databases with the development of Stored Procedures, User Defined Functions (UDF), Cursors, Views and Triggers and user created data types to provide flexible and reusable modules to be used in WEB technology and client-server Windows technology
• Expertise in creating indexed tables with primary key, foreign key and composite key constraints to maintain referential integrity and to maintain performance
• Expertise in writing and debugging Stored Procedures and Triggers
• Hands on experience in the ETL processes using SQL Server Integration Services (SSIS) Bulk Copy Program (BCP) and Data Transformation Services (DTS)
• Develop and implement ETL routines according to data warehouse design and architecture.
• Extensive experience in power pivot modelling, building and maintaining power views.
• Proficient in extraction, transformation, cleansing, and loading data from heterogeneous data sources of Oracle, MS Access and flat files
• Experienced in developing user reports, management reports along with Report Authoring, Report management, Report delivery and Report security using SQL Server Reporting Services from MS Excel and flat files
• Extensively involved in SQL Tuning using SQL Server Profiler, SQL TKProf, Explain Plan, Optimizer Hints to enhance the performance of the complex queries for OLTP Transactions and Decision Support System
• Experience in managing Alerts, Operators and Jobs through SQL Server Agent
• Involved in administrative tasks such as creating user roles, logins, security and permission on database level.
• Integrator of relational databases like SQL Server, ORACLE, Microsoft Access and Excel spreadsheets.

TECHNICAL SKILLS

• Enterprise Manager
• Profiler
• Query Analyzer
• Export & Import
• MS SQL Server 2005/2008/2012
• MS Access
• Oracle
• DTS
• SSIS
• SQL
• T-SQL
• VB.Net
• C# and Oracle
• HTML
• XML
• CSS
• My SQL
• Software Development Life Cycle (SDLC)
• Project Management
• Windows 2000/NT
• Windows 2000 Server/Windows 98/2000/XP.

PROFESSIONAL EXPERIENCE

Confidential, Fair Haven, MA

Sr. SQL Server/Sr. MSBI (SSIS/SSRS) Developer

Environment: Microsoft SQL Server 2008/2005, SQL Server Integration Services (SSIS) 2005/2008, SQL Server Reporting Services (SSRS), MS Excel, Team Foundation Server, VSS 2005, Team Explorer, Scheduler.

Responsibilities:

• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system, DSR (Staging Database) to Data warehouse (SQL server).
• Developed Tabular reports, Crystal reports, Cross Tab reports, Charts reports, Parameterized, cascaded and sub-reports using SSRS.
• Created functional specification and technical specification from business requirements document BRD.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column in SSIS.
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
• Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Generated reports using SQL Server Reporting Services and deploying them using web applications onto the web servers.
• Created jobs on daily basis and schedule on every minute to update recent data by using SQL Server Agent jobs.
• Modified existing SSIS packages for new requirements and modified existing SSRS reports to add new columns.
• Involved in improving performance tuning on SSIS, SSRS and SSAS (BI Analytics) and Involved in integration of the front end with the SQL Server backend.
• Involved in power pivot modelling such as building and maintaining power views
• Established Inner Join, Outer Join and created Indexes whenever necessary.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler and Database Engine Tuning Advisor.
• Interacted with testing team to fix the defects raised during the testing period.
• Worked closely with the developers and testing team to resolve Bugs and defects.

Confidential, Irving, TX

MS SQL Server /SSIS/SSRS Developer

Environment: MSSQL Server 2008/2012,T-SQL,ETL,SSRS,SSIS,SSAS,.NET Framework, C#, ASP.NET, Windows 7, HTML, XML, JAVA Script, MS Excel, MS Access, TFS, Remedy

Responsibilities:

• Involved in the Requirement Analysis, Design phase and Development phase of SDLC model system of ATT.
• Developed T-SQL Dynamic and Static Stored Procedures and Queries to develop Decision Engine and used appropriate Triggers
• Developed User Defined Functions for giving Scores and views for the application using T-SQL
• Created SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database
• Developed, monitored and deployed ETL SSIS packages to different environments.
• Performed ETL Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS
• Maintained Batch logging, Error logging tables and handled errors using Event handlers in SSIS
• Created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending automatic mails
• Configured Configuration files for SSIS packages to dynamically execute on QA server and Production server
• Involved in performing migration of DTS packages to SSIS packages.
• Developed Cascading, Drill-down Reports to get monthly card details and profits using SSRS
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder
• Formatted the SSRS reports using the Global variables and expressions.
• Developed SSRS report models as per end users requirements.
• Reviewed and fine-tuned stored procedures and triggers before production migration using T-SQL.
• Improved Performance by creating Clustered and Non clustered Indexes and by Optimizing the T-SQL statements using SQL profiler
• Configured and scheduled ETL auto sys jobs for SSIS packages.
• Scheduled SSRS reports using reports server to run as per business user requirements.
• Created indexes on the database tables and generated trace events to improve the query performance and optimize data access using T SQL
• Implemented the elements of T-SQL like dynamic stored procedure to store and update the information regarding residential, business and large business customers into one centralized SQL database called hub.
• Used Event Handlers and script component for Error and Exception Handling in SSIS packages.
• Scheduled, maintained, and supported the distribution and access to SSRS reports through Report Server

Confidential, Bloomfield, CT

Sr. SQL Server/BI Developer

Environment: MSSQL Server 2008/2012,T-SQL,ETL,SSRS,SSIS,SSAS,.NET Framework, C#, ASP.NET, Windows 2003/2008/2008 R2, HTML, XML, JAVA Script, MS Excel, MS Access, TFS, Remedy.

Responsibilities:

• Gathered end user requirements, developed applications and different Audit functionalities depending on the requirement acting for both system analyst and an application developer
• Extensively studied the existing OLTP system(s) to create data mart and warehouse systems using the facts, dimensions and star schema
• Wrote user requirement documents, created technical specs and design documents for various projects
• Involved in power pivot modelling such as building and maintaining power views.
• Generating Complex Transact SQL (T-SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc. Programming in SQL Server - Using Stored Procedures, Triggers, User-defined Functions, Views, and Cursors
• Involved in database design, normalization, de-normalization in building the Data Warehouse and Reporting systems
• Writing T-SQL queries (DDL and DML). Creating SQL Scripts for data loads and Upgrades for data migrations and data validations
• Involved in query tuning by creating Cluster and Non Cluster Indexes on the tables, also used Index Tuning Wizard (ITW) for enhancing the query performance
• Written complex Stored Procedures using temporary tables, table variables, error handling (TRY & CATCH) methodology for data loads
• Hands on experience in using DDL Triggers (After and Instead of Triggers) to keep track of data manipulations using Audit functionalities
• Involved in development, deployment, scheduling, and troubleshooting SSIS packages
• Involved in complex SSIS package development with Microsoft BI standards and Development strategies to pull data from various data sources such as (SQL Server, Oracle, DB2, Excel, and Flat file etc)
• Participated in upgrading from dts (MS SQL 2000) to dtsx (SQL SERVER 2005) packages and also from (2005) dtsx to (2008) dtsx
• Worked with several Control Flow Tasks, Data Flow Tasks and Transformations (Derived Column, Lookup, Merge Join, Conditional Split, Slowly Changing Dimension, and Data Conversion etc) in SSIS packages
• Used event handlers for error handling includes (On Pre Execute, On Post Execute and On Error)
• Implemented Package logging in both standard (SQL Server and file based) and custom logging using customer Stored Procedures and tables

Confidential, Foster City, CA

MS SQL Server /SSIS/SSRS Developer

Environment: MSSQL Server 2005/2008,SSRS,SSIS, Asp.Net, C#, Windows 2000/2003 Advance Server, HTML, XML, MS Excel, MS Access

Responsibilities:

• Involved in the Requirement Analysis, Design phase and Development phase of Water Fall SDLC model system of Confidential Inc.
• Developed T-SQL Dynamic and Static Stored Procedures and Queries to develop Decision Engine
• Developed User Defined Functions for giving Scores and views for the application
• Created SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS
• Maintained Batch logging, Error logging tables and handled errors using Event handlers in SSIS
• Created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files.
• Migrated Data base from Oracle to SQL Server using OLE DB provider by creating SSIS packages.
• Involved in performing migration of DTS packages to SSIS packages.
• Developed Cascading, Drill-down Reports to get monthly card details and profits using SSRS
• Formatted the reports using the Global variables and expressions.
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Logical and physical Design of the Database by creating procedures, functions and packages
• Reviewed and fine-tuned stored procedures and triggers before production migration
• Executed manual test cases by using positive and negative data inputs and verified actual results with expected results. Report results and defects using Quality Centre

Confidential

BI Developer

Environment: MSSQL Server 2008/2012,T-SQL,ETL,SSRS,SSIS,SSAS,.NET Framework, C#, ASP.NET, Windows 2003/2008/2008 R2, HTML, XML

Responsibilities:

• Interact with Business Analysts and Developers in identifying the requirements, designing strategies and to implement a reusable Database Schema.
• Develop and maintain stored procedures, functions, views, triggers, SSIS packages, SQL Server Agent jobs, C# and VB code as required
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Experienced in slowly changing dimension in SSIS packages.
• Performed incremental data load packages in SSIS.
• Developed, monitored and deployed SSIS packages.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports etc.
• Responsible for fine tuning of the database, troubleshooting, memory management.
• Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks)
• Created reports based on database usage and perform capacity planning.
• Optimized stored procedures and indexed query using Index Tuning Wizard.
• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
• Identified and Defined Fact relationships in SSAS.
• Created OLAP models based on dimension and facts for efficient loads of data based on star and snowflake schema structures.