SUMMARY:

• SQL Server / BI developer with over SEVEN years of IT experience in Database/Data Warehouse design, development & administration using Microsoft SQL Server 2014/2012/2008 R2/2008/2005, Transact - SQL, SQL Server Integration Services (SSIS), SQL Server Reporting services (SSRS), SQL Server Analysis Services (SSAS), SAP Business Objects Data Integrator (BODI).
• Extensive SQL Development experience in healthcare, logistics, retail, energy industries and insurance department with a strong understanding of data & analytics.
• Have strong experience in designing SQL Server SSIS packages (ETL) to import and transform data between databases and external data sources.
• Proficient in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Extensive experience in using all types of SQL Server Constraints, SQL Server Database design, Database maintenance, developing Transact- SQL queries, stored procedures, and triggers using SQL Servers.
• Expertise in creating/modifying Tables, Views, Stored Procedures, User-Defined Functions, indexes and Triggers and in depth knowledge in query optimization & performance tuning.
• Strong Knowledge and Experience in Business Objects tools & SAP Business Objects from 2003. Strong knowledge and Skill in Data Integrator & Data Quality Tools.
• Efficient in generating Tabular, parameterized reports, drill through, cascading parameterized, and matrix reports using SSRS 2012/2008R2/2005.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Built Universe, Reports, and Dashboards for various department needs using SAP BOBJ.
• Extensive experience in KPI based scorecards and dashboards
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports, score carding report.
• Experienced in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities. Also, experience in Optimizing MS SQL Query using tools like SQL Server Profiler, Database engine tuning advisor, and Dynamic management views.
• Experience in migration of data from heterogeneous database like Excel, MS Access, Oracle, and DB2 to MS SQL Server by using Import Export Wizard, DTS and SSIS / ETL.
• Specific tasks included assisting in the development of Balanced Scorecard, determining appropriate indicators for tracking performance, evaluating the enterprise data sources and the development of dashboards to automate the presentation of performance indicators.

TECHNICAL SKILLS:

MS SQL Server 2012/2008R2/2008/2005, Oracle 11g/10g, SAP Business Objects 4.0, Transact-SQL (T-SQL), HTML4.0, MS SQL Server Integration Service (SSIS), MS SQL Server Analysis Services (SSAS), MS SQL Server Reporting Service (SSRS), SQL Profiler, SQL Query Analyzer, Database Engine Tuning Advisor, Visual Studio 2005/2008, DTS, Microsoft Visual SourceSafe, DB2 Server, Java, C#, Erwin Data Modeler r7.2, MS SharePoint, MS Access, MS VISIO, MS Office Suite, Matlab, Auto CAD.

PROFESSIONAL EXPERIENCE:

Confidential

Software Developer

Responsibilities:

• Interpreted Business Requirement from data owner and users, translate business into data model
• Created detailed design documents from high level design documents.
• Analyzed raw data following standard normalization rules.
• Vast liaison experience, customer consultant facilitating business process integration efforts between diverse groups, communication of technical concepts to non-technical audiences.
• Created Process Maps and Process Models to clearly depict production processes.
• Utilized SSIS, VBA application to schedule daily and monthly ETL process with features including displaying error, dynamic execution, version control, and self-triggered.
• Enhanced the performance of ETL process via implementing advanced SQL skill, including customized Stored Procedure, Dynamic SQL, User Defined Function.
• Designed and generated financial report based on Data warehouse via SSRS, QlikView, and Tableau.
• Reconciled the gap among source, data warehouse, data mart, and target report.
• Minimized the gap threshold down to $1 for account level General Ledger in billions dollars size.
• Automated stored procedure to validate the Data Quality (DQ).
• Created checkpoints to ensure all the standard processes are followed and versions of product are under proper control.
• Seek opportunities to improve the executive of work, including the use of technology and enhancements to processes and procedures.
• Enforced day to day production support and provide timely resolution for any production Issues. Ensure all processes are followed diligently so that end product is up to the standard.
• Manage workload amongst offshore team members to achieve target date of different phases in development.
• Coached and guided tech/non-tech users to use our products.

Environment: Tools: MS SQL Server 2012/2008, T-SQL, SSIS, SSRS, Tableau, QlikView, SQL Profiler, SQL Query Analyzer.

Confidential, Houston, TX

Sr. Specialist ETL/SSIS/SSRS

Responsibilities:

• Major goal is to merge two applications to a single code base, pointed at a new, merged database use SSIS and SAP Data Integrator, and create business report using SSRS.
• Analyzes source system data to understand the data structure, definitions and anomalies.
• Interacts with business analysts and other technical team member as needed to better define the general reporting requirements and establish ETL design.
• Designed ETL/SSIS packages to extract data from various sources including SQL Server database, Excel, CSV, and Flat files to the Data Warehouse
• Convert the current DI ETL logic over to SSIS and merge two package streams into a common MS SQL environment packages
• Writing Stored Procedures, Functions, views, joins and open queries for SSRS reports
• Perform Bulk Insert to load data from different data sources to SQL Server and data cleansing to eliminate the incorrect and dirty data
• Write T-SQL Scripts to create Functions, Store Procedure, SQL Server Jobs, and Execution Commands
• Extensively worked with various data transformation techniques in SSIS by creating SQL as well as VB scripts, various data transformations and data flow tasks.
• Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server 2005 Analysis Services (SSAS).
• Created and maintained automating reports with SSRS subscriptions. Created Subscription of Reports in different formats to be executed automatically on weekly or monthly basis.
• Created Backups for databases and automated the process.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Schedule automated SQL jobs for daily/hourly running task to process live data change and give required technical support for any incident

Environment: SQL Server 2014/2, Server Integration Service (SSIS), MS SQL Server Reporting Service (SSRS), SAP Business Objects Data Integrator, Windows Visual Studio 2012, MS Team Foundation Server, MS SQL Profiler.

Confidential, Edison, NJ

Sr. SQL/SSIS/SSRS Developer

Responsibilities:

• Worked with business analysts to identify, design and implement solutions for (ETL) extraction and integration of data to and from databases for the purposes of data extraction and reporting using MS SQL Server Data Tools/Visual Studio 2010 Shell (SSIS/SSAS).
• Analyzing Business Intelligence Reporting requirements and translating them into data sourcing and modeling requirements including Dimensional & Normalized data models, Facts, Dimensions, Star Schemas, Snowflake Schemas, Operational Data Stores, etc.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for SAP Business Objects Universes and Reports.
• Created reports from multiple sources & functionalities like slice & dice, drill down in SAP Crystal Reports
• Designed ETL/SSIS packages to extract data from various sources like Oracle, DB2 Server, SQL Server database, Excel, CSV, and Flat files to the Data Warehouse.
• Created T-SQL triggers and Stored procedures encompassing business rules
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using
• MS SQL Profiler, index tuning wizard and SQL Query Analyzer.
• Applied various data transformations like Slowly Changing Dimensions, Conditional Split, Lookup, Fuzzy Lookup, Data Conversion, Derived Column, Sort, Merge, and Union All using SSIS/ETL.
• Secured and Configured ETL / SSIS packages for deployment to production using Package Configurations and Deployment Wizard.
• Optimized MDX query to create and maintain data warehouse fact and dimension tables and views that provide sales data to SSAS Cube and finally to SSRS Reports.
• Responsible for troubleshooting and problem solving during SSIS package development and deployment and also in scheduling jobs to call packages using SQL Server Agent.
• Aided in the design and development of reports, views, workflows, and dashboards using Visio 2010, SharePoint 2010 Designer, and Business Intelligence Development Studio (BIDS)
• Modified existing reports to accommodate changes in business needs using SSRS with gauge, dashboard, and score card.
• Monitored SQL Server Agent Jobs created to load data into data warehouse and to process SSAS cube and was also responsible to troubleshoot for any error on job failure.

Environment: DB2 Server, Microsoft SQL Server 2012, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL Server Reporting Services (SSRS), MS SQL Server Agent, SharePoint, MS Excel 2010, MS Visio 2010. SAP Business Objects 4.0, SAP BI, SAP Crystal report 2013.

Confidential, Rochelle Park, NJ

MS SQL ETL Developer/SSRS/SSAS/SSIS

Responsibilities:

• Responsible for the entire project lifecycle phases, from specifications and coding through deployment, testing, debugging, documentation, and maintenance.
• Created ETL/SSIS packages to extract data from various sources like SAP, Teradata, Excel, Flat files and Oracle to SQL Server systems using different SSIS components and used dynamic configuration files and variables for production deployment.
• Performed data cleansing by creating staging tables to eliminate the dirty data using MS SQL Server Integration Services 2008 (SSIS).
• Coordinated with the business users to design and develop reports that improved the access to financial and order management data using SSRS 2008.
• Worked with advanced data regions like Tablix, Matrix, Gauges, Charts, Rectangle, and Textboxes and generated Sub-Reports, Drill down reports, Drill through reports and parameterized reports using MS SQL Server Reporting Services (SSRS).
• Generated report in Excel Power Pivot using SSAS Cube.
• Developed SSRS solution for the business users to insert/update/delete the data directly into database tables using SSRS report and this solution helped in minimizing user requests.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder
• Developed MDX Scripts to provide a specialized syntax for querying and manipulating the multidimensional data stored in OLAP Cube (SSAS).
• Involved in designing, reviewing, and creating primary objects like Views, Indexes, Stored procedure,
• Functions, Triggers based on logical design models, user requirements and physical constraints using T-SQL in MS SQL Server Management Studio 2008.
• Created various ad-hoc reports by defining SQL queries within excel that helped refreshing the data directly from the SQL databases on weekly and monthly basis.

Environment: Windows 2008 Server, Microsoft SQL Server 2008/2008 R2, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS), C#, MS SQL Server Agent, MS Excel 2007, Oracle11g, TOAD for Data Analysts, SQL Assistant, Crystal Report.

Confidential, Edison, NJ

MS SQL Server /BI (SSIS/SSRS) Developer

Responsibilities:

• Developed system standards, architecture, scenarios, detailed screen specifications and documented logical and physical data model using Erwin Data Modeler.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the products data from various source systems feeds using SSIS.
• Worked extensively with MS SQL Server Integration Services (SSIS) to import, export and transform the data between the linked servers.
• Created packages using MS SQL Server Integration Services (SSIS) for data extraction from Flat Files, Excel files, OLE DB source to data warehouse.
• Used SSRS to create reports, customized reports, On-Demand reports and Ad-Hoc reports and involved in analyzing multi-dimensional reports in SQL Server Reporting Services 2005.
• Designed Dashboards, Scorecards and reports using multiple KPI's, OLAP charts and SSRS Reports
• Worked with BCP utility and Bulk Insert to load data from different data sources to SQL Server.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Managed users including creation/alteration, grant of system/database roles and permission on various database objects.
• Tested and configured automated routine maintenance tasks like performance tuning, indexes and stored procedures, checked deadlocks and created jobs and scheduled them.
• Detailed documentation on SharePoint of all the migrations, procedures and packages for future references.

Environment: Windows 2008 Server, MS SQL Server 2008/2008 R2, SQL Server Management Studio, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), T-SQL, MS Excel 2003, and CA Erwin Data Modeler r7.2.