SUMMARY

• 10+ years experience as MS - SQL Server Developer, involved in Design, Development and Support of MS SQL Server 7.0/ 2000/2005/2008 for both OLTP and OLAP Systems.
• Excellent working skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS. Configured report subscriptions both data driven and time driven.
• Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, cursors.
• Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities.
• Experience in integration of various data sources like SQL Server, Oracle, DB2 UDB and Flat Files. Expertise in Unit Testing, Functional Testing, System Integration Testing, Review Test Cases and Test Results.
• Extensively used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS and designed data conversions from wide variety of source system.
• Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using, Data Transformation Services (DTS) and SSIS with MS SQL 2005/2008.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.
• Building and writing MDX Queries, Calculated Members, and KPI’s using Microsoft SQL Server 2005/2008 Analysis Services Business Intelligence (SSAS, SSRS).
• Involved in migration of DTS Packages (2000) to SSIS (2005) and troubleshoot migration issues. Expert in generating drill down Reports in SSRS 2005/2008.
• Experience in providing Logging, Error handling using Event Handlers, Pre, and post for SSIS Packages. Deployed reports across Test, Dev and production environments.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Developed dashboard reports using SQL Server Reporting Services (SSRS), Report Model and ad-hoc reporting using Report Builder.
• Experiences in SQL Server Analysis Services OLAP Cubes, and Data Mining.
• Performed Data Mining activities on central repository for various application and dashboard functionalities. Actively involved in the analysis of Cubes and added the Key Performance Indicators (KPI) to the created cubes.
• Experience with Implementation and maintenance of Business Intelligence tools for analysts and executive dashboards.
• Created Scorecards/Dashboard Pages in Performance Point Server (PPS).
• Expert in calculating measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Involved in creating daily full backups, hourly transaction log backups and weekly maintenance plans. Creating and Managing logins, users, roles and assigning necessary permissions.

TECHNICAL SKILLS

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS)

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools: SQL Server Reporting Services ( 2008/2005/2000 ), MS Access, MS Excel

Database: MS SQL Server 2008/2005/2000, MS Access, Oracle 9i/8i

Programming: T-SQL, PL-SQL, C

Web Technologies: HTML, DHTML, XML, XSL, Java Script (Validation), CSS, PERL

Operating Systems: Windows (95/98/2000), Windows 2003 Server, Windows XP, Windows Vista

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, ERWIN, Adobe Photoshop, Abode Flash

PROFESSIONAL EXPERIENCE

Confidential, Naperville, IL

SSIS/PL/SQL Developer

Responsibilities:

• Created new database objects likeTables, User Defined Functions, Triggers, Procedures, Functions, IndexesandViews, SQL joins and statements as per the developer team’s request through team tracks.
• Involved in data cleansing to facilitate efficient data transfer between various environments.
• Analyzed performance related queries and tune the same using SQL Query Analyzer to optimize application and system performance.
• Perform T-SQL tuning and optimizing queries for Reports and SSIS packages.
• Created several SSIS packages for performing ETL operations to transform data from a cube using MDX.
• Worked on Extraction, Transforming and Loading (ETL) data flows using SSIS and created mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.
• Created SSIS package to load data from Flat File to Flat File and Flat File to SQL Server 2005 using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation and Slowly Changing Dimension.
• Created SSIS Packages using SSIS Designer for export heterogeneous data, Excel Spreadsheet to SQL Server 2005.
• Created reports from data warehouse using SSRS i.e. Drill Down, Drill Through and Sub Reports

Environment: SQL Server 2005/08, SSIS, SSRS, MDX, T-SQL, Visual Studio

Confidential, Chicago, IL

ApplicationDeveloper

Responsibilities:

• 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.
• Migrated reports from Congo are to SSRS.
• Excellent report creation skills using Microsoft SQL Server 2008/2005 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Created SQL Server Reports based on the requirements using SSRS 2008.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Worked closely with the Data modeler.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Created complex reports which involve more number of groupings and multi-value parameters.
• Developed FAS 115 and 157 reports and some end user request reports on periodic basis.
• Giving inputs to the team.
• 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).
• 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.
• Used Tableau business intelligence software to build relationship between tables, build hierarchies, design cross tab, perform member calculations, filter, sort, grouping and publish report on tableau server for client use.
• Handful experience in working with the new concept of Tablix Data Regions in the Report Layout and Created a stack of stepped reports using the Tablix.
• Developed reports and deployed them onto SharePoint 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.
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Created and scheduled jobs for various tasks and also was responsible for maintaining jobs.
• Worked very closely with Business owners, End Users and resolved any business process related issues.

Environment: Windows server 2003, IIS 6.0, MS SQL Server-2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, Erwin, Office-2007, MS Excel, C#.NET, ProClarity Analysis.

Confidential, Westmont, IL

SQL/SSIS Developer

Responsibilities:

• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Developed logical and physical data models for schemas using MS Visio.
• Coordinated with DBA in creating and managing tables, indexes, triggers, db links and privileges.
• Designed, reviewed, and created primary objects such as views, indexes based on logical design models, user requirements and physical constraints.
• Designed SSIS Packages to transfer data from Oracle and flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.
• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Handled slowly changing dimensions to maintain the history of the data.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Designed, Developed and Deployed reports in MS SQL Server environment using Crystal reports and SSRS-2008.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using Crystal Reports.
• Created reports to retrieve data using Stored Procedures that accept parameters using SSRS.
• Possess SQL and programming knowledge to deal with data transformations and translations.
• Find the right balance between manipulating data using Tableau versus using a programming language.
• Involved in the design and development of web forms for the application using ASP.Net, DHTML, XML, and Cascading Style Sheets (CSS).
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Environment: MS SQL Server 2008, SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), BIDS, Visual Studio 2005, VSS 2005, MS Visio 11.0, Oracle 10g, DHTML, CSS, C#,ASP.NET, Windows NT/2003.JPMorgan ChaseChicago, IL

Confidential, Chicago, IL

ASP.NET Developer

Responsibilities:

• Analyzed all the Database Structure and prepared a reference guide to understand the existing system better.
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Created SSIS packages to Oracle and other SQL Server instances and used configuration files and variables for production deployment.
• Involved in making mappings and transformations using DTS Transform Data Task, Data Driven Query Task.
• Scheduled SSIS Packages for loading Facts and Dimensions.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Involved in updating slowly changing dimensions strategies.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Designed and built OLAP cubes to meet reporting needs.
• Responsible for identifying and defining Data Source and Data Source views.
• Created cubes and defined the dimensions.
• Responsible for defining calculated members.
• Developed Multi dimensional Objects (Cubes, Dimensions) using MS Analysis Services (SSAS).
• Build MDX queries and Data Mining Expression (DMX) queries for Analysis Services SSAS and Reporting services SSRS.
• Defined attribute properties in a Parent Child Dimensions.
• Used Joins to write queries that retrieve data from more than one table.
• Responsible for hiding and disabling attributes and attribute hierarchies.
• Developed reports that deliver data from cubes.
• Created and managed subscriptions for the reports.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance.
• Created stored procedures to calculate pension and annuity information, when called will give the details for an employee on the website.
• Defined specific read/process permissions for the users in SSAS instance.

Environment: Windows 2003/XP, SQL Server 2005 BI Suite, SSAS, SSIS, SSRS, ETL, OLAP, OLTP, ASP.NET, PROCLARITY, MDX, T-SQL, MS Visual Studio 2005.

Confidential, Warrenville, IL

SQLServerDeveloper

Responsibilities:

• 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.
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Excellent report creation skills using Microsoft SQL Server 2008/2005 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Created SQL Server Reports based on the requirements using SSRS 2008.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Created complex reports which involve more number of groupings and multi-value parameters.
• Developed reports like Claim Statements, Fee Bills Transactions and some end user request reports on periodic basis.
• Defined sections and sub-sections for the reports
• Installed search and store functions in the existing applications to save search query keywords and results for future reference
• Provided maintenance and resolved technical errors arising in the by Shopping Sidekick Plugin">application
• Used Tableau business intelligence software to design reports in different format
• Used Tableau business intelligence software to build relationship between tables, design cross tab, perform calculations, filter, sort, grouping and publish report on Tableau server for client use.
• Use Tableau to create data relationships and visualizations.
• Developed some report using Crystal Reports 11
• Developed components to allow automated generation of reports
• Enabled advanced filters to sort data from third party applications
• Enabled by Shopping Sidekick Plugin">remote server access to import and export data to the centralized server

Environment: Crystal Report 11, SSAS, SQL Server 2012, SSRS, Tableau 7

Confidential, Chicago, IL

ASP.NET Developer

Responsibilities:

• Understanding the Reporting design requirements from the Architects and Business Analyst.
• Interact with SME’s and End Users for requirement gathering, process improvement, problem identification, project analysis & review meetings and progress reporting.
• Designed SSIS package for automatic data migration to transform Data from SQL Server 2000 to SQL server 2008.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server Analysis Services (SSAS)-2008/2005.
• Well versed in defining/creating and handling Data Sources, Data Source views and parameterized Reports in SSRS 2008.
• Designing OLAP cubes, Data Modeling, Dashboard Reports, and scorecards according to the business requirement.
• Served as technical expert guiding choices to implement analytical and reporting solutions for complex financial scenarios.
• Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL.
• Design and develop SSIS (ETL) packages for loading data from Oracle and Flat files (3GB) to SQL Server Database.
• Created packages in SSIS with error handling as well as complex SSIS packages using various Data transformations like Lookup, Script Task, and Conditional Split, Derived Column, Fuzzy Lookup, and Partition task, For-Each loop container in SSIS; scheduled the same SSIS packages by creating the job tasks.
• SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Participated in creating Jobs for various packages that run at specific schedule every day based on some dependencies.
• Created clustered and non-clustered indexes on tables for new database to faster retrieval of data for the Reports.
• Understanding the OLAP processing for changing and maintaining the warehousing, optimizing Dimensions, Hierarchies and adding the Aggregations to the cube.
• Responsible for processing CUBE Partitions and Dimensions.
• Involved in writing MDX queries for various calculated members.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.
• Managing the Report Server contents with Admin privileges and Report Manager for Subscriptions, Snapshots and Security Content on the reports.

Environment: Windows 2003 Server, SQL 2008/2005 Enterprise Edition, Import-Export (DTS), SSRS, SSAS, SSIS, OLAP, OLTP, MDX, T-SQL, ASP.NET2.0, C#.NET, ADO.NET, Microsoft Visual Studio.Net 2005, .NET Framework 2.0, EXCEL 2007.

Confidential, Princeton, NJ

ASP.NET/Web Developer

Responsibilities:

• Database upgrade from SQL server 2000 to SQL Server 2005.
• Perform Back-ups, Restores, Scheduling, Maintenance
• Created SSIS packages to ETL data into production system and to produce/schedule management control reports.
• Extensively worked on converting DTS packages to SSIS packages.
• Developed SSIS packages to load data from application database and flat files into destination database.
• Used Derived Column transformation to perform various calculations.
• Implemented package configurations in SSIS packages that allow transferring packages from one environment to other.
• Deployed SSIS packages to production, schedule them to run on routine basis and monitor the error log for any errors.

Environment: SSIS, MS SQL Server 2005, DTS, SQL Server 2000, Windows, C-Sharp, Erwin Data Modeler

Confidential, Northbrook, IL

System Analyst (Design & Development)

Responsibilities:

• Created Database as per the requirement of the bank to maintain the student records using SQL server 2000.
• Maintained and supported the SQL Server databases as a developer helping administrator.
• Involved in the Data modeling, Physical and Logical Design of Database.
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Written stored procedures and triggers to implement business rules.
• Involved in integration of the front end with the SQL Server backend.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Maintained disaster recovery Backup and Re-Indexing was implemented to increase the performance.
• Created user profiles and corresponding read, write and DDL and DML access properties were maintained on the database.
• Created documentation as required.

Environment: MS SQL Server 2000, T-SQL, DTS, MS-Excel, MS-Office, Oracle8i and C.