SUMMARY

• Dedicated IT professional with 7 years of progressive experience in Business Intelligence Applications development, Database Design and Development with MS SQL Server 2005/2008/2008 R2 Suite.
• Strong experience in MSBI (SSRS, SSIS, SSAS).
• Expert in creating varieties of Reports using SSRS 2012/2008 R2/2008/2005 including drill down, drill through, tabular, linked, sub reports and matrix style layouts, parameterized reports, cascading parameters and Ad - hoc reports.
• Deep understanding of Information TechnologySoftware Development Life Cycle (SDLC)methodology and project management principles.
• Strong knowledge and understanding of data warehousing.
• Extensive experience in MS SQL Server 2008 R2/2008/2005 with Business Intelligence (SSRS, SSIS).
• Experience in building Data Integration and Workflow Solutions and Extract, Transform and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).
• Excellent problem solving skills and very good at resolving performance and data related issues.
• Experience in testing data and applications.
• Knowledge in SQL Server Configuration, Installation and Migration.
• Excellent communication skills and very good team player.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

SSRS Reports Developer

Responsibilities:

• Design and develop reports using SSRS.
• Develop different kinds of reports like Drill Through, Drill Down, Linked using cascading parameters etc.
• Provide built in security in the reports using Active directory permissions.
• Write complex SQL queries and stored procedures to bring in data from old AS400 system.
• Test the reports for data integrity and work with business team to fix any data issues found during testing.
• Train business users on how to use reports.
• Production deployment of reports, granting access permissions to users and maintaining report manager on administrative level.

Environment: Microsoft SQL Server 2012, SSRS, SQL Server Management Studio, Astea, Microsoft Dynamics NAV.

Confidential, Birmingham, AL

Data Analyst and Reports Developer

Responsibilities:

• Interact with business users to gather the reporting requirements.
• Analyze data and check for data integrity.
• Coordinate with data team to fix the data issues.
• Develop and maintain reports in SSRS and Report Builder 3.0.
• Perform unit testing and assist users with UAT.
• Maintain documentation for internal use.
• Responsible for training end users on how to use reports.
• Production deployment of reports, granting access permissions to users and maintaining report manager on administrative level.
• Schedule the reports to deliver them to end users via emails and File share.
• Assisting Business Analysts with testing data during the application upgrade process.

Environment: Microsoft SQL Server 2008, SSRS, SQL Server Management Studio, Toad, Maximo, Remedy.

Confidential, West Des Moines, IA

SSRS Reports Developer

Responsibilities:

• Migrated reports to use the new Salesforce data warehouse.
• Worked with Business Analysts and end-users to analyze the requirements and gather data for the development of the reports.
• Developed drill down, drill through, tabular, matrix and parameterized reports with complicated data sets.
• Developed complicated parameterized reports with cascading parameters, multi-value parameters and passing parameters to drill though reports.
• Performed conditional formatting in reports to support the customer needs (Ex: Converting order amounts to Functional currency, displaying columns based on the parameter selection, displaying report data based on the user role hierarchy).
• Developed reports in SSRS to replace the manual reports.
• Maintained existing reports and addressed production support break-fix tasks in a timely manner.
• Performed Unit testing and supported QA team to get the UAT on reports.
• Wrote complex Oracle PL/SQL queries to support the reporting needs.

Environment: Microsoft SQL Server 2008, SSRS, SQL Server Management Studio, Oracle SQL developer, Siebel, Sales force, Zuora, JIRA.

Confidential, West Des Moines, IA

Database Analyst 6

Responsibilities:

• Worked with Home Mortgage Business Intelligence management team, co- workers and Collections management team to identify refine or review data or report needs.
• Performed Requirement Gathering, Analysis and implementation of SSRS reports.
• Developed and maintained tables, queries, stored procedures and views to support business needs and reporting requirements.
• Created SSIS packages to extract data from various source systems like Oracle and DB2.
• Provided support to maintain the existing reports, software issue investigation, defect analysis and provided timely corrective actions.
• Created complex stored procedures using dynamic SQL and CTE.
• Created Ad-hoc reports and provided the result sets in excel sheets for user convenience.
• Generated daily, weekly and monthly based reports to designated managers and clients.
• Applied conditional formatting in SSRS to highlight key areas in the report data.
• Optimized the performance of various SQL queries, stored procedures, CTEs and views.

Environment: Microsoft SQL Server 2005/2008, SSRS, SSIS, SQL Server Management Studio, Report Builder 3.0, DB2, Oracle, JIRA, TFS, YOM(You Owe Me).

Confidential, Philadelphia, PA

SQL Server Report Developer

Responsibilities:

• Performed Analysis, Requirement gathering, designing Technical specifications, development, deploying and testing.
• Designed and developed reports in SQL Server 2008 R2
• Installed and Configured SQL Server Reporting Services 2008 r2.
• Developed complex Reports involving Sub Reports, Matrix / Tabular Reports, Chart/Graph Reports, Parameterized reports, Cross-Tab reports, Drill down reports and Summary reports by using SSRS.
• Created Reports in SSRS with different type of properties including Chart controls, filters, Interactive sorting, and SQL parameters.
• Administered Report Server to organize reports and data sources, schedule report execution and delivery, subscription of reports and track reporting history.
• Created Stored Procedures and Views and datasets in TSQL.
• Responsible for back up and restoration of SQL Reporting Service.
• Created Report Snapshots to improve the performance of SSRS.
• Applied conditional formatting in SSRS to highlight key areas in the report data.
• Scheduled daily, weekly and monthly based reports to designated managers and clients.

Environment: Microsoft SQL Server R2, SSRS, SQL Server Management Studio, Report Builder 3.0.

Confidential, Richfield, OH

SQL Server Reports / BI Developer

Responsibilities:

• Performed Analysis, Requirement gathering, developing technical specification, development, deploying and testing.
• Installed, configured SSRS and troubleshoot reporting services issues maintaining reporting site security.
• Developed complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs and deployed them to Report Server for business users.
• Implemented row level and data level security for reports developed in SSRS.
• Defined Indexes, Views, Constraints, and Triggers to implement business rules.
• Identified Facts, Dimensions, and Hierarchies of the business model.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Used SSIS to create ETL packages to validate, extract, transform and load data to Data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.

Environment: Microsoft SQL Server 2005/ 2008, SSRS, SSIS, SQL Server Management Studio.

Confidential, Philadelphia, PA

SQL / Reports Developer

Responsibilities:

• Actively supported business users for change requests.
• Created several tables, views, triggers, stored procedures, indexes based upon the functional specifications.
• Responsible for making weekly backup databases by using SQL Server 2005 and restore these databases in different server.
• Gauged the effectiveness and efficiency of existing reporting systems.
• Developed drill down, drill through, linked, tabular, matrix and chart reports.
• Developed and implemented strategies for improving and further leveraging existing reports in order to transfer / convert to SQL Server Reporting Service.
• Administered interface to organize reports and data sources, schedule report execution and delivery, subscription of reports and track reporting history.
• Involved in installation, configuration, security, maintenance and restoration of SSRS on Windows Server 2003.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS-2005.

Environment: MS SQL Server, SSIS, SSRS, SQL Profiler, Management Studio, BIDS, Access.

Confidential

Jr. SQL Server DBA/Developer

Responsibilities:

• Involved in requirements gathering, analysis, design and development.
• Migrated data from SQL Server 7.0 to SQL Server 2000 successfully.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, User defined data types and Functions.
• Tuned SQL statements (Using Indexes) and Involved in tuning the database.
• Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Created Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Responsible for General Database Administration, Query Performance Tuning.
• Creating reports and hosting it in the web for the users.

Environment: SQL Server 2000, T-SQL, SQL Server 2000 Reporting Service, VSS, Windows 2000Server, Enterprise Manager, Query Analyzer, SQL Profiler.