SUMMARY

• Over 7+ years of Industry experience in Data warehousing experience with Microsoft SQL Server 2005/2008/2012, SSIS/SSRS/SSAS/MOSS OLTP and OLAP.
• In - depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics.
• Extensive experience in creating interfaces using SSIS in MS SQL Server 2005/2008 and its different tools like SSMS (SQL Server Management Server), BIDS (Business Intelligence Development Server) and SQL Server Configuration Manager.
• Experience in developing the applications using T-SQL Programming (DDL, DML, and DCL).
• Hands on experience in creating ETL packages using SQL Server 2005 Integration Services (SSIS).
• Experience in Upgrading from SQL Server 2005 to SQL Server 2008.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Good knowledge in optimizing queries using MDX and DMX.
• Good understanding on Datastage ETL tool and ETL solution designing with Datastage.
• Expert in automating process by creating jobs, and error reporting using Alerts, SQL Mail Agent, FTP,SFTP and SMTP. Experience in designing Database Models using MS Visio and ER-Win.
• Experience in deploying the SSRS reports to SharePoint portal server (MOSS 2007/2010) using reporting services web part.
• Good Knowledge on data visualization tools power BI and Power Pivot.
• Experience in setting up data connections from SSAS Analytics cube on SharePoint for end users to create their own excels reports.
• Experience in creating and deploying excels reports on MOSS 2010 using excel web services and web parts.
• Experience in Installing and working on OPEN FT tool for file transfer (FUJITSU tool).
• Experience in MS-DTS, Troubleshooting Design and Administration of Databases and other RDBMS concepts such as Tables, User Defined Data Types, Indexes and Stored Procedures.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• Expert in Extracting and Transforming data using SSIS in SQL Server 2005, DTS in SQL Server 2000, Import, Export Data, Bulk Insert and BCP.
• Experience in the development of life cycle methodologies
• Excellent in Transforming Logical Database designs into Physical Databases.
• Experience with SSMS, SQL Server Profiler and SSIS Wizards.
• Expertise in Building and Rebuilding Very Large Databases (VLDB).
• Experience in Error handling using Stored Procedures and Views.
• Exceptional background in analysis, design, development, customization, implementation and testing of software applications and products.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Intensive experience in monitoring database performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.

TECHNICAL SKILLS

Programming Languages: T-SQL, PL/SQL

Databases: SQLServer 2000/2005/2008, Oracle10g,Sybase,MS Access2003/2005

Tools: Performance Monitor, Backup Utility, SQL LiteSpeed, Spotlight, DB Artisan, SQL Server Management Studio, Query Analyzer, Enterprise Manager, Profiler

Other Tools: DTS, Business Intelligence Development Studio, SSRS, SSIS, SSAS. OPEN FT

Web technologies: HTML, XML,VB Scripts, IIS, PhP

Platforms: UNIX, LINUX, Windows 2003/2000, Windows XP, Windows NT

Network Topologies: TCP/IP,DNS,WINS,FTP,SMTP

PROFESSIONAL EXPERIENCE

Confidential, Durham, NC

Senior BI Developer

Responsibilities:

• Excellent report creation skills using Microsoft SQL Server 2012/2008 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Created SQL Server Reports based on the requirements using SSRS 2012.
• Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
• Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2012/2008 (SSAS)
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Developed Complex Stored Procedures, Functions, Triggers, Views and Temporary Tables as per the requirement.
• Created complex reports which involve more number of groupings and multi-value parameters
• Responsible for developing and maintaining Tableau dashboards.
• Used MDX and DAX queries to apply calculations to the cube in SSAS 2012.
• Developed reports like Claim Statements, Fee Bills Transactions and some end request user reports on periodic basis.
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Worked on converting the oracle coding to sql coding using Facets Database.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing
• Created different reports like tabular, matrix, ad-hoc, drill down and drill through reports using SSAS
• Developed data model based on the BA’s and the reporting Team using SSRS, SSIS
• Responsible for creating Tabular, Matrix and Drilldown Reports using SSRS
• Experience in building Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL)
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle ).
• Create an alternate work flow for Datastage ETL process using SSIS.
• Used Excel Pivot tables with Access data. Reported Access data using the Excel presentation layer Move data between Excel and Access using VBA, ADO and SQL.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers
• Scheduling the SSIS packages and Jobs.
• Checked the configuration and performance of the existing databases including data file allocation, index, fragmentation and impact on system performance. Analyzed potential problems (response delay, locking, server down time, etc) to avoid and optimize by following the Normalization standards to maintain data consistency and by performing data validation.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: Windows server 2003, IIS 6.0, MS SQL Server- 2012/2010/2008 R2/2005 Enterprise Edition, Tabular, VBA,ETL,SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Erwin VB.NET, OLAP, Crystal reports, Java, OLTP, UNIX, Linux, DAX, MDX, Erwin, Oracle, Performance Point Sever, C++, Tableau, Excel Pivot,Office-2007, DB2,MS Excel, C#.NET, ProClarity Analysis.

Confidential, New Brunswick, NJ

Sr SQL Developer

Responsibilities:

• Worked on gathering requirements as a basis for the functional specifications from functional revenue and sales teams.
• Created SSIS packages to load the data from UPS data ware house system to UPS capital Database on a weekly basis.
• Imported data using SSIS packages and using custom SQL server stored procedures.
• Scheduled ETL packages to run on Daily, Weekly and monthly using SQL server Agent.
• Created and alternate process of migrating existing Datastage jobs and packages to ssis, built a new process in SSIS and integrated with existing framework.
• Worked on Data Migration and ETL operations using Stored Procedures and SSIS.
• Created SQL server Stored procedures, Scalar valued functions and table valued functions to supports SSRS reports.
• Optimized Stored Procedures, Views, and User-Defined Functions for reporting needs.
• Created Variety of SSRS reports, Summary and detailed revenue reports to support the business needs of UPS capital cash flow aspects.
• Created variety of Aging reports, calculated summary reports, Cargo reports, Cargo Customer reports.
• Good knowledge on Using Team Foundation Server (TFS).
• Developed Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for Developing Cubes.
• Expert in creating Star schema cubes using SSAS.
• Good knowledge on working with Dimension Usage properties, Dimension relationships, Dimension Hierarchies properties, SSAS Actions, perspectives and Browser.
• Developed Aggregations and calculated members for cube as per business requirements.
• Defined appropriate Hierarchies, measure groups and KPIs & deployed cubes.

Environment: SQL Server 2008,2012 SSIS,SSRS,SSAS, XML, Share Point 2010 and 2012,Infopath, C#,.Net

Confidential, Charlotte, NC

SQL BI Developer

Responsibilities:

• Designed a workflow for Student Assessment Loading automation process.
• Implements a Student Analysis Business Intelligence Solution for Fulton County School Student Assessments.
• Worked on gathering requirements as a basis for the functional specifications of the Students automation process.
• Existing assessment data from all source files (.txt,.dat or .csv) were consolidated into a uniform Sql server 2008 database. ETL Capabilities of Sql server Integration Services (SSIS) were used to define imports of the data, build scheduling packages, to define integration flow, log data error exceptions and to define database maintenance plans and send emails.
• Imported data using SSIS packages and using custom Sql server stored procedures.
• Worked on Data Migration and ETL operations using SSIS.
• Configured linked servers to fetch data from another server (in our case it’s Oracle).
• Develop Stored Procedures, Functions, Views, CTE’s, Joins and Sub queries to enforce the business rules. Fine-tuned SQL queries to improve query performance and to reduce runtime.
• Optimized Stored Procedures, Views, and User-Defined Functions for the Assessment Automation Application.
• Performed Debugging on the stored procedures for the requirement to handle the errors.
• Created Data Profiling packages to check the data discrepancies between the source data and data warehouse data, profiling was done on column level. As the source data comes from School Clerk’s, created some TEMPeffective ways to cleanse the wrong data entered during the time of student admission.
• Developed Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for Developing Cubes using MDX. Expert in creating Star schema cubes using SSAS.
• Good knowledge on working with Dimension Usage properties, Dimension relationships, Dimension Hierarchies properties, SSAS Actions, perspectives and Browser.
• Developed Aggregations and calculated members for cube as per business requirements.
• Defined appropriate Hierarchies, measure groups and KPIs & deployed cubes.
• Created Analysis cubes, dimensions and business KPI’s using Sql server analysis services representing aggregations in several different ways - hierarchically and using custom groupings that the Fulton School System will use to amylase Students Test performance results. Created basic Time series MDX functions and MDX queries to support the business requirement.
• Designed Partitions in Cubes on time for improvement in performance using SSAS.
• Designed Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008) and Excel Pivot tables based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Generated periodic reports based on the student analysis of the data from various time frame and division using SQL Server Reporting Services 2008 (SSRS). Created Dashboards and reporting services web parts using Moss 2007.
• Involved in deployment of SSRS reports on the SharePoint Portal.
• Generated parameterized/Drilldown, Drill through & Cascaded reports using SSRS and Crystal Reports.
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Used cascaded parameters to generate a report from two different Data Sets.
• Involved with Query Optimization to increase the performance of the Report.
• Developed Reports for business end users using Report Builder with updating Statistics.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS
• Configured and trained users to use Reporting Services.
• Responsible to support the issues with reports on the enterprise environments (Development, UAT, Test and Production).
• Implemented Business Intelligence Reports using Sql Server reporting services, Excel reports using Excel and then Uploaded to SharePoint Server 2010 using Excel Services and Report server Web parts.
• Key product areas utilized also include data modeling, SSRS report subscription and data driven subscriptions, SSAS Analysis Services processing tasks, cube processing options and roles.

Environment: SQL Server 2005,2008,2012 SSIS,SSRS,SSAS, XML, Share Point 2010 and 2012,Infopath, C#,.Net

Confidential

SQL Server Developer / ETL Developer

Responsibilities:

• Worked on developing Tables, Indexes, Views, Creating complex stored procedures, Triggers, Functions.
• Involved in gathering business requirements from clients about the credentials needed to access their servers, firewall settings and management about the table structures that are to be defined and the data structure that is to be collected from the clients.
• Created functional requirement specifications and supporting documents for business systems. Experience in database design process and data modeling process for Billing Method using Erwin.
• Designed Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008) and Excel Pivot tables based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Built Drill Down, Drill through, linked and sub reports using SSRS 2005.
• Designed reports using Pivot-tables, bar-charts, Line-charts and Pie-charts on data from cubes and SQL Server in Excel 2007.
• Involved in Source Data Analysis, Design and creation of Data Mappings for Extraction of bulk data from heterogeneous sources like Oracle, ADSI and other OLEDB data sources.
• Created Data-driven Packages in SSIS as part of the automating the process for billing method.
• Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages.
• Extracted data from various sources like SQL Server 2005/2008, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
• Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Transform and Load the Data from various Databases and into Siemens servers using SQL Server Integration Services (SSIS).
• Scheduling and maintaining SSIS Packages and batch jobs thru SQL Server Agent and thru various Shell scripts, VB script, and batch (.bat) files on a day to day basis.
• Experience in configuring with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
• Designed Partitions in Cubes on time for improvement in performance using SSAS.
• Developing OLAP cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes and dimension members using SQL Server Analysis Services (SSAS).
• Developed many MDX queries for creating calculated measures that fits business logic.
• Worked on Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).
• Published reports on to Share-Point and created Web Parts in Share-Point to show various reports generated from Excel and SSRS in one web part page.
• Created forms on share-point to show live data from underlying data-sources like SQL Server to Clients enabling them to edit the data and update the data in the underlying data-sources and allowing the users to insert data into the underlying data-sources.
• Created forms on share-point to show live data from underlying data-sources like SQL Server to Clients enabling them to edit the data and update the data in the underlying data-sources and allowing the users to insert data into the underlying data-sources.
• Experience in developing Life Cycle using Agile Methodology.
• Experience in optimization of queries, improving the performance and maintaining the database consistency with DBCC at regular intervals.

Environment: SQL Server 2000, 2005,2008,SSIS,SSRS,SSAS, XML, MS Project, MS Access 2000 & Windows 2K platform, Share Point, Crystal reports, Oracle 9i, C#,.Net.

Confidential

Jr Developer

Responsibilities:

• Determined the MS SQL Server 2000 installation options. Installed SQL Server Management tools using SQL Server Setup Program. Test the Installation of SQL Server and implemented different security modes.
• Worked on Client/Server tools like MS SQL Server 2000 Enterprise Manager and Query Analyzer to Administer SQL Server
• Used Aggregation Design Wizard to decide best possible aggregation for a given amount of disk space in MS Analysis services 2000.
• Experience in DTS for data flow from one source files like Excel, Tables, and Views to other databases or files with proper mapping.
• Implemented a successful security plan by creating statement permissions, linked servers and encryption of connections by creating certificates.
• Experience in writing stored procedures, functions, triggers and calling them in the packages.
• Created number of jobs, alerts and operators to be paged or emailed in case of failure for SQL 2000.
• Participated in maintaining and modifying tables and constraints for Premium Database using MS SQL Server
• Configured Database Mail, created operators, jobs and alerts for automating databases.
• Created DTS packages using Active X Task to migrate data from heterogeneous data sources such as MS Access, Excel etc
• Designed DTS package, with DTS Import/Export wizard for transferring data.

Environment: SQL Server 2000/2005 Enterprise Edition, Enterprise Manager, Query Analyzer, Import & Export Data, VB.Net, Windows 2005/2008, Windows Active Directory, MS Access, MS Excel.