SUMMARY:

• 10+ 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:

Confidential, Paramus, NJ

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.

Confidential, Brooklyn, NY

SQL Developer/ BI Developer

Responsibilities:

• Create stored procedures and SSIS Packages to collect Accounts data from different sources.
• Interaction with clients while business requirements, design & implementation phases.
• Performed Query optimization for slow stored procedure.
• Used Dynamic SQL for the data retrieval and to insure a flexible process in a constantly changing environment.
• Created stored procedure which well suited for distributed databases and linked server.
• Involved working with data validation logic for all source data and load them in data warehouse using SSIS Package.
• Created different types of reports such as drill down, drill through, parameterize and dash board reports and schedule them according to business requirement using SSRS.
• Generating on-demand, ad-hoc, custom reports for business analysis and management decision using SSRS.
• Created and published reports on Power BI which works on regular and mobile browser.
• Involved designing a process that stores aggregated value to optimize reporting.
• Design, develop & test the ETL processes according to industries best practices using SSIS.
• Used various sources other than SQL Server for SSIS Package such as Flat File, Excel, DB2.
• Used SQL Server agent to schedule and deploy SSIS Packages and Stored procedure.
• Configured and deployed SSIS packages in both Dev and QA environment.
• Extensively used various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers & import/export wizard while developing packages.
• Wrote complex T-SQL and PL/SQL queries, stored procedures, views, triggers, functions, table variables, and cursors as per business requirement.
• Involved creating indexes, constraints & business rules wherever applicable.
• Used SQL profiler for performance tuning & debugging issue whenever necessary.

Environment: MS SQL Server 2012/2008, SSIS 2012/2008, SSRS 2012/2008/2005 , Excel, T-SQL.

Confidential

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.

Confidential

Sr. 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.

Confidential

Sr. Developer

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.