PROFESSIONAL SUMMARY:

• 16+ years solid SQL Server database Development experience
• Excellent experience in Software Development Life Cycle (SDLC) and project management methodologies
• Expert level skills in Database Design and Data Modeling and Database Normalization
• Excellent experience in SQL Server and T - SQL in constructing Triggers, User Defined Functions, Stored Procedure, Views, Indexes.
• Relational database models, data dictionaries, and data integrity
• Excellent experience in Query Optimization
• Excellent experience in creating reports using SSRS
• Excellent experience in Analysis using SSAS
• Expert level skills in ETL in various file sources using SSIS
• Extensive experience Crystal Report, SSRS, MS Access, Business Intelligence and Visual Studio, Excel PowerPivot, PerformancePoint on Sharepoint
• Proficient with creating Dataflow Diagram, Entity Relationship Model
• Excellent communication, presentation and interpersonal skills
• Strong troubleshooting and organizational skill.
• Dimension Modeling & Data Ware Housing
• Designing facts and dimensions
• Extract, Transform and Load (ETL) data. Solve data management problems by migrating and processing data. Enhance package functionality with scripting. Implementing loops to import multiple files. Handling errors and managing exception rows. SSIS Package Performance Tuning & Best practices. Deploy packages to an SSIS server. Administering the storage, security and execution of packages.
• Producing table and matrix report with drill down and drill through functionality. Produce reports with enhanced visualization features such as charts, map and gauge. Integrate parameters, filters and interactive components into reports. Create reports on SSAS cubes with Report Builder. Deploying reports to the Report Server. Creating cached instances, snapshots and subscriptions. Configuring and testing security on report items. Report performance tuning
• Creating and deploying a cube. Extend hierarchies and exploit advanced dimension relationships. Configuring many-to-many dimension relationships. Building aggregations with the Aggregation Design Wizard. Implement Key Performance Indicators to monitor business objectives. Cube storage mode - MOLAP, ROLAP and HOLAP. Implementing an action to open a Reporting Services report or to analyze data using Excel. Automating cube processing with an XMLA script
• Tabular analysis model. Basics of in memory processing. Multiple dimensional model and tabular analysis model. Creating and deploying a tabular analysis cube. Building hierarchy and dimension relationship. Implement Key Performance Indicators to monitor business objectives. Query language DAX
• MDX Queries

AREAS OF EXPERTISE:

Technology: SQL Server 2000/2005/ 2008/2012/2014 T-SQL, ETL, SSIS, SSAS, SSRS, Data Modeling

Performance Tuning: Query Optimization, Table Partitioning, Installation, Upgrade, & Migration

Operating Systems: Windows Platforms

Applications: Ms Access, Crystal Report 8.5/9/10, Crystal Enterprise 10, Ms Data report, Excel PowerPivot and PerformancePoint on Sharepoint Progress 8.0. 8.1, 8.2 / Visual Studio, Business Intelligence

Client / Server Protocols: HTTP, TCP/IP, FTP

PROFESSIONAL EXPERIENCE:

Confidential, Ridgewood, NJ

SQL Database Developer

Responsibilities:

• Created Normalized Database Design
• Created Data model and ERM
• Created relational tables.
• Developed a process that will load data from staging table into different related tables.
• Scheduled Jobs
• Created partitioned table for the claims submitted to vendors for the data analysis
• Created column store index in the partitioned table
• Developed stored procedures, triggers, views, user defined data types and functions.
• Performance Tuning of MSSQL Server using SQL profiler.
• Query optimization.
• Created/modified table index.
• Create additional coding to retrieve data more efficiently using indexes
• Migrate from Development environment to Production environment.
• SQL Server Agent Jobs

Environment: MSSQL Server 2014

Confidential, West Caldwell, NJ

SQL Database Developer

Responsibilities:

• Developed table relationship model using Visio
• Developed Systems for each Pharma Clients
• Created Systems Design from scratch
• Created relational tables.
• Developed Data warehouse
• Maintained Data warehouse using ETL package.
• Created multi-dimension model using SSAS
• Created and Deployed cubes
• Created various reports using SSRS
• Sending emails/reports.
• Developed SSIS packages for importing/exporting files (text files, csv, excel files).
• Developed stored procedures, triggers, views, user defined data types and functions.
• Performance Tuning using SQL profiler and Database Engine Tuning Advisor.
• Query optimization and Execution Plan.
• Created/modified table index.
• Create additional coding to retrieve data more efficiently using indexes
• Migrate from Development environment to Production environment.
• SQL Server Agent Jobs

Environment: MSSQL Server 2008 R2 /2012/2014/SSIS/SSRS/SSAS/PerformancePoint on Sharepoint

Confidential, NJ

SQL DBA / SQL Developer

Responsibilities:

• Developed table relationship model using Visio/ERWIN
• Created ETL package using SSIS
• Implemented ETL Frameworks for effective error handling/package logging.
• Created various reports using SSRS
• Created Multi-Dimension Model
• Merged Global Data from four Regions eg: LA, NA, EMEA and APAC
• Developed JnJ Global Procurement Data warehouse.
• Maintained Data warehouse using ETL package.
• Created SSIS package to integrate data to the JnJ MDM environment.
• Developed queries to extract / load the Business Plan and various excel reports.
• Grant user’s access to the database and assign database role based on the user level permission.
• System analysis and design
• Developed stored procedures, triggers, views, user defined data types and functions.
• Added/Changed Tables, columns, triggers, and T-SQL code. Used Indexes, Views, Triggers, and Stored Procedures for updating and cleaning the existing data and also the new data which comes in
• Performance Tuning using SQL Profiler and Database Engine Tuning Advisor.
• Revised Stored Procedures and Triggers
• Import and Export of new functions to client database
• Design of the database and the tables
• Create additional coding to retrieve data more efficiently using indexes
• Create VBA codes to process and format
• Query optimization and Execution Plan.
• Created and deployed cubes for efficient reporting using SSAS and SSRS.

Environment: SQL Server2008R2/2012/2014/SSIS/SSRS/SSAS/Visual Studio/Business Intelligence/ MS Visio / ERWIN / VB Script / MS Access / Perfomance Point on Sharepoint

Confidential

SQL DBA / Programmer / Analyst

Responsibilities:

• Table relationship model using Visio
• Interface Machine(Smart Cards, Biometrics, Smoke Emission Testing Machine, Passport Readers)
• Design and Setup database structure
• Design and Program front-end interface
• Create Stored Procedures and Triggers
• Create Report Layout
• System testing and debugging
• Data integration using SSIS package
• Created and implemented ETL Framework
• Maintaining and updating Data warehouse
• Created and Deployed cubes for various reports using SSRS
• Designed, implemented databases in SQL Server 2000 and SQL Server 2005
• Maintained databases, configured permissions, and conducted backup and recovery
• Developed stored procedures, advanced queries, trigger, views, indexes by using T-SQL
• Responsible for tuning data, indexes, and queries
• Reports generating using Crystal Reports 9
• Configured securities and accesses to production databases and database servers
• Provided technical support to internal developers and external clients
• Developed stored procedures, triggers, views and added / changed tables for data load and transformation, and data extraction.
• Data Warehousing.
• SSIS package integration using various type of data source connection.
• Created cubes for Reporting.

Environment: SQL Server 2000, SQL Server 2005, Windows 2000 Server, MS Access 2000, and MS Excel 2000, Crystal Reports 9.

Confidential

Programmer / Analyst

Responsibilities:

• Manages the Systems Analysis, Quality Assurance, Development, Technical Documentations and Training Departments
• Identified and controlled all project progress and directly reports to the General Manager.
• Ensures superior level of customer satisfaction by hiring and retaining talented staff and providing technical and service skills trainings along with measurable standards of service performance
• Design and implementation of new systems enhancements to meet client demands
• Reprogrammed and Tuning of Stored Procedures, Triggers and Views
• Restructuring of Database Design
• Conduct systems requirement and cycle test
• Responsible in generating various reports using Crystal Reports 9
• Daily summary reports
• Weekly summary reports
• Monthly summary reports

Environment: SQL Server 2000, Windows 2000 Server, MS Access 2000, Crystal Reports 9 and MS Excel 2000.

Confidential

Programmer / Analyst

Responsibilities:

• Design and Setup database structure
• Design and Program front-end interface
• Create Stored Procedures and Triggers
• Generate Reports using Crystal Reports 9
• System testing and debugging
• User support and maintenance
• Support and maintenance of the systems
• Create Implementation Manuals, User’s Requirement Manuals and Technical Documentations
• Conduct cycle reviews and user’s acceptance trainings