SUMMARY

• Over 10 years of SQL Server Development and Reporting Services experience, Stored Procedure/TSQL coding, Performance and Tuning, Physical and logical Database Design
• Proficient in MS SQL Server suite of products like SSRS, SSAS and SSIS of MS SQL Server 2005/2008
• Extensively involved in installation of MS SQL Server 2008/2005/2000/7.0, performance analysis, performance tuning.
• Experienced in creating reports using SQL Server Reporting Services sourcing OLAP cubes and data warehouse database
• Proficient in creating and designing the report layout, sorting the data, defining subtotals and generated Reports like parameterized reports, drill down reports using SSRS 2005
• Expertise in SQL Server 2000/2005 Reporting Services and developing Stored Procedures and Triggers in SQL - Server and in publishing the SQL server reports
• Excellent experience creating/publishing Dashboard reports, KPI’s, Scorecards, using Report Center to SharePoint 2007 and in developing interactive sort reports
• Experienced in formatting the SQL Server Reports and in creating configuration files, error handling, logging in SSIS and in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Strong Experience in SQL database design, architecture, data modeling using Erwin; Data Warehousing and analysis skills: ETL tools, MDX, OLAP (MOLAP, HOLAP, and ROLAP), dimensional modeling, star schema and snowflake schema.
• Excellent knowledge in creating MDX cubes and dimensions using star and snow flake schemas(SSAS)
• Excellent knowledge in maintenance and change management to existing reports and in optimizes report performance
• Developed, implemented and documented production DTS, SSIS packages. Expertise in performance tuning and trouble shooting on database objects and Expert in defining and deploying Cubes using SQL Server Analysis Services (SSAS).
• Expert in development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Data Transformation Services (DTS), Informatica and SSIS with MS SQL 2005/2008. Proficient in creating SSIS packages from scratch and deploying them
• Experienced in working with different data sources like OLE-DB, flat files and Excel to source data in SSIS. Experienced in handling change data capture, late arriving facts and complex mappings in SSIS
• Outstanding oral and written communication skills. Ability to handle multiple tasks and demonstrates initiative and adaptability and capable of handling responsibilities independently as well as a proactive team member

TECHNICAL SKILLS

• MS SQL Server 2000/2005/2008
• MS SQL Server Reporting Service 2005/2008
• MS SQL Server Analysis Services 2005/2008
• MS SQL Server Integration Services 2005/2008
• DTS
• MS Visio 2003
• Netezza
• MS Access
• C
• FrontPage
• Visual Basic 6.0
• VBA Access
• ERWIN
• Windows 9x/NT/2000/XP/Server 2003
• T-SQL
• HTML
• XML
• VBScript
• Crystal Report
• Qlikview.

PROFESSIONAL EXPERIENCE

Confidential

BI Developer/ SSRS Developer

Responsibilities:

• Convert Crystal Reports to SSRS 2008 format.
• Fix the bugs in already existing reports.
• Develop Tabular Reports, Matrix Reports, Drill Down Reports and Charts using SQL Server Reporting Services (SSRS)
• Generate Reports using Global Variables, Expressions and Functions for the reports
• Transfer data from various sources like MS Excel, MS Access, Netezza,SQL Server using SSIS and then created reports using this data using SSRS. Created new and converted several Crystal reports into detailed SSRS reports. Debugged reports for the business end users.
• SharePointdesigner 2010 customizing master pages and configuring Workflows.
• Developed and deployed SSIS packages. Used SQL Server Agent to automate the SSIS package execution. Tested and managed the SSIS packages
• Deploy the generated reports on the Production Server.
• Create Cross-Tab, Drill-down and Sub-Report for the loan policies using SSRS
• Write Requirement Documents for the newly created reports and existing crystal reports.
• Explain Business Users scope of the reports.
• Worked on Functional Requirement Document and uploaded those documents on Sharepoint.
• Improve Reports according to the feedback of End Users and QA Team.
• Gather requirements from Business Users in order to convert pre-existing Crystal Reports.
• Develop ad-hoc reports, drill through reports, drill down reports, parameterized reports, and other report models using MS SQL Server 2008 SSRS
• Work on complex SQL Stored Procedures and performance tune the SQL Queries.
• Generate reports from existing SQL Stored Procedures.
• Interact with QA Team for the converted reports.
• Perform 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 2008
• Involve in training the other team members for Reporting Services.
• Develop trend indicating reports which monitor changes in different categories and record historical analysis and displays them in a single dashboard.
• Export Report Data to Excel Sheet.
• Work on Pivot Tables, Charts and Graph on Microsoft Excel.
• Write new Stored Procedures for creating new reports on basis of requirements of Business Users.
• Produce, maintain, and monitor corporate dashboard reports which gather data from multiple servers for executives and external parties throughout the organization for multiple departments.

Environment: MS SQL Server 2008, SSRS, SSIS, T-SQL, Windows 2003, MS SharePoint, Microsoft Office Suite 2007

Confidential, Chicago, IL

BI Lead/QA Analyst

Responsibilities:

• Wrote Test Cases in SQL/Oracle to test the migration of data from one data warehouse to another.
• 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
• Facilitated implementation of automated scripts.
• Participated in cross functional discussions to review the impact of application changes from both internal and external interfaces on the quality of their applications.
• Worked with application development teams to participate in solution design to ensure testability of functions and applications.
• Troubleshooted and resolved the issues occurred in the new datawarehouse feeds.
• Tested data using Confidential Compare tool. Checked for discrepancies in data migrated to PaymentNet4.
• Worked with Offshore team to help them with better understanding of functional requirement document and execution of Test Cases.
• Worked on Requirement analysis and suggesting changes in the requirements.
• Executed Test cases and was involved in analyzing, retesting and logging the defects on HP Quality Centre.
• Reviewed FRD (Functional Requirement Document) with BSA Team and provided them feedback.
• Created Test Sets on Quality Centre and Wrote description of each Test Case in order to make them easy to understand for other team members.
• Supported monthly releases as QA Lead. Assigned work to Onshore and Offshore Team and supported team for test execution.
• Creating Charts and Graphs on MS Excel to assign tasks and measure improvement of Offshore Team.
• Transferred data from various sources like MS Excel, MS Access, SQL Server using SSIS and then created reports using this data using SSRS
• Used Qlikview graphs to create SSRS Reports.
• Created SQL scripts to insert/update and delete data in MS SQL database. Created database tables, wrote stored procedures to update and clean the old data and also helped the front end application developers with their queries
• Involved in table and index partitioning for performance improvement and manageability and identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization
• Generated reports using SSRS that could be used to send information to different primary vendors, clients, and managers
• Worked on dashboards to measure the progress of the Production Release testing.
• Involved in documentation for all kinds of reports, DTS and SSIS packages
• Designed and implemented stored procedures and triggers for automating tasks

Environment: MS SQL Server 2008, SSRS, SSIS, Microsoft Office Suite 2007, Oracle SQL Server,HP Quality Centre, Confidential Compare Tool, MS Sharepoint, Autosys, T-SQL, Windows 2003

Confidential, Scranton, PA

BI Developer

Responsibilities:

• Developed stored procedures to transform the data from enterprise data warehouse to SQL server and load data to fact tables.
• Created SQL scripts to insert/update and delete data in MS SQL database. Created database tables, wrote stored procedures to update and clean the old data and also helped the front end application developers with their queries.
• Involved in table and index partitioning for performance improvement and manageability and identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• 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.
• Responsible for designing and implementing system modules using C#.NET and Visual Studio 2008.
• Involved in documentation for all kinds of reports, DTS and SSIS packages.
• Designed and implemented stored procedures and triggers for automating tasks.
• Developed graphs and charts to display telecommunication data categorized by hierarchy and organization. Developed Parameterized, Drill Through, Rolling, Linked and Sub-reports with specific KPIs. Developed indicators for rolling reports and drill down reports.
• Wrote code for VBA programming and debugging on VBA Access 2010.
• Work simultaneously with slowly changing dimensions and real time data to report accurately.
• Generated Reports using Global Variables, Expressions and Functions for the reports and created stylish Report Layouts and Deployed the Reports using SSRS 2005/2008.
• Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects.

Environment: MS SQL Server 2008, SSRS, SSIS, Netezza,Autosys, T-SQL, Windows 2003, VBA Access 2010.

Confidential, NY

BI Developer

Responsibilities:

• Defined, designed and identified the data sourcing, data flows and data quality analysis to build the data source views
• Imported data from various sources such as Oracle, DB2, MS Access, Teradata and transformed to data warehouse
• Involved in extracting the data from OLTP to OLAP using Informatica
• Used various transformations while mapping the data from source to destination using SSIS and defined relationships between Dimensions and Measure groups
• Eligible customers having insurances from long time are given some special discounts and offer in the future renewals and are highlighted by conditional formatting with SSRS 2008
• Worked with .Net application teams in the development of database objects for transactional systems .
• Developed and deployed SSIS packages. Used SQL Server Agent to automate the SSIS package execution. Tested and managed the SSIS packages
• Developed stored procedures to transform the data from enterprise data warehouse to SQL server and load data to fact tables
• Transferred data from various sources like MS Excel, MS Access, SQL Server using SSIS and then created reports using this data using SSRS
• Created Cross-Tab, Drill-down and Sub-Report for the insurance policies using SSRS
• Generated Reports using Global Variables, Expressions and Functions for the reports and created stylish Report Layouts and Deployed the Reports using SSRS 2005/2008. Helped convert Crystal reports to SSRS reports, maintain and generate subscriptions.
• Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects

Environment: MS SQL Server 2008, SSRS, SSIS,Informatica,MicroStrategy 9.0, T-SQL, SQL Server Query Analyzer, Visual Studio, Windows XP, Window Server 2003/2008.

Confidential, NY

MS SQL BI Developer SSIS/SSRS/SSAS

Responsibilities:

• Installed, upgraded and migrated databases from Oracle database to MS SQL Server 2005/2008
• Generated reports using MS SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources
• Developed ad-hoc reports, drill through reports, drill down reports, parameterized reports, and other report models using MS SQL Server 2005 SSRS
• Developed Qlikview reports for analysis purpose and better understanding.
• Constructed the OLAP cube using SSAS and used SSIS to transform the data into OLAP
• Designed ER diagrams and mapped the data into database objects and performed normalization of the database in OLTP
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agentusing SSAS
• Wrote MDX scripts to create name sets and calculated members and created reports by dragging data from cube in SSAS
• Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server 2005
• Created SQL scripts to insert/update and delete data in MS SQL database. Created database tables, wrote stored procedures to update and clean the old data and also helped the front end application developers with their queries
• Involved in table and index partitioning for performance improvement and manageability and identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization

Environment: MS SQL Server 2005/2008, MS SQL Server reporting services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), T-SQL, SQL Server Query Analyzer, Visual Studio, Windows XP, Window Server 2003/2008.

Confidential, Germantown, MD

MS SQL Server Developer/BI 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 and created many Cascaded parameters in the reports using MDX and T-SQL
• 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)
• Reviewed Cube with End user and changing the cube and documentation according to their requirements
• Created MDX queries to retrieve data from the cube and also to display SSRS reports
• Used Caching (Cache Technology) for fast retrieval of data to generate reports against data warehouse
• Created reports to generate them through Email for the administrative using MDX Queries

Environment: MS SQL Server 2008, T-SQL, SSRS, SSIS, SSAS, Visual Studio 2008, Win NT /2000/ 2003, MS Office 2007/2003, Microsoft Office Share Point - 2007.

Confidential, Edison, NJ

MS SQL Server Developer/SSRS/SSIS Developer

Responsibilities:

• Involved in planning, defining and designing data and provided documentation
• Upgraded MS SQL Server 2000 databases to 2005, using detach/attach, backup and recovery and by replication.
• Developed and Implemented UNIX shell scripts through command task to handle requirements like dropping and building indexes, flat file archiving/dropping process etc.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs
• Used various SSIS tasks such as conditional split, derived column e, which did data scrubbing, including data validation checks during staging, before loading the data into the data warehouse
• Created error and performance reports on SSIS packages, Jobs, stored procedures and triggers.
• Created sub-reports, drilldown-reports, summary reports, and parameterized reports in SSRS
• Generated ad hoc reports using MS Reporting services and crystal reports
• 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
• Involved in 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 Index and ensured best practices are applied and integrity of data is maintained through security and documentation.

Environment: MS SQL Server 2000/2005, T-SQL, SSRS 2005, SSIS 2005,MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studio 2005,Erwin v4.1, Windows XP, MS Office 2003/2007, MS Access, Crystal Reports 9/10,Unix Shell Scripting.

Confidential

MS SQL Developer

Responsibilities:

• Carried out a Developer’s role on MS SQL Server 2000, MS Access Databases (using DTS, Stored Procedures and Views)
• Involved in developing the SQL code for the application
• Involved in designed and implementing the Stored Procedures and Triggers for automating tasks
• Worked on MS SQL Server tasks such as Data Loading, Batch Jobs, BCP, DTS and Indexes and analyzed the Reports, Tables and ETL process
• Created and automated regular Jobs such as Daily/Weekly Report Generations
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon
• Managed and Monitored System Utilization
• Managed Backup and Disaster Recovery of the systems
• Managed the security of the servers as a part of administration duties

Environment: MS SQL Server 2000/7.0, Windows Server, ETL, DTS, SQL Reporting Services, Windows NT.