SUMMARY:

• 8+ years of experience in  T- SQL/BI Development / Reporting Environment.
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, CTEs, Joins, Sub Queries, Functions, Cursors and Indexes using SQL Server with T-SQL.
• Expertise in High Level Design of ETL SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert .
• Hands on experience with performing various SSIS data transformation tasks like Look-ups, Joins, Conditional Splits, Derived Column and Event Handlers, Error Handlers etc.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services and SQL Server Integration Services (SSIS) (2005/2012).
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Expertise in generating Parameterized report, Drilled Report, Drilldown Report, Sub Report in SSRS.
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Better understanding of tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Problem Solving and taking code level technical decisions
• Excellent team oriented and interpersonal skills, Quick Learner.
• Ability to work in tight schedules and efficient in meeting deadlines.
• Experience in Mentoring staff on the effective utilization of technical architecture and Code Reviews.

TECHNICAL SKILLS:

Databases: SQL Server 2012, SQL Server 2005,SQL Server 2000, Postgre SQL, SqlServerCE

Reporting Tools: SSRS Reports, Crystal Report

Business Intelligence: SSRS/SSIS

Languages: SQL, PL/SQL, Python, XPath, XQuery, XSLT Visual Basic 6.0, C#.NET

Development Frameworks: Microsoft .NET Framework 2.0, Compact Framework

Concepts: Object Oriented Programming Concepts

Tools: Visual Studio, MS Visio, Crystal Report, SQL Query Builder, Windows CE Emulator

Web/Application Servers: IIS

Version Control: Microsoft VSS

Operating Systems: Windows

PROFESSIONAL EXPERIENCE

SQL DATABASE ANALYST / BI Developer

Responsibilities:

• Worked on entire ETL process work flow for various clients including but not limited to - Extract feed file in various format, Transform & load data in particular modules, Archives feed files, Generated audit log files, Email notification with summary.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Carried out below activities for migration from Odyssey to SantaCruz
• Performed the detailed analysis of the existing Odyssey database and generated the mapping rules for various DB entities between Odyssey and SantaCruz.
• Rolled out the various SSIS packages under SantaCruz product at various clients that helps to migrate the existing data from Odyssey to SantaCruz efficiently.
• Design and developed the script to generate the test data to verify SSIS packages.
• Performed detailed analysis of existing data issues and generated various exception reports.
• Keep the higher management up to date with the detailed status report.
• Carried out below activities for SantaCruz enhancement / customization for various clients
• Scheduled the SSIS Package to create various reports and email them as an attachment.
• Migrated the existing older DTS packages (developed using BIDS) to SSIS packages.
• Used environment variables to populate config parameters at runtime to SSIS packages in order to make them generalize and configurable to use at various clients.
• Created SQL Jobs which run on predefined Schedules to run SSIS packages or SQL scripts.
• Worked on ADHoc support queries for individual client and export the report data in excel files and emailed to client.
• Worked as L2 support to resolve the client queries / defects on timely manner.

Environment: SQL Server 2008, SQL Server 2012, ETL, SSIS.

Sr. Developer

Responsibilities:

• Individually worked on the whole system and implement it from scratch.
• Designed and developed all the modules of the system e.g. Order management, Inventory management, Promotion, Price management, Label Creation, Receive Data, File Send etc.
• Created Complex Views on BOS SQL Server System which is used in the SQLCE RDA PULL methods to refresh the database on the Handheld in Receive Data module.
• Designed and developed the File Send module to transmit the module related files from Hand Held to BOS using socket programming. A windows service was created which act as a listener at BOS, while on HHC, a client was created which send request to listener to receive file from HHC.
• Involved in Unit testing of the code using the Windows CE Emulator.
• Involved Patch release and deployment of the code in form of cab files on the actual device.
• Provided support (on call as well as using remote login) and bug fixes for the system.

Environment: Windows CE V5.0, Windows CE Emulator, SQL Server CE 2.0, .Net 2005, .Net Compact Framework, Microsoft ActiveSync, SOTI Pocket Controller, Team viewer, Ultra VNC.

SQL Developer

Responsibilities:

• Played key role in enhancement of existing system as well as development of new features on the system.
• Develop the various customized inventory reports as per client needs e.g. Day-end Reports, Shift Close Report etc.
• Created SQL Server Jobs to take BOS and Till Backup on scheduled interval.
• Provided support and bug fixes for the system.
• Unit testing of the code.
• Patch release and deployment of the code.

Environment: Visual Basic 6, Microsoft VSS,SQL Server 2005, Crystal Report, Team viewer, Ultra VNC.

Data Analyst

Responsibilities:

• Was responsible for requirement analysis and screen mock up design for various modules and Database Design.
• Developed the Promotion and Data transmission modules. Data Transmission from HO to BOS is implemented using linked server open query.
• Created SSIS Package to read promotion file from Excel into BOS system.
• Developed different consolidated store wise reports for Head Office using crystal reports.
• Provided support (on call as well as using remote login) and bug fixes for the system.
• Unit testing of the code.
• Patch release and deployment of the code.

Environment: Visual Basic 6, Microsoft VSS, SQL Server 2005, Crystal Report, Team viewer, Ultra VNC.