SUMMARY

• 7+ years of strong MS SQL Server Developer experience in Finance, Healthcare, Airline and Insurance domains with expertise in MS SQL Server /2005/2000 suite of products like SSIS, SSRS and SSAS.
• 7+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2014/2012/2008 R 2/2008/2005/2000 in Development, Test and Production Environments with various business domains.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T - SQL.
• Extensive experience with data modeling techniques, logical and physical database design.
• Expert Knowledge of Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.
• ExpericeCreating, deploying SSIS Packages and migrating DTS Packages from /2008/2008 R 2/2012/2014.
• Created SSIS packages using SSIS 2005/2008R 2/2012/2014. Perform Logging, Package configuration, event handling, Created package dynamic with expression and variable.
• Experience in creating indexed views, complex stored procedures, effective triggers and useful functions to facilitate efficient data manipulation and consistent data storage.
• Experience in writing complex SQL queries involving multiple tables With different SQL joins, Dynamic SQL, Triggers, Functions, indexing, Merge commands, Views.
• Expertise in solving performance issue with SQLPerformace tools Like SQL Server Profiler and DataBaseTunning Advisor. Used SQL Server profiler to track error issue in Crystal reporting.
• Created drilled down, Praramiterised report, drill through report, Sub report with sql server reporting service 2008/2012. Experience in creating month end report with Crystal reporting. Used cube as a source of reporting for Herichy level report.
• Experience in Dimensional Modeling, Designing of STAR and SNOW FLAKE Schemas.Expereince with designing project based in business requirement. Experince in performing impact analysis.
• Created Reports with complex formulas and to query the database for business Intelligence.
• Experience in enhancing and deploying the SSISPackages from development server to production server
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS). Experience in Creation and deployment of cubes on SSAS.Experience in Creation and deployment of cubes on SSAS.
• Experienced in installing, configuring and deploying MS SQL Server suite of products that includes SQL Server Integration Services, SSRS, SSAS;
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SSIS, BCP and DTS utility. Extracting, Transforming and loading of data using SSIS and DTS;
• Dimensional Data Modeling and Cube Development in SQL Server in SQL Server 2008 R2/2008/2005; Refresh Cubes with analysis processing Task.
• Experience in data normalization and data modeling using Erwin;
• Working Experience in documenting complex database applications, and data;
• Strong knowledge in SQL Server disaster recovery, backup/restore, migration and upgrade participated in disaster recovery drills;
• Expertise in migrating data from MS-Access, MS-EXCEL and other external data sources.
• Good understanding in Oracle 9i/10g Database and Teradata SQL Version 11.0.
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance. Have created filtered index, covering index.
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Have experience in hading production support, client and application server.
• Experience in Tuning SQL queries and T-SQLqueries, MDX & improving the performance of the queries.
• Worked Extensively on ETL process using SSIS package.
• Experience in using variables, expressions and functions and also defining Query for generating drill down reports in SSRS.Migration of SSRS reports from SQL 2012 to SQL 2014.
• Experience in leading team of 15 members. 3 years of experience in leading offshore team. Expertise to complete project in hard deadline with availibiltyof 24*7.
• Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills and familiar with offshore and multi site development.

TECHNICAL SKILLS

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS)

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS), Visual Studio 2010,2014

Reporting Tools: SQL Server Reporting Services (2005/2008 R2,2012,2014), MS Access, MS Excel

Database: MS SQL Server 2014/2, MS Access, Oracle 9i/8i

Programming: T-SQL, PL-SQL, C

Web Technologies: HTML, DHTML, XML, XSL, Java Script (Validation), CSS, PERL

Operating Systems: Windows (95/98/2000), Windows 2003/2008 Server, Windows XP, Windows Vista

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, ERWIN, Adobe Photoshop, Abode Flash.

PROFESSIONAL EXPERIENCE

Confidential, Mahwa, NJ

Sr. SQL and ETL Developer

Responsibilities:

• Developed Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Created and reviewed the conceptual model for the EDW (Enterprise Data Warehouse) with Business user
• Analyzed the source system to understand the source data and table structure along with deeper understanding of business rules and data integration checks.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules
• Create automation process to archive historical data.
• Interacting with Onsite people, Taking clarifications regarding applications.Involved in writing SQL queries
• Analyzing the requirements and discussed with managers and leads on the functionality.
• Participate in Walk-through sessions with onsite people
• Designed and Implemented Tables, Functions, Stored Procedures and Triggers in SQL Server 2014 and 2012
• Wrote the SQL queries, Stored Procedures and Views using SQL Server 2014 and SQL Server 2012.
• Built data connection to the database using MS SQL Server.
• Regression testing was performed after each new build of the application.
• Defect logging and Defect follow up in Team Track
• Have worked with Database testing and SQL queries and Preparing Status reports
• Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression (CTE).
• Designed Cubes with Star Schema using SQL Server Analysis Services 2012 (SSAS). Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server 2012 Analysis Services (SSAS).
• Used scripts and variables, email notifications for ETL process using Data Integrator.
• Experience in creating complexSSISpackagesusing proper control and data flow elements with error handling.
• Designed Data flows, Workflows and jobs to load data from source to target in BO Data Integrator.
• Enhancing and deploying the SSIS packages from development server to QA, UAT and PRODUCTION server.
• Designed and built OLAP cubes to meet reporting needs.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases.
• This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Backup and restore automation using most recent backup archive. Developed an auto-restore process using TSQL.
• Have created Archiveal process to Delete and Archival of data from production server to archival server.
• Lead the offshore team and was main point of contact for production Issue and Production Support.

Confidential, Morris Plains, NJ

Sr. SQL Developer

Responsibilities:

• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Understanding the Reporting design requirements from the Architects and Business Analyst.
• Interact with SME’s and End Users for requirement gathering, process improvement, problem identification, project analysis & review meetings and progress reporting.
• Designed SSIS package for automatic data migration to transform Data from SQL Server 2000 to SQL server 2008.
• Understanding the OLAP processing for changing and maintaining the warehousing, optimizing Dimensions, Hierarchies and adding the Aggregations to the cube.
• Responsible for Process CUBE Partitions and Dimensions.
• Involved in writing MDX queries for various calculated members.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server Analysis Services (SSAS)-2008/2005.
• Well versed in defining/creating and handling Data Sources, Data Source views and parameterized Reports in SSRS 2008.
• Designing OLAPcubes, Data Modeling, Dashboard Reports, and scorecards according to the business requirement.
• Served as technical expert guiding choices to implement analytical and reporting solutions for complex financial scenarios.
• Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL.
• Design and develop SSIS (ETL) packages for loading data from Oracle and Flat files (3GB) to SQL Server Database.
• SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Participated in creating Jobs for various packages that run at specific schedule every day based on some dependencies.
• Created clustered and non-clustered indexes on tables for new database to faster retrieval of data for the Reports.
• Managing the Report Server contents with Admin privileges and Report Manager for Subscriptions, Snapshots and Security Content on the reports
• Helped Quality Assurance Team to generate Test Plans and Test Executions.

Confidential, Parsippany, NJ

SQL Server2012 AND 2008 and ETL Lead

Responsibilities:

• Interacted with end users in identifying the requirements and developed a detailed design document including technical specification
• Assembled and converted user requirements from multiple clients into our standard reporting solution and customized specific client requests when necessary.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Created Teradata External loader connections such as MLoad, Upsert and Update, Fastload while loading data into the target tables in Teradata Database.
• Did error handling and performance tuning in Teradata queries and utilities.Prepared the complete data mapping for all the migrated jobs using SSIS.
• Created drill down, drill through, sub and linked reports using MS SSRS 2008 as well as managed the subscription of the reports.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Have created complex packages for sending excel reports and Sending report in body of the email with XML configuration.
• Generated multi parameterized reports in MS SSRS 2008 allowing users the ability to make selections before executing reports; thus making them user friendly.
• Created report at all-time level hierarchy like hourly, daily, weekly, monthly, yearly.
• Created Holiday reporting andMonthlly reporting with crystal report 2011.
• Involved in creating multi-tiered and multithreaded applications using .Net framework.
• Analyzed the user requirements and defined technical specifications. Involved in all activities of Software Development Life Cycle (SDLC).
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks.
• Participated in Requirement gathering and analysis to check feasibility of data and created physical and logical data models for walkthroughs
• Created data mover Job to refresh the data from production to Development on daily basis which helped the developer for quality analysis
• Supported daily batches and worked on production issue and tickets based on priority.
• Performance tuning, optimization of procedures and queries and also support, maintain, monitor and tune database systems.
• Good knowledge on Agile Methodology and the scrum process.
• Loaded data from source system to Teradata and Sql objects with the help of SSIS packages.
• Performed purging of 100 million records from the production fact tables to improve performce of Database server and reporting.

Confidential

MS SQL/SSIS/SSAS Developer

Responsibilities:

• Assisted in Business Analysts to gather technical requirements.
• Created Indexes to get the high level performance.
• Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules
• Responsible for tuning T-SQL procedures, triggers and other database objects
• Fine tuned and checked the performance of existing objects in SQL Server and implemented transactional logic for them
• Installation of SQL Server on Development and Production Servers, setting up databases, users, roles and permissions.
• Responsible for all technical SQL Server database operations, Administration, ongoing development for various in-house databases.
• Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Designed and developed DTS packages for transferring data from flat files and Access files
• Created linked servers between different SQL Servers and also created linked server with different access files used across various departments
• Performing the ETL operations to support the data loads and transformations using SSIS.
• Involved in migration from Oracle to SQL Server 2005 using SSIS.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.
• Maintained databases, performed software installations and upgrades, monitored Database Performance.
• Implemented automated backup and database maintenance / cleanup jobs.
• Managing Logins, Users, Roles and User permissions.
• Running Trace from the Profiler to trouble shoot database and running DBCC consistency checks for other database maintenance aspects.
• Designed numerous ad-hoc and custom reports using SQL Reporting Services.
• Created various Tabular and Matrix Reports using SSRS.
• Created and scheduled jobs for various tasks and also was responsible for maintaining jobs.