SUMMARY

• 8 Years of IT experience in all aspects of Business intelligence applications with a strong background in Database development, Data warehousing/Decision Support Systems and Business Intelligence.
• Expertise in Full Life Cycle Development including Planning, Analysis, Design, Implementation and Maintenance. Good at working with Data Warehousing and business intelligence tools for developing various reports using SSRS.
• Proven expertise in analyzing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture.
• Expertise in MS SQL Server 2000 and MS SQL Server 2005/2008 suite of products like SSIS, SSAS, and SSRS.
• Experienced in Data Extraction, Transformation and Loading (ETL) using SSIS of MS SQL Server 2005.
• Expert in Creating, Configuring and Fine - tuning ETL workflows designed in MS SQL Server Integration Services (SSIS).
• Expertise in Developing and Extending MS SQL Server Analysis Services 2005 (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries.
• Experienced in generating On-demand and Scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2005/2008 (SSRS).
• Expert in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2005.
• Experienced in Logical and Physical Database design & development, Data Conversion, Normalization and Data modeling using Erwin and SQL Server Enterprise manager.
• Excellent experience in Designing, Maintaining & Tuning various RDBMS like T-SQL & MS SQL Server 2000/2005, MS Access databases and strong knowledge of SDLC principles.
• Expert in database creation, maintenance, monitoring, backups and recoveries.
• Specialized in analyzing, coding, implementing and creating complex query reports using Oracle 8i/ 9i/ 10g, SQL Server 2000/2005/2008 , Sybase and DB2.
• Interacted with Customers for requirement gathering and effective analysis.
• Good in validating the BI reports/dashboards by preparing the Test Plans & Cases.
• Experienced in writing UNIX shell scripts, SQL Loader, Performance & Tuning of Database.
• Excellent interpersonal communication, problem solving, documentation and business analytical skills.

TECHNICAL SKILLS

BI Tools: Qlikview, Micro Strategy, SSRS, SSIS, SSAS, SQL Loader, Toad, SQL Developer, Putty.

Databases: MS SQL Server 2005/2008, MS Access, Oracle8i/9i, Teradata

Web Technologies: HTML, XML, ASP, Java Script, VB Script, Servlets, JSP

Data Modeling Tools: Erwin, Visio 2000

Operating Systems: Windows 95/98/2000/XP/NT, UNIX.

Languages: C, C++, Java, PL/SQL, SQL, Unix.

PROFESSIONAL EXPERIENCE

Confidential, Chicago IL

MS SQL Server/Business Intelligence Developer

Responsibilities:

• Fixed the bugs present in already existing reports.
• Developed many Tabular Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Identified and worked with Parameters for parameterized reports in SSRS 2005.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Deployed the generated reports directly on the client’s workstation.
• Created many multi valued parameters in the reports.
• Created many Cascaded parameters in the reports using MDX and T-SQL.
• Improved Report Performance and performed unit testing.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Created the structure of the model and cube in MS Analysis Services (2008).
• Analyzed and designed software and database solutions.
• Reviewed Cube with End user and changing the cube and documentation according to their requirements.
• Defined relationships between Measure groups and Dimensions.
• Generated automatically grouping attribute members.
• Implemented the calculations to aggregate physical measures.
• Created MDX queries to retrieve data from the cube and also to display SSRS reports.
• Created reports to generate them through Email for the administrative using MDX Queries.

Confidential, Chicago IL

MS SQL Developer

Responsibilities:

• Implementation and delivery of MSBI platform solutions to develop and deploy ETL, analytical, reporting and scorecard / dashboards on SQL Server 2008 using SSAS, SSIS/DTS, SSRS.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Migration ofDTSpackages toSSISpackages
• Involved inMigrationof Databases fromSQL Server 2005 to SQL Server 2008 using SSIS.
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team,Capacity planningandUp gradationofSystem Configuration.
• Configured and MonitoredDatabase Mirroringfor Application Development environment
• Involved in Installation, Configuration and Deployment of Reports usingSSRSwithScale-Out topology.
• Involved in SQL ServerConfiguration, Administration, ImplementationandTrouble-shootingfor Business work.
• Controlled, coordinated installations(Security Patches, Service packs)and evaluated the performance before deployment.
• Involved in daily code drops and archives on the production databases during maintenance windows.
• ScriptedOLAPdatabasebackupand scheduled a daily backup usingSQL Serveragent job.
• Performed Regular Database Maintenance process, checking the diskDefragprocedures in different environments.
• UsedSQL Profilerfor Performance monitor to resolveDead Locksand Long running queries by checking appropriate changes to Transaction Isolation levels
• PerformedDatabase Refreshtasks from production toDevelopmentandStaging Servers
• Database Performance of Index tuning with usingDatabase Engine Tuning Advisorto resolve Performance issues
• Developed and optimized database structures,stored procedures, Dynamic Management views, DDL triggersanduser-defined functions.
• Involved in writingStored ProceduresandFunctions, Cursorsto handle database automation tasks

Environment: SQL Server 2008/2005, Oracle 10g/ 9i, .Net Framework 2.0, C#.Net, Asp.Net2.0, JavaScript, VSS, Windows 2000, Windows 2003 Server, MS TFS, MS-Access.

Confidential, River Side RI

MS SQL Server/ SSIS/SSAS/SSRS Developer

Responsibilities:

• Analyzed the existing reports in Report.Net, Actuate and their data sources
• Analyzed & designed the business rules for data cleansing that are required by the staging & OLAP and OLTP databases.
• Extracted data using SSIS packages (ETL) from different server locations and data sources.
• Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, Text Format Data, Oracle and Db2
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Created Parameterized, Linked, Snapshot, Cached, Ad hoc, Click through, Drill down, Drill through, Sub reports for top selling equipment in the company, top sales based on region and sales based on season.
• Wrote queries for Drilldown reports to get the complete details of the sales sold in particular region.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Deployed generated reports of each quarter onto the Report Server to access it through browser.
• Created various geographical and time dimension reports of fiscal year, quarter month, week and daily reports for all domains and published through Report Server.
• Created various reports by comparing the growth of sales based on each quarter by using bar charts.
• Responsible for generating annual reports based on the growth of sales with respect to customers.
• Created calculated measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Used Visual Source safe for repository and maintaining versions.
• Worked as a developer in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T SQL code and SQL joins for applications.
• Extensively used formula fields, parameter fields, Running Total, Group selection and record selection in Crystal reports for writing new formulas.
• Conducted user sessions and supported the requests for enhancements, modifications and new reports.

Confidential

MS SQL Server/ SSIS/SSRS Developer

Responsibilities:

• Transformed data from MS SQL Server 2000 to MS SQL Server 2005 using OLE DB connection by creating various SSIS packages.
• Created Data Transformation tasks like BCP, BULK INSERT to import/export data from clients.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Designed a new schema for the Data Mart databases.
• Implemented SSAS Cubes, Facts and Dimension tables to perform analysis.
• Created MDX queries to extract data from the Data Mart.
• Generated Dynamic reports from Cubes (SSAS) using SSRS-2005.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Generated various reports like Cascade type reports, Tabular reports, and Drill down reports.
• Created Store Procedures, Functions and Triggers for retrieval and update of data in the database.
• Generated Daily, Weekly and Monthly Trigger based reports regarding assigned projects to designated Managers and Clients.
• Created simple data entry applications using C#.Net 2005 and SQL 2005 Server.
• Used HTML code to make Report manager more functional & customizable.
• Used Index Tuning Wizard, SQL Profiler and SQL Query analyzer for Performance Tuning.
• Extracted and reviewed data from sources like (Excel, CSV, Oracle, flat file, Text Format Data) using SQL Server Integration Services (SSIS) from OLTP to OLAP.
• Implemented MS Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.
• Created calculated measures and dimension members using multi-dimensional expressions (MDX), mathematical formulas, and user-defined functions.
• Involved in Writing SQL Queries, Views and Stored Procedures on SQL Server 2005.
• Designed databases for applications with requirements for large numbers of transactions, heavy access and high availability.
• Upgraded MS SQL Server 2000 databases to 2005, using Detach/Attach, Back up & Recovery and by Replication.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Created Views to reduce database complexities for the end users.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• 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 2005.
• Generated reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.
• Performed Documentation for all kinds of reports, DTS and SSIS packages.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Maintained the table performance by following the tuning tips like Normalization, Creating Indexes etc.
• Used the HTML code to make the Report Manager more functional and customizable.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.
• Involved in requirements gathering, analysis, design, development, deployment and user .
• Created numbers of complex formulas in sub reports using different type of variables likes shared variable and retrieved them from master report.
• Involved in writing Custom Functions to be used in other Functions.
• Understood an existing system and designed modifications to the system to support new requirements.
• Designed, developed and tested processes, which include the creation of SQL views, scripts, stored procedures and DTS packages.