PROFESSIONAL SUMMARY:

• 9+ years of IT experience and expertise in Designing, Development, Implementation and Maintenance of applications. Strong programming knowledge in TSQL, PL/SQL Development (SQL SERVER 2008,2012,2014) and Report Development (SSIS,SSRS), Performance Analysis, Deployment Script Development, Production Support.
• Expert in Creating, configuring and Fine - tuning SSIS packages, SSRS reports and T-SQL queries using tools like SQL profiler Monitoring tool.
• Experience in creating jobs, alerts, SQL mail agent, and schedules for SSIS Packages in SQL Server Agent.
• Excellent experience in Designing, Maintaining and tuning various RDBMS like T-SQL & MS SQL Server 2005/2008/2008 R2/2012/2014 and MS Access databases.
• Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and data Integrity, SQL joins and query Writing.
• Good knowledge exposure on 2016 version of SQL Server Management studio. Worked on SQL Server 2014 migration to 2016.
• Strong experience in Database Installation, Capacity Planning, Implementing Backup and Recovery Strategy for application and database.
• Optimized all major relational database and data warehouse and also accessed multidimensional databases and flat files using microstrategy.
• Involved in performing Unit Test, Regression Test, Functional Test, integration Test, Stored Procedure Performance Test, on Test server and preparing combined Developer Training document along with waterfall, Spiral and Agile methods with full SDLC (Software Development Life Cycle).
• Expert knowledge and experience authoring, managing and deploying reporting solutions using SSRS.
• Good knowledge on Performance point services and worked on few Performance Point Dashboards.
• Expert in generating writing parameterized queries, drill through reports and formatted SQL server Reports in SSRS 2005/ 2008/2008 R2/2012/2013 using data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Good experience in MDX scripting and created Multi-dimensional expressions using MDX scripting.
• Ability to work well in hybrid and dynamic environments without supervision, as well as able to prioritize and remain focused on the essence of an issue while deploying iterative development methodologies in accomplishing a given task.
• Experience in installation, configuration, Development of MS SQL Server 2005/2000/2008/2008 R2/2012/2014 Reporting Services
• Very good experience with ETL(Extract, Transform, Load) processes for OLTP & OLAP environments Experience in Reporting Services (SSRS 2000/ 2005/2008/2008 R2), Crystal Reports & Integration Services (SSIS).
• Report Service experience with Microsoft Excel Power Pivot.
• Good knowledge on angular Java Script and C#.
• Experience in configuration of report server and report manager scheduling, permissions to different level of users in SQL Server Reporting Services (SSRS).
• Excellent communication skills, analytical skills, understand business requirements in various domains.
• Quick learner and good performer both in team and independent job environments.
• Experience in working on Dash boards using COGNOS Tool, like web-based reports, scorecards, and dashboards.
• Expertise in using global variables, expressions and functions for the reports with immense experience in handling sub reports in SSRS.
• Performed Log Shipping and implemented Transactional and Snapshot Replication as high availability techniques.
• Worked on ad hoc requests for information from systems and assists with configuration of reports in a timely, efficient, and accurate manner.
• Developed in-depth understanding of underlying data, data structures, and business uses to ensure reports meet client needs.
• Worked on Power BI to make changes in some functions like date, currency etc.
• Worked with DBA’S monitored daily jobs for all environments and resolved the bugs if job fails.
• Created basic reports using CSV files as source to fetch the data in Power BI.
• Worked on some design level Overview using MS Visio.
• Worked on SSRS reports for applications like windows app or web app.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio 2012/2014/2016 , SQL Server Business Intelligence Development Studio, Sybase 12.5 ASE, Power BI

IBM Tools: IBM DB2.

Languages: C/C++, C#. NET, T-SQL,VB.NET, HTML, CSS, AJAX, XML

Operating Systems: Windows 95/2000/2003/ XP/VISTA/7/8/8.1,LINUX,UNIX

MS: SQL Server 2008 R 2/2008/2005/2000 , MS Access.

ETL Tools: Data Transformation Services, SQL Server Integration Services (SSIS),ASCMD

Scripting: Shell Scripting.

Reporting Tools: SSRS, SSAS, Crystal Reports, Excel reporting, Cognos, Qlik View 12.0.

DB Utilities and design tools: SQL Server Management Utility, Query Analyzer, SSAS Cubes, MDX scripting.

Application Software: Visual Studio, MS Office, SQL dialect, MS Visio.

Methodologies: Agile, Waterfall

PROFESSIONAL EXPERIENCE:

Confidential, Newark, NJ

SQL Server TSQL/SSIS/SSRS/MSBI developer

Responsibilities:

• Participated in daily agile scrum meetings to understand business logic and requirements of the company and provide optimal solutions to the users.
• Worked with Business architect to determine logic for the new data warehouse, and for integration process.
• Created model for data warehouse created and wrote DDL scripts for different database objects as tables, stored procedures, triggers and user defined functions.
• Designed SSIS packages for transient and persistent staging area, to extract data from SAP and different applications, from excel files and flat files using for each loop container, sequence container, and tasks such as execute SQL task, look up, merge, merge join, un pivot etc.
• Wrote complex TSQL queries to get data from different sources and test results with expected results.
• Custom SSRS 2012 reports as well as some Tableau reports for large customers and senior executive leadership.
• Gather and translate business requirements into report designs.
• Design and monitor construction of user-facing presentation tools, such as Microsoft SQL Server Reporting Services (SSRS) reports.
• Design and monitor the construction of an enterprise data warehouse.
• Implemented performance tuning for slow running packages, using execution plan and SQL Server Profiler. Implemented parallelism in SSIS.
• Generated and optimized already existing views to enhance performance for creating reports and SSAS cubes.
• Used different data transformations such as Derived column, Conditional split, Multicast, slowly changed dimension etc.
• Designed and implemented logic for loading data to the dimension and fact tables.
• Implemented special logic for late arriving dimension records.
• Created parameter tables and inserted parameters for each package which is used to retrieve information about package on run time enabling packages work dynamically.
• Utilized SQL Server table configurations and environment variables to dynamically run packages.
• Executed event handler and error handler mechanisms in SSIS and wrote C# code to retrieve customized information about error if package fails and insert useful information to the audit log tables.
• Worked with SQL Server Job Agent to schedule packages, run and monitor them.
• Used Team Foundation Server to keep track of new created SSIS packages, and to modify and update existing packages when it is necessary.

Environment: MS SQL Server 2012, T-SQL, SQL server Integration service 2012, SQL Server Reporting Service 2012, Erwin7.3, SQL Profiler, C#, SSAS.

Confidential, Herndon, VI

MSBI Developer/SSAS/SSIS/SSRS/TSQL

Responsibilities:

• Developed complex queries in T-SQL, wrote Stored Procedures, Triggers and Queries with best execution plan. Created cubes and dimensions for the analysis of sales in specific areas.
• Implemented data mart, facts, dimensions, star schema and OLAP cubes based on Kimball’s dimensional modeling standards using SQL Server Analysis Services (SSAS).
• Deployed SSAS solution to UAT server for every Quarter release. Supported DBA’s in handling cube failures for Production server in Quarter release.
• Responsible for resolving every cube process failure in production.
• Handled MDX Script accordingly to meta data. Worked with business to rectify complex issues of Cube.
• Tested some SSIS packages, which used to create individual client data bases in SSMS.
• Worked on developing XMLA scripts, to deploy SSAS solution to all forty clients using ASCMD.
• Created reports by extracting data from cube. Processed cube to perform incremental updates.
• Implemented fine-tuning of database objects and server to ensure efficient data retrieval.
• Created new OLAP dimensions as per business requirement.
• Worked with DBA’s to resolve problem for malware function of SSMS tool, missing DLL files.
• Found every root cause for existing stored procedures and cube failures.
• Worked alone to resolve any cube issues, as I’m the only SSAS developer at Onsite.
• Developed two cubes to an already existing project, which included total of eight cubes.
• Added hierarchy levels for few dimensions as per business requirement.
• Updated the measure groups to reduce cube process time.
• Worked on few SSRS reports to modify them and built new reports using cubes.
• Performed and managed SSAS cubes to handle parameterized queries in various SQL Database Reporting tools.
• Assessed requirement and defined the strategy, technical architecture, implemented plans and delivery of a data warehouse.
• Created and implemented MDX scripts to handle complex designs.
• Provide and Monitor database “Health” - availability, reliability, performance and capacity planning using SQL Profiler, Database Tuning Wizards.
• Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
• Worked Extensively with SSIS to import, export and transform the data between data sources.
• 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 in MS SQL Server 2014.
• Implemented the Reporting Services in SQL Server 2014 and integrate the Microsoft Share Point portal with Reporting services.

Environment: MS SQL Server 2012/2014, MS SQL Integration Services 2012, Crystal Reports, SSAS Cubes, MS SQL Reporting Services 2012, Tableau 10,MS Excel Power Pivot, SQL Server Agent, SQL Server Reporting Services(SSRS).

Confidential, Atlanta, GA

MSBI Developer/SSIS/SSRS/SSAS/Excel Reporting Using Cubes

Responsibilities:

• Worked closely with business to gather requirement for SSRS reporting.
• Improved existing reports with adherence to defined policies and data definitions across financial systems
• Designed workflow for financial requirement.
• Built all major financial reports for business which holds all the budget amount and revenue of the company globally individually.
• Deployed SSRS on to the report server with an easy way of deployment.
• Worked on some of the important reports of the company like Maintenance revenue by product for customer, Fixed fee report etc.
• Worked on building Data warehouse of the company called Global Service Reporting, which holds all financial information.
• Monitored daily jobs to make the ETL Master package run successful and validated the count in all individual environments of the data warehouse.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases to build stage tables for data warehouse.
• Designing, Managing and Publishing various Dash boards, score cards using SQLServer Reporting Services
• Created Jobs to extract data from different sources using SSIS packages. Stored Procedures called the SSIS package that would aggregate the data and load them in globally temporary table, having the same architecture as the table for which the import is done.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Participated in designing and developing Data Warehouses, Data marts and cubes in Business Intelligence environment using multi-dimensional models such as Star Schema.
• Created Linked Servers for data retrieval using OLE DB data sources and providers.
• Expert in working with BIDS, which includes SSIS, SSRS.
• Created Jobs to extract data from different sources using SSIS packages. Stored Procedures called the SSIS package that would aggregate the data and load them in globally temporary table, having the same architecture as the table for which the import is done.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Extensive Working Experience on Creating Stored Procedures and Views.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures.
• Generated database monitoring and data validation reports in SQL Server Reporting Service.
• Design natural and navigational hierarchies in dimension. Extensively worked on Type 2 dimensions.
• Designed OLAP cube and deployed cube on SSAS server.
• Created cube structure for the analysis of business condition and for creation of report using SSAS.
• Worked on SSIS Tool using a Frame work.
• Worked with DBA’S to work on the issues for UAT and Production Environment.
• Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports.
• Develops custom reporting solutions using Tableau.
• Attended daily scrums and updated the about previous work and impediments.
• Updated the ISPAC for every Sprint release.
• Worked on Unit Testing and Deployment.
• Created many to many relationships directly in the data model using tabular.
• Worked on tabular model to import the tables multiple times and renaming the data.
• Worked on few DAX formulas using tabular model for excel reporting.
• Worked on adding data into existing partition and new partition using tabular model.

Environment: MS SQL Server 2014, Micro strategy, MS SQL Integration Services 2013, Crystal Reports, SSAS Cubes, MS SQL Reporting Services 2013, MS Excel Power Pivot, SQL Server Agent, SQL Server Reporting Services(SSRS)

Confidential, San Francisco, CA

MS SQL Server / SSIS, SSRS/BI Developer

Responsibilities:

• Designed database after analysis of the business requirement.
• Designed the high level design document of the complete process flow.
• Worked closely in developing the detail design document and presenting to the client and implementing their feedback on a weekly basis.
• Designed development plan and the assigned individual task to team.
• Worked with an offshore development team, communicating on a daily basis with the team.
• Designed the complete flow of the file processing.
• Generated parameterized queries in SSRS 2005/ 2008/2008 R2 using data from SSAS Cubes and various heterogeneous data sources.
• Designed power shell to monitor the file location for the file existence and copy/move to specific location after looking at a character inside the file.
• Inserted into the tables from the power shell by calling stored procedures.
• Designed the file processing using the queue (first in first out) concept.
• Created complex expressions using the MDX scripting to solve complex designs.
• Implemented the Queue logic by starting SQL Agent jobs( which pointed to deployed SSIS packages on the integration server)
• Designed SSIS packages to implement the file processing logic depending on the source of the file.
• Deployed SSIS packages with a simple one-click deployment to the integration server.
• Maintained different branches in TFS as development for release 2 and testing for release 1 were together.
• Involved in transferring old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2012 database using SSIS Packages
• Expertise with Agile & waterfall methodology
• Resolved the conflicts while merging code in TFS.
• Deployed different database instances for development, QA, UAT and production from TFS.
• Designed reports using SSRS for the client as per their specifications.
• Deployed SSRS on to the report server with an easy way of deployment.
• Created subscriptions on the deployed reports using report manger.
• Called those subscriptions using a stored procedure (which fired the report subscription and saved the reports on the file server).
• Used Database.sqlcmdvars for deploying the database instances giving the flexibility to change the variables used in the deployment.
• Implemented the SQL agent jobs creation while deploying the database instance itself by adding them on to the post deployment scripts.
• Formatted Reports and created interactive dashboards using Micro strategy platform.
• Created the SQL server users and file server users with required permissions by including them in the scripts.Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS and designed reports using Crystal Reports.
• Implemented the power shell as a windows service (which is used to monitor the file existence).
• BI reporting using Excel with Power Pivot.
• Implemented matrix tabular and charts while creating the reports using SSRS.
• Created few dashboards on Performance point services.
• Used expressions extensively for hiding textboxes, display labels and hiding charts, matrix and tabular depending on certain conditions.
• Used parameters, images to retrieve appropriate data from the common data source added globally.
• Saved images in a binary form in the configuration tables for easy retrieval from SSRS.
• Implemented Derived column, file system task, conditional split, lookup transformation, OLE DB Command, Data conversion, Data flow, Execute SQL task, Bulk task, Script task, for each loop, Ftp task and other tasks in SSIS.
• Optimized the loads by adding Indexes where ever needed, dropped and recreated indexes while doing the full loads.
• Performed transactional-level process using MicroStrategy’s relational OLAP (ROLAP) architecture.
• Maintained the SQL Server Agent jobs to run depending on the requirement.
• Used IBM OLE DB connection manager to connect to IBM DB2 data base and get some input data to the look up loads.
• Used Update and Merge statements while working on the Incremental loads.
• Imported data from Oracle based data source into tabular model for excel reporting.

Environment: MS SQL Server 2008 R2/2012, Micro strategy, MS Access, MS SQL Integration Services 2008 R2, Crystal Reports, SSAS Cubes, MS SQL Reporting Services 2008 R2, IBM DB2, MS Excel Power Pivot,SQL Server Agent, SQL Server Reporting Services(SSRS).

Confidential, CO

MS SQL Server / SSIS/BI Developer

Responsibilities:

• Worked with an offshore development team, communicating on a daily basis with the team.
• Defined, planned and lead the Development tasks.
• Tracked and reported status, risks and issues to the business.
• Designed and developed SSIS Packages to import and export data from MS Excel and Flat files.
• Implemented SSIS packages for data export/import and created maintenance procedures and deployed them to the server.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Built Control flows and data flows for incremental data loads.
• Involved in automation of Jobs that perform Incremental load on a timely basis using lookup’s and data is delivered in the form of flat files to certain storage points.
• Involved in SSIS Packages to transfer data from various sources like Text Files, XML (Extensible Markup Language) Files, SQL Server, Excel and Access to SQL Server.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS and designed reports using Crystal Reports.
• Used Configuration files for changing variables easily.
• Worked with SSIS package event handlers, property expressions.
• Designed the production roll-out strategy and migration of assets from environment to environment.
• BI reporting using Excel with Power Pivot.
• Implemented data integrity procedures and logics.
• Performed and managed SSAS cubes to handle parameterized queries in various SQL Database Reporting tools.
• Assessed requirement and defined the strategy, technical architecture, implemented plans and delivery of a data warehouse.
• Created and implemented MDX scripts to handle complex designs.
• Made the SSIS code changes depending on the business requirement, deployed the changes SSIS packages and propagated them into different environments.
• Worked on encryption of the file set using PGP and GPG.
• Expertise with Agile & waterfall methodology
• Designed SSIS packages to send the encrypted file to different vendors using winSCP.
• Designed SSIS Packages to shrink, backup, encrypt databases.
• Designed SSIS packages to copy data from historical Server (IBM) to SQL server 2008 using liked servers and open queries.
• Designed SSIS packages to populate data into List Select database for the reporting team.
• Implemented Audit tasks tables in the databases to maintain logs for the SQL Server Agent jobs.
• Implemented Full loads (once a week) and Incremental loads (daily) in schedules.
• Created new Views, Synonyms, Stored Procedures, Functions and Triggers to accomplish the changes in the requirement.
• Successfully fixed the errors in the SSIS packages and was able to rerun the jobs from the check point files.
• Worked on different kinds of Transformations like Import Column, Export Column, Lookups, Derived Column, Merge Join, Fuzzy Lookup, ForLoop, ForEachLoop, Conditional Split, Union all, Script component in SSIS as per the client’s Requirement.
• Implemented the changes depending on the new releases into data warehouse, adding new columns, changes in the data types of the columns, new tables etc.
• Optimized the loads by adding Indexes where ever needed, dropped and recreated indexes while doing the full loads.
• Used Update and Merge statements while working on the Incremental loads.
• Maintained the SQL Server Agent jobs to run depending on the requirement.

Environment: MS SQL Server 2008 R2 (Query Analyzer, SSIS), Crystal Reports, MS Access, SQL Server Agent, MS SQL Integration Services 2008 R2,SSAS cubes, MS Excel Power Pivot,MS Excel, Windows XP, SSIS.

Confidential, Virginia Beach, VA

Sr. SQL Server (SSIS / SSRS/BI) Developer

Responsibilities:

• Used the SSIS to migrate databases such as Oracle and SQL Server database, flat files to centralized IT destination.
• Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
• Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2000/2005 environment, and deploy the data. Used Event Handlers for Exception Handling in SSIS packages.
• Used SSIS transformations and data conversion to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Generated reports on health information, account information, research reports using adhoc reporting to be used by the clients and advisors.
• Identified and worked with multivalve parameters for parameterized reports in SSRS.
• Created Queries in T-SQL, Stored Procedures, Clusters and Views to store the data of clients, advisors.
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updates to improve the query performance.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time.
• Created many complex Stored Procedures/Functions and used them in SSRS Reports directly to generate reports on the fly.
• Scheduled, maintained, and supported the distribution and access to reports at Server.

Environment: MS SQL Server 2005, SQL SSIS, SQL SSRS, T-SQL, Oracle, Visual Studio 2005, .NET(C#, VB), Windows XP/Server 2003, MS Office 2003.

Confidential, Columbus, OH

MS SQL Server SSIS/SSRS/SSAS/BI Developer

Responsibilities:

• Created SSIS packages to clean data from various sources (Flat File, CSV files, Excel Spreadsheets, MS Access, XML, Oracle etc.) using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc., to generate underlying data for the reports and to export cleaned data to data warehouse.
• Created Cubes and populated them with Dimensions and Facts from the Staging Database.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent. Created KPI Objects in line with Requirement Docs and optimized cubes for better query performance.
• Implemented Calculated Members and Actions such as URL Actions, Report Actions and Drill Through Actions in SSAS 2008.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deployed and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Used Notification services to generate error messages and send them to the user through e-mails, pager messages, and PDA as well as window messengers.
• Created ad-hoc reports, drill down, and drill through reports.
• Created functions within SSIS, SSRS using C#.
• Created and tuned stored procedures, triggers and tables and created several materialized views and UDF’s to be accessed by the new front end applications.
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).

Environment: MS SQL Server 2008R2/2008, SSIS, SSAS, SSRS, BIDS, T-SQL, TFS, Erwin v7.2, C#.Net

Confidential

SQL Programmer

Responsibilities:

• Created new tables, written stored procedures for Application Developers and some user defined functions.
• Created SQL scripts for tuning and scheduling.
• Performed data conversions from flat files into a normalized database structure.
• Created and managed users, roles and groups and handled database security.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
• Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database to SQL Server.
• Data migration (import & export - BCP) from Text to SQL Server
• Regularly monitored the system for bottlenecks (CPU, RAM, Disk IO and Networking)
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Performed development support, document reviews, test plan, integration of the system.
• Creation/ Maintenance of Indexes for fast and efficient reporting process.
• Analyzing the Database Growth and Space Requirement. Handling Users/Logins/User Rights
• Creation/Deletion of Linked Servers.
• Managing historical data from various heterogeneous data sources (i.e. Excel, Access).

Environment: SQL Server 2000, T-SQL, PL/SQL, TOAD.