SUMMARY:

• 7+ years of IT experience in Database and Business Intelligence technologies with expertise in Installing, Upgrading and Configuring SQL Server Development and Reporting using SQL Server (SSIS, SSRS, SSAS).
• Conversant with all phases of software development life cycle involving System Analysis, Design, Development, Implementation, Documentation, Deployment.
• Good Knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Complex views, Dynamic SQL, Triggers, Cursors and ER Diagrams.
• Experience in implementing Loggings, Event Handlers, Checkpoint, and Package Configurations for SSIS Packages.
• Involved in huge Data Migrations, Transfers using utilities like Data Transformation Services (DTS) and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Expertise in Extracting, Transformation and Loading (ETL) using various tools like export/import data and SQL Server Integration services.
• Created, Developed, Tested and Deployed Packages into production servers by creating package configurations.
• Expert in T - SQL Programming, Query Optimization and Performance Tuning.
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources like SQL server native client, Excel, Flat file using SSIS and DTS utility SQL server (2005/2008).
• Experience in the Fuzzy Logic Transformations like Fuzzy grouping and Fuzzy lookup as cleansing techniques and have excellent knowledge of other transformations like derived columns, SCDs and Conditional Splits.
• Extensive experience in development of reports using SQL Server 2014/2012/2008 Reporting Services (SSRS) and writing parameterized queries for generating Tabular Reports, Formatting Report layout, Sub Reports using global variables, Expressions, Functions, Sorting the data, defining data Source, developed Custom Report and different type of Matrix Reports, Drilldown reports and score cards in multiple formats using multi-dimensional objects.
• Experience with ad-hoc reporting, parameterized, and custom reporting and graphical reporting using SSRS for daily/Weekly/Biweekly/monthly reports.
• Excellent knowledge in designing cubes, dimension tables and fact tables by using SSAS.
• Knowledge in creating MDX queries to access cubes and dimensions.
• Experience in creating and modifying the SSAS navigation and natural hierarchies, which will provide significant improvement in analysis and report drill down.
• Hands on experience with Microsoft Dynamics ERP systems. Acquainted with various functional areas Sales, Purchasing, Finance, Manufacturing and Forecasting.
• Adept in tools like Qlikview, INFORMATICA, Cognos.
• Test and Deploy code across various SDLC Environments like DEV, TEST, UA/UT and Production and experience in unit Acceptance Testing (UAT) Load balance Testing.
• Extensively used tools like SQL Profiler, Database Engine Tuning Advisor and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Excellent understanding of Data modeling (Dimensional & Relational)
• Result oriented multi-tasking with strong technical concepts and organizational abilities. Excellent Communication and inter-personal skills to understand business requirements in various domains and ability to interact with clients.

TECHNICAL SKILLS:

Databases: MS SQL Server 2014/2012/2008, Oracle 10g, 11i, MS-Access, MS-Excel 2007/2013.

Languages: C, C++, Core Java, SQL, T-SQL, PL/SQL, C#.Net, XML, HTML Script.

SQL Server Tools: SQL Server Management Studio, SQL Profiler, SQL Server Agent, Qlikview Database Tuning advisor, Query Analyzer, SSIS, SSRS, and SSAS.

Other Tools: Toad, INFORMATICA, Jira.

Version Control Tools: Microsoft Team Foundation Server (TFS), GIT.

Operating Systems: Windows 2008 Server / 2003/ 2000, Windows XP/7/8.

Domains: Insurance, Finance, Audit, Health

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

SQL Developer

Responsibilities:

• Responsible for scheduling jobs and their maintenance, along with providing analysis and alerting concerned teams based on type of issue encountered.
• Created complex T-SQL queries, stored procedures, indexes, functions and views to support efficient data storage and manipulation.
• Designed Packages, Procedures, Functions and Triggers. Handle database performance and DB tuning.
• Created and executed SQL Server Integration service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Worked on various tasks and transformations like Execute SQL Task, Execute Package Task and conditional split, Script Component, Merge and Lookup while loading the data into Destination.
• Responsible for maintaining data consistency on the reports and the same reports are useful in various organizations by managers in analyzing the revenue data.
• Developed Power Pivot Reports in Excel 2013 by publishing them to Share Point 2013 for providing ad-hoc reports according to client need.
• In-depth analysis of business critical issues, which encountered in day-to-day functioning.
• Creating various reports like Drill down, Tabular and Drill thru reports and charts like pie, Column, Bar, Line graph based on the User and Business requirement to suit the purpose of day to day activities using POWER BI and SSRS.
• Making use of SQL Profiler to map the data between frontend and backend for analyzing further into the issues.
• Designed the star schema for the data warehouse including facts and dimensions.
• Implemented DW applications based on the requirements.
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying theData with MDX script.
• Defined MDX scripts for querying the data from OLAP cubes (SSAS) and build reports on top of cubes.
• Interacting with the users and troubleshooting the problems.
• Identifying risks proactively and proposing solutions to resolve them.
• Taking proactive steps to ensure that the servers are in tune and would not result in failure.
• Enhanced Performance by reviewing Disk Configuration and storage allocation.
• Worked closely with the developers of applications to identify issues and advise various challenges that may occur in the process of making system-levels changes.
• Extensive testing on the performance of the Stored Procedures.

Environment: MS SQL Server 2014, SQL Server Integration services (SSIS), SQL Server reporting services (SSRS), and SQL Server Analysis services (SSAS), MS Excel, Windows 8/10, and TFS.

Confidential, Columbus, OH

SQL Developer

Responsibilities:

• Created Database and managed schema objects such as tables, views, indexes and referential integrity depending on our requirements.
• Developed work flows and data flows to extract, transform and load data in to the Business Intelligence
• Center using Data Integrator’s designer.
• Developed physical and logical modeling.
• Created stored procedures, Triggers, Indexes, User defined Functions, Constraint etc. on various database objects to obtain the required results.
• Created complex ETL packages using SSIS to import data from one server to another server using data transformations.
• Transferred data from various data sources / business systems including MS Excel, MS Access, and Flat Files etc. to SQL server using SSIS/DTS using various features like data conversion etc. Created derived columns from the present columns for the given requirements.
• Designed Dynamic SSIS Packages to transfer data crossing between platforms, validate data during transferring and archived data files for different DBMS.
• Bulk data migration using SSIS from flat files.
• Extensively used SSIS transformations such as lookup, Derived column, Data conversion, Aggregate, Conditional Split, SQL task, send email task.
• Worked with different control flow elements like for Loop Container, For Each Loop Container etc.
• Scheduled the SSIS packages to run at different intervals to load the data into SQL Server.
• Migration of SSIS packages from SQL Server 2008 to SQL Server 2012.
• Used all the major control flow tasks in SSIS like …. Containers (for each / sequential), File system task, Data flow task, Bulk Insert, FTP task, SMTP task, Exec SQL task, Exec process task, Exec package task etc.
• Automated many manual ETL Process using SSIS and supported with existing complex production SSIS packages.
• Responsible for scheduling jobs, Altering and maintaining SSIS packages.
• Developed Custom reports, Ad-hoc reports by using SQL Server reporting services.
• Developed Tabular, drill down, drill through, sub-reports, and navigation reports using SSRS.
• Developed and created SSRS charts like Pie, Column, Bar, Line Graph as per Business requirements.
• Generated reports using Global variables, Expressions and Functions based on the requirements in SSRS.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down
• Reports, report models and dashboard reports.
• Troubleshoot and diagnose critical issues with SSAS Cubes.
• Created Parameterized Reports, cascaded Reports, linked Reports, and thorough knowledge of report server architecture using SSRS.
• Created numerous reports on the fly on a daily basis for business users, which reflect company and sales performance based on various business rules.

Environment: MS SQL SERVER 2012, SQL Server integration services (SSIS); SQL Server Reporting services (SSRS), Business Intelligence Development Studio, MS Excel, TFS and SSMS.

Confidential, Cupertino, CA

SQL Server Developer

Responsibilities:

• Involved in analysis, design and development of project to consume transactional data, consolidate into a warehouse and create reports.
• Created ETL using SSIS to get data from multiple regions.
• 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.
• Implemented error handling and roll back process in ETL Load.
• Used Check Points in in SSIS for huge data loads.
• Used expressions and variables in SSIS to make load dynamic.
• Created region level security in reports to prevent users of one region from seeing data of a different region and implemented subscriptions for Reports using SSRS.
• Created job performance reports that queries sys tables and shows how long each job ran and weekly average duration using SSRS.
• Created report tables and wrote stored procedures to load data.
• Designed Cubes with star schema in SSAS and Executing Analysis Services Processing Task in SSIS for
• Processing cubes in packages.
• Performed unit and system testing, troubleshooting and bug fixing development.
• Performed tasks like backup, restore of tables, stored procedures, and refreshing database on weekly basis.

Environment: MS SQL Server 2008/2012, SSIS, SSRS, SSAS, Report Manager

Confidential, Pea pack, NJ

MSBI Consultant

Responsibilities:

• Involved in creating functional and technical specification documents after gathering requirements from business users and used agile methodology while development.
• Created several database objects like tables, views, stored procedures, functions, Indexes and triggers in T-SQL based upon the functional specifications.
• Reviewed the existing stored procedures and improved efficiency by critically evaluating the code.
• Extracted data from different sources including flat files, Oracle 10g to SQL Server 2008 by using SSIS.
• Performance tuning of ETL transformations, data validations and stored procedures.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS-2008.
• Designed the creation of application-specific reports like reports by customer, reports by account and reports by Debit/Credit amounts using Reporting Services.
• Worked with Java developers to create front end and explaining the database design to them.
• Designed complex ETL strategies to pull data from different sources like SQL Server, Oracle and flat files and load it to the destination database after using multiple transformations.
• Converted SQL Server DTS packages to SSIS packages in SQL server 2008 using migration wizard.
• Event handlers are used to handle the events on pre and post execution of packages.
• Optimized the packages the control flow level as well as data flow level.
• Created reports using SSRS and deployed using Integrated SharePoint mode.
• Used push method of delivering the reports- subscriptions by scheduling the reports to deliver on time using SQL Server Agent.
• Used reporting services to schedule various reports to generate on predetermined time.
• Generated daily, weekly and monthly reports regarding assigned projects to designated manager’s clients.

Environment: Microsoft SQL Server 2008, MS SQL Server Integration Service, MS SQL Server Reporting Services, Visual Studio 2008, T-SQL, Windows XP Professional, Oracle 10g, Microsoft Office.

Confidential

MS SQL Developer

Responsibilities:

• Installed and configured SQL Server 2008 for Development Purpose.
• Created DTS packages to transfer the data from Oracle to SQL Server 2008.
• Wrote T-SQL scripts to validate and correct inconsistent data in the staging database before loading data into database.
• Converted various SQL statements into Stored Procedures thereby reducing the number of database accesses (since stored procedures passes the whole block at one time).
• Performed tune to optimize SQL queries using SQL Profiler and Query Analyzer.
• Involved in performance tuning of the database and T-SQL queries using Explain plan.
• Created Indexes, Constraints and rules on database objects.
• Created and modified Clustered and Non-Clustered Indexes to optimize the queries using Index tuning wizard.
• Designed and developed MS SQL server stored procedures using T-SQL statements from scratch.
• Developed triggers on views to populate these tables.
• Rigorously tested and debugged the stored procedures and used triggers to test the validity of the data after the insert, update and delete.
• Handling database objects with Enterprise Manager.
• Provided technical documentation for further enhancements.

Environment: MS SQL SERVER 2008, T-SQL, Query Analyzer, SQL Profiler, Enterprise Manager, Windows XP.