PROFESSIONAL SUMMARY:

• Over 7 years of IT experience in Design, Development and Maintenance of Database applications using SQL Server 2012/2008R2/2008/2005.
• Expertise in scripting DDL, DML, T - SQL (Complex VIEWS, Stored Procedures (SP), Functions, Triggers and Indexes).
• Good experience and understanding of Database Design, Relational Integrity Constraints, OLTP, OLAP and Normalizations.
• Good Experience in Tuning SQL Queries by implementing Indexes and using Stored Procedures.
• Good Experience in Extraction, Transformation and Loading (ETL) in SQL Server database using SQL Server Integration Services (SSIS) .
• Experience in Implementing Checkpoint, Transactions, Logging.
• Experience in building Package Deployment and Package Configurations.
• Good Experience in Creating and Scheduling Jobs for SQL Server Database and SSIS packages using SQL Agent.
• Good experience as a Data Analyst with solid understanding of Data Modeling, Evaluating Data Sources and strong understanding of Data Warehouse/Data Mart Design, ETL, BI, OLAP, Client/Server applications.
• Proficient in developing all types (Tabular, Matrix, List, Drill-Down, Drill-Through, Sub-Reports, and Chart Reports) of Complex Reports using SQL Server Reporting Services (SSRS).
• Experience in Implementing Dynamic Grouping, Sorting & Page Breaking using SSRS Parameters.
• Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Good Experience in Managing/deploying reports to both the modes/environments (SharePoint and Native-Report Manager).
• Expertise in Subscribing Reports (Standard and Data Driven Subscription) using SSRS in both the modes (SharePoint and Report Manager).
• Knowledge on Tableau reporting tool for visualization.
• Expert in troubleshooting/resolving SQL Reporting services and SQL related issues.
• Good Knowledge in SQL Server Analysis Services (SSAS) 2012/2008R2/2008/2005).
• Used SSAS Cubes as data source for Reports Development.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down and Drill-through reports using SSRS.
• Worked on Power BI and prepared dashboards using Tableau to make it more attractive.
• Experienced in developing ETL packages using SSIS SQL Server Integrated Services.
• Abilities to perform VB .NET programming, Experience of LAN administration
• Excellent skills in PC Client/Server software installation and troubleshooting.
• Improved Supply Chain processes at three different companies resulting in 5 percent to 25 percent reduction in the cycle time of information and material.
• Built backend Excel, Access, 1010, JDA, WMS and other system queries to feed reports and automated tasks
• Lead Supplier review and rationalization which resulted in 15 percent improvement in quality and service.
• Extensive Knowledge on Microsoft .NET Design Patterns including Dependency Injection (DI), Inversion of Control (IOC), Singleton, MVVM and MVC .
• Developed SSIS packages bringing data form various heterogeneous sources like:
• Oracle, SQL server and OLEDB sources. Also did transformations like Execute SQL Task, Conditional Split, Merge, Lookup, fuzzy Lookup and Slowly Changing Dimension while loading the data into destination.
• Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables
• Very good experience in Installation, configuration and maintenance of SQL Server.
• Performed Unit Testing for migrated procedures, functions and RDLs.
• Experience in Software Development Life Cycle (SDLC) including requirements gathering, writing technical specifications and Production support/Maintenance Activities.
• Expert in developing Windows applications, web applications, windows services and web services in Microsoft visual studio, .NET IDE using C# .Net 1.1, C#.Net 2.0, VB .NET, ASP.NET, ADO.NET and Sql server.
• Proficient in developing SOAP and RESTful Web Services.
• Experience in Object-Oriented Programming within networks as well as online applications
• Self-starter and quick learner with strong analytical and problem solving and troubleshooting skills.
• Good Experience in Agile Methodology and Water Fall Methodology
• Good Experience in Logistics, Retail, Insurance.

TECHNICAL SKILLS:

BI Data Warehouse Tools: SSRS, SSIS, SSAS, Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, Sharepoint.

Databases: MS SQL Server 2012/2008/2005, MS Access, Oracle.

Languages: C,C++,HTML,XML,T-SQL,MYSQL,DHTML,VB.NET,JavaScript,.Net, PHP,PLSQL, VB script, Web Services, Python.

App. /Web Servers: IIS 5.0/6.0

Reporting/ETL: SSRS, SSIS, SSAS, Report Builder.

Platforms/OS: Windows 98/2000/2003/ XP/NT/Vista, Windows 7

Version Control Tools: Team Foundation Server, SVN

Microsoft Technologies: ASP.NET 1.1, ASP.NET2.0, VB.NET, C#.NET, ADO.NET, ADO, ASP

Others: SQL Server Data Tools, BIDS, SQL Server Management, Studio, Visual Studio.Net 2005/2008/2010, Office 2005/2008/2010, FTP, Share Point 2007/2010, JIRA

PROFESSIONAL EXPERIENCE:

Confidential, Secaucus, NJ

SQL/SSIS Developer

• Created PL / SQL Procedures, Functions, Packages, Views, Materialized Views, Triggers.
• Creating PL / SQL triggers, sequences, and stored procedures using Toad and SQL Developer Continuous review of Business critical Database to proactively identify space issues, performance tuning issues
• Integrated Custom Visuals based on business requirements using Power BI desktop. Estimation, Requirement Analysis and Design of mapping document and Planning for Informatica ETL .
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards with Power BI service. Published the dashboard reports to Power BI service for navigating the developed dashboards in web.
• Involved in designing STAR Schema for the business processes.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, the Mapping Designer to map the sources to the target.
• Involved in loading of data into different databases Oracle , SQL server from legacy systems and flat files using complex scripts.
• Implementation of MS SQL Server 2008/2005 Management studio to create Complex Stored Procedures, User Defined Functions (UDFs) Views using T-SQL to evaluate result for the reports.
• Responsible for installation and Configuration of SQL Server 2005 and 2008 database and configuration of Report manager.
• Responsible for performing T-SQL tuning, multi tasking and optimizing queries for reports which take longer time in execution with SQL Server 2008/2005.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
• Developed, deployed, and monitored SSIS Packages.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005/2008.
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts. Involved in the continuous enhancements and fixing of production problems clients. Worked on Cascading Style Sheets and XML- Schemas.
• Developed SQL Queries and Procedures for storage and retrieval of data using ADO.Net and LINQ to SQL. Developed Web Services for user authentication and file transfer.
• Developing Database Triggers to audit the sensitive data of the table along with user information and to enforce complex business rules.
• Generated server side PL / SQL scripts for data manipulation, validation and materialized views for remote instances
• Improved the application performance significantly by tuning SQL Queries and PL/ SQL program units. Responsible working with user groups, analyzing reported problems, performing root cause analysis and presenting alternatives to correct the problem.
• Wrote complex SQL queries using Joins, sub queries and inline views to retrieve data from the database.
• Created Cursors, Collections and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• Involved in Data Extraction, Transformation and Loading ( ETL process) from Source to target using PL/SQL.
• Designing data models, contributed to the overall design and implementation of the data warehouse.
• Participated in all data warehouse planning and execution.
• Responsible for implementing and maintaining commercial ETL application(s) and integrating them into the data warehouse environment ( SSIS ).

Environment : MS SQL Server 2012/2008/2005 Enterprise Edition, SSIS 2008R2, SSAS 2008R2, SSRS 2008R2, T- SQL , VSS, Windows Sever 2000/2003/2008, SQL Server Management Studio, SQL Profiler, Query Analyzer, MS Visio , Power BI, ASP .NET2.0, C#.NET, ADO.NET , Microsoft Visual Stuidio.NET 2005

Confidential, Piscataway, NJ

SQL/MSBI developer

Responsibilities:

• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Experienced in writing complex SQL Queries, complex Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non clustered indexes.
• Created SSIS packages to create csv files and excel sheets.
• Created global temporary tables in the Execute SQL SQL task and created reports based on the global temporary tables inside the data task flow.
• Used Package Configurations to make the SSIS Package reusable in any server.
• Used Execute SQL Task, Data flow Task, Sequence Container, For Each Loop Container, File System Task, Execute Package Task.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS /DTS using various features like data conversion etc.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages .
• Created SSRS reports like tables, matrix, charts, sub reports, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created reports based on both cascading and standard parameters.
• Created different Parameterized Reports ( SSRS 2012/2008) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Designed and built cube using SQL server Analysis Services for salary analysis.
• Worked on dimensional data modeling, dimensions and facts for OLAP cubes configured report server environment and deployed reports to the database.
• Extensive experience in SSAS ( SQL Server Analysis Services), Design and Developed cubes testing and Deployment/ Implementation.
• Experience in writing complex MDX queries for calculated members and measure groups.

Environment : MS SQL Server 2012/2008/2005 Enterprise Edition, SSIS 2008R2, SSAS 2008R2, SSRS 2008R2, T- SQL , VSS, Windows Sever 2000/2003/2008, SQL Server Management Studio, SQL Profiler, Query Analyzer, MS Visio .

Confidential, Ivyland, PA

SQL/MSBI Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012 and Flat files. Created packages with different Control Flow options and Data Flow Transformations such as Conditional Split, Multicast, Pivot, Union All etc.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation. Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Advanced extensible reporting skills using SQL Server 2012 Reporting Services (SSRS).
• Worked in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services ( SSRS ).
• Worked on dimensional modeling, creating cached reports, drill-down reports, linked reports, report snapshots, parameterized reports and report optimization Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2012.
• Involved in designing Parameterized Reports for generating Ad-Hoc reports as per the client requirements.
• Expertise in providing comprehensive solutions in multi-industry, multi-cultural environments. Exceptional project management skills with vast experience in working within tight time frames
• Review and approve quotations from contract manufacturers by following cost review procedures that in corporate the analysis and calculation of cost of goods sold (COGS).
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in upgrading from SQL Server 2008 to SQL Server 2012. Migrated SQL server 2008 R2 packages to SQL Server 2012 SSIS packages using SQL Server 2012 Upgrade Advisor.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.

Environment: SQL Server 2012/2008/2005 Enterprise Edition, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS),TSQL,C#, .Net framework, XML, MS Visual Source Safe and Windows Server 2003 , Oracle EBS Supply Chain including: Advanced Procurement, Value Chain Execution, Order Orchestration and Fulfillment, Asset Lifecycle Management, Manufacturing, Product Value Chain Management Value Chain Planning

Confidential, O’Fallon, MO

SQL Server Developer

Responsibilities:

• Writing TSQL, PL/SQL, stored procedures, functions and complex queries for migrating legacy Oracle 10g to SQL Server 2012.
• Experience working in multiple projects both OLTP and OLAP (Data warehouse) databases.
• Designed and developed SSRS reports exactly similar to the Crystal Reports (Migration of Crystal Reports to SSRS Reports).
• Created complex Stored Procedures, SSIS Packages, Triggers, Cursors, Tables, and Views and other SQL JOINs and statements for applications.
• Designed and development of SSIS (ETL) packages for Data Extraction, Transforming and Loading the data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data).
• Responsible for Developing OLAP Cubes, Data Source View, Partitions of queries with MDX.
• Migrating SSIS packages from SQL Server 2008 version to SQL Server 2012 version.
• Experience in implementing Event Handlers, Checkpoints and Logging to maintain active SSIS packages.
• Automating the SSIS packages execution through SQL Mail Agent jobs, scheduling the jobs adding notifications for success and failure.
• Designed and Developed Drill-through, Drill-down, Cross Tab (Matrix) Reports and Sub-Report using SSRS.
• Applying optimization techniques to improve the performance of the queries and taken care of performance issues across TSQL, SSIS and SSRS reports.
• Optimized the performance of queries by Data Manipulations which includes modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established Joins and created clustered/non-clustered indexes wherever necessary.
• Implemented the Best Practices and Coding Standards for SQL Server, SSIS & SSRS.
• Experienced working in Development, Testing and Production servers.

Environment: MS SQL Server 2008/2012, Oracle, MS SQL Server Reporting Services, SQL Server Integration services, ETL, Data Modeling, T-SQL, SQL Profiler, XML, MS Access, Excel

Confidential, Lake Forest, IL

SQL BI Developer/Senior Supply Chain Analyst

Responsibilities:

• Experience in Designing and modeling SQL Server Database, creating tables and views.
• Writing TSQL, PL/SQL, Stored procedures, functions, views and common table expressions.
• Designing and developing new SSIS (ETL) packages and enhancing existing SSIS packages.
• Automating the ETL executing process through jobs and creating notifications for failure and success.
• Created various SSIS packages for Daily run, Weekly run and monthly run for both incremental load data and fully load data to SQL Server, from Flat files or excel spreadsheet.
• Experience in loading the data through Import, Export wizard activities in SQL Server for one time load.
• Developed inventory policies and established accountability for tactical and strategic results through effective reporting, monitoring and cross-functional engagement.
• Identified and implemented various tools to support the S&OP and product lifecycle management processes as well as the inventory and purchasing functions.
• Act as Supply Chain lead on team focused on improving service levels for Retail/Aftermarket customers
• Works across multiple “supplier-customer” relationships (internal and external) to develop the best approach to get results
• Works collaboratively to investigate problems, find root causes, and develop solutions
• Designs and develops automated and semi-automated reporting solutions to monitor supply chain performance and freight spend and to address current business problems or to streamline processes.
• Performs complex analysis of information, problems, and/or data under limited supervision. Develops recommendations for review of lead/ and/or management
• Create value chains and IRR models, perform cash flow analysis, and develop business cases for capital investment justification.
• Work with multiple internal teams including Engineering, Finance, Procurement, and Supply Chain to ensure all transactions are compliant.
• Responsible for key inventory management improvement initiatives and provide data driven insight and resolution recommendations.
• Work with the group and business unit leaders / POCs in designing management reports, adhoc request, and business process improvements
• Migrated SQL Server 2008 packages to SQL Server 2012 version.
• Created Drill down, Drill through, sub reports through SQL Server Reporting Services and creating subscriptions for automating the process.
• Developed custom reports using SQL Server Reporting Services (SSRS) to review score cards, business trends based on the data from different retail locations.
• Performed data analysis to generate various trend reports.
• Generated Ad-hoc, matrix and tabular reports using SQL Server reporting services based on customer needs.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• To set up SQL Server configuration settings for better server management.
• Experience in using SQL Server Profiler & SQL Server Agent.
• Experience in working Development, Testing and Production Database servers.
• Specialized in Continuous Integration, DevOps and Service Orchestration practices
• Experience in administrative tasks - Backups & Restoring the database, replicating the database.

Environment: MS SQL Server 2008/2012, Microsoft Visual Studio 2008, SQL Server Reporting Services (SSRS 2008), Report Manager, Report Viewer, SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Oracle 10g, Toad, MS Excel

Confidential

Junior SQL DBA/Developer

Responsibilities:

• Actively participated in gathering of User Requirement and Specification.
• Installation and configuration of SQL Server 2000/7.0 on Window 2000/NT OS.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Implementing Backups and Restoring when necessary.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Developed DTS Packages to transfer the data between SQL Server database and files.
• Extensively Developed SQL scripts for maintaining administration tasks.

Environment: SQL Server7.0/2000, HTML, Enterprise Manager, Windows 2K, SQL Profiler, DTS, and BCP.