PROFESSIONAL SUMMARY:

• 8 years of experience in Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using SQL Server 2000/2005/2008 /2008 R2/2012.
• Extensive experience in using Microsoft BI studio products like SSIS,SSAS,SSRS for implementation of ETL methodology in data extraction, transformation and loading .
• Scheduling and Monitoring ETL Processes using DTS Exec utilities and batch files.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets and Varden eReportal.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/2005/2008 ) generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Expert in Data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles.
• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2005/2008) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in debugging the SSIS packages using breakpoints and checkpoints.
• Extensive work knowledge in handling huge databases and worked on performance tuning and query optimizations.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
• Experience with migration of data from Excel, Flat file, MS Access, Raw File Sources, Oracle, Teradata Sources to MS SQL Server by Import & Export wizard and SSIS packages.
• Expert in creating Views, Stored Procedures, effective Triggers, and user defined functions to facilitate efficient Data Manipulation and consistent data storage
• Expertise in Functional testing, Manual Testing and Automated Testing, Regression testing, User Acceptance testing (UAT), System testing, Integration testing and Black Box Testing.
• Responsible for Reviews and documentation for reporting the status to the project manager.
• Expert in developing Data Marts, Data warehouses, OLAP, Star Schema Modeling, Snow-Flake Modeling, Facts, Dimensions, and Partitions using MS Analysis Services 2008
• Played a significant role of QA testing at various stages of the project including Data Quality Testing, Data load Testing, Data Integrity testing, Business Objects Reports Testing etc.
• Performed Data Mining activities like Predictive Analysis, Forecasting on central repository for various application and dashboard functionalities
• Expertise in Data Analysis by writing Ad-hoc T-SQL (DML and DDL) Queries.
• Expertise in developing Logical and Physical data models using data modeling tools such as DeZign and MS Visio.
• Writing MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix and tabular reports and other features of reporting services.
• Created Dashboard pages in SharePoint Server that use different types of web parts and excel services for reports
• Good team player, Excellent interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
• Expertise in defining the business process flow and gathering business requirements.
• Experience in using Star Team and Team foundation server for source control.

TECHNICAL SKILLS:

Languages: T-SQL, PL/SQL 11g, Dynamic SQL, MDX, C, C++, C#, ASP (.NET), XML, HTML, DHTML, HTTP, Shell Scripting

Databases: MS SQL Server Denali, 2014,2012,2008R2, 2008,2005,2000

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Informatics, Visual Studio, Cognos, Crystal Reports

Database Design Tools and Data Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball &Inmon Methodologies

Packages: MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS), Crystal Reports, Power Pivot, ProClarity, Microsoft Office (MS), Lotus Notes, Excel Power Pivot, Excel Data Explorer, Tableau, Varden eReportal.

Operating Systems: Windows Vista/XP/2003/2000, NT & Windows 9x, MS-DOS and UNIX

PROFESSIONAL EXPERIENCE:

Confidential

Sr. BI Developer

Responsibilities:

• Designed and developed a full-scale reporting solution for a multi-client environment using MS SQL Server 2012 and Varden eReportal.
• Generated multi parameterized reports in eReportal allowing users the ability to make selections before executing reports; thus making them user friendly.
• Assembled and converted user requirements from multiple clients into our standard reporting solution and customized specific client requests when necessary.
• Writing SQL Queries to retrieve data from database.
• Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Developed various operational Drill-through and Drill-down reports
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Operational and summary reporting framework design and development
• Repaired/recreated PPS reports damaged in the conversion process.
• Worked on Filtered Views, views and Base table integration between different Source systems.

Environment: Windows2003 Advanced Server, ODBC, OBIEE, MS SQL Server 2005/2008/2012, TSQL, PL/SQL 11g, Visual Studio 2008, Oracle, Varden eReportal, SSIS

Confidential, Washington DC

Sr. SQL BI Developer

Responsibilities:

• Developed complex programs in T-SQL\PL-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Rewrote SQL queries to upgrade SQL Server performance using SQL Server 2008/2012.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Defined Check constraints, Indexes, and Views.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
• Developed physical data models using ERWIN/ VISIO and created DDL scripts for database schema and objects.
• Developed Query for generating drill down and drill through reports in SSRS 08/12.
• Uploaded reports on to the report manager and organized them into folders.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
• Identified and worked with Parameters for parameterized reports in SSRS 2008/2012.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Written T-SQL Stored Procedures and queries for accessing Data from Teradata Database
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Have good hands on experience working with FTP component in SSIS and used Configuration Manager to retrieve the passwords.
• Created, tested, modified and scheduled SSIS packages to update the tables on a day to day basis.
• Extensively involved in designing and maintaining the SSIS packages to export data of Excel spreadsheets and flat files sources to SQL Server Database
• Optimization of stored procedures in SQL Server to improvise the speed of the application to display the data
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes. Created Linked Servers to connect OLE DB data sources and providers.
• Administered the SQL server by creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.
• Designed and created MDX queries to retrieve data from cubes using SSIS.
• Managed the migration of SQL Server 2005 databases to SQL Server 2008.

Environment: MS SQL Server 2008/2012, DTS, Windows 8, SSMS, Business Intelligence Development Studio(BIDS) 2008/2012, Erwin, MS Visual Source Safe, MS-Visual Studio, Oracle 10g, UNIX,MDX Scripting.

Confidential, New Brunswick, NJ

SQL Server Developer/SSIS Developer

Responsibilities:

• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2008.
• Worked with T-SQL to create Tables, Views, Triggers and Stored Procedures.
• Created complex joins and implemented Constraints on tables for maintaining Data Integrity.
• Frequently used to connect to the health care data marts at different locations using C#.Net and ADO.Net for scheduling jobs.
• Designed and developed custom .NET components and user controls using ASP.NET
• Wrote VB Scripts to create custom SSIS transformations, in addition to using built-in SSIS transformations.
• Involved in creating high level ETL architecture for overall data transfer to OLTP, ODS with the help of SQL Server 2005, 2008 Integration services.
• Involved in relational database modeling like, designing the tables, algorithmic diagrams for the input data (entity diagrams), indexes etc.
• Created complex SSIS packages using appropriate control and data flow elements with SSIS Standards like error handling, logging and working with package config files.
• Exporting the database from Local server to the remote server and importing the current running database from remote server to the local DB Server using SSIS.
• Created Tablix reports, Tabular/Matrix reports based on requirements.
• Created Dashboards using SSRS.
• Reduced the overall ETL time by SQL Query performance Tuning. Discussed with user interface and external interface teams over the performance issues and provided solutions.
• Created databases, tables, and fields for data entry, performing database capacity planning.
• Enhanced and deployed the SSIS packages from development server to production server and scheduled jobs.
• Supported the production team when issues rose in the packages.

Environment: MS SQL Server 2008R2, SQL Server Reporting Services (SSRS), MS Access, MS Excel, SSIS, BCP, T-SQL

Confidential, Columbus, IN

Business Intelligence Developer

Responsibilities:

• Implementation of data extraction, transformation, and loading (ETL) processes.
• Extensively used Derive Column, Data Conversion, Conditional Split and Aggregate.
• Transforming the data using various tasks and transformations in control flow and data flow.
• Creation of SSIS packages to implement ETL processes to load fact and Dimensions Tables.
• Creation of package configuration to handle data source connection information.
• Creation of Tabular and Matrix reports in SSRS (2008) for Business Analysis Purposes.
• Building and generating reports with the help of Report Builder in the Report manager.
• Deploying and scheduling SSRS Reports in Report Manager and applied subscriptions
• Add securities to the reports.
• Developed and Deployed the SSAS Cubes using SQL Analysis Services (SSAS).
• Created SSAS cubes with Dimensions, Hierarchies, partitions and MDX queries
• Involved in creation of named calculations, members using the MDX queries.
• Involved in writing heavy T-SQL stored procedures, Functions, complex joins
• Involved in performance tuning of stored procedures using the SQL profiler and tuning advisor.
• Involved in scheduling the SSIS packages using the Sql server Job Agent.

Environment: SSIS, SSRS, SSAS, MDX, T-SQL, SQL Server 2008, Windows Server-2007

Confidential

SQL Server BI Developer

Responsibilities:

• Created database objects like Tables, Indexes, Stored Procedure, Triggers, Functions, Constraints and Views.
• Fine-tuned Stored Procedures to improve performance that was achieved by removing unnecessary Cursors and Temporary Tables.
• Worked on Linked Servers to run distributed queries between SQL server and other data sources like excel using ODBC, OLE DB Drivers.
• Responsible for Design and Normalization of the database tables.
• Prepared Data Flow Diagrams, Entity Relationship Diagrams and Table Structure.
• Created and Migrated DTS packages from SQL Server 2000 to SQL Server 2005 Integration Services (SSIS).
• Gathered requirements for the creation of Data Flow processes for the SSIS packages.
• Used various Control Flow Tasks in the development of various complicated packages.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2005 for further Data Developer and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
• Experience in Developing and Publishing Reports in SQL Server 2005 using SSRS (SQL Server Reporting Services).
• Created various kinds of reports involving Drill Down, Drill through Report, Parameterized Reports and Ad-hoc Reports.
• Designed the Sales and Manufacturing Summary reports in SSRS 2005 from the requirement document.
• Identified and worked with Parameters for Parameterized Reports in SSRS 2005/2008.
• Experienced in performance tuning using SQL profiler and Monitored SQL Server Error Logs and Application Logs.

Environment: SQL Server 2000/2005, T-SQL, Windows Server, Microsoft Visio, Performance Monitor, SQL Server Profiler, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS).