PROFESSIONAL SUMMARY:

• 6+ years of extensive experience and hands on working knowledge in various domains of IT industry like financial, office supplies, and insurance as SQL/MSBI Programmer.
• Hands on experience in MS SQL Server with Business Intelligence in SQL Server Integration Services, SQL Server Analysis Services and SQL Server Reporting Services.
• Experienced in Extraction, Transformation and Loading (ETL) process using MS - SSIS application tools.
• Expert knowledge in SQL Server Package Configuration technique to make Dynamic configurations for SSIS packages.
• Experience in creating custom specific and efficient SQL server Reports using SSRS.
• Extensive experience in creating SQL Reporting Services (SSRS) and SSIS Infrastructure that pulls data from data sources and provides a simple to use reporting environment.
• Excellent understanding of T-SQL (DDL and DML), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server.
• Denodo development experience, building solutions using Denodo, Denodo performance tuning.
• Good communication and team management skills.
• Worked with the QA and Project Managers to set and evaluate milestone criteria to ensure released products/deliverables are on schedule with high quality.
• Record, report, and track defects to accurately depict the status of the system - including conducting defect/triage meetings, daily testing status reports and acting as a single point of contact for defect tracking issues and updates.
• Worked closely with Project Management and Development staff toward the reporting and resolution of errors.
• Demonstrated great strengths in Testing and Debugging applications, Documentation, quick learning, meeting project deadlines and delivering complex solutions qualitatively.
• Strong analytical, communication and leadership skills with emphasis on allocating tasks to other team members, coordinating with different groups and customers, maintaining team spirit and delivering Quality work.
• Experience in documentation, actively participated in team building and involved in many operations for maintaining healthy work environment, excellent Communication and interpersonal skills.

TECHNICAL SKILLS:

Languages: SQL, T- SQL, HTML, XML, C#.NET

Databases: SQL Server, MS Access

Analysis/Reporting Tools: SQL Server Reporting Service (SSRS)SQL Server Analysis Service (SSAS), Denodo

ETL Tools: SSIS(SQL Server Integration Services), Import Export Data

Other Software: MS Office- 2010/2007/2003

Operating Systems: Windows 98/2000/2003/ XP/7

PROFESSIONAL EXPERIENCE:

Confidential, CA

SQL Server /Denodo Testing

• Installed and configured Denodo server and Client.
• Established connections to various data-sources like Oracle, MYSQL.
• Created custom Denodo views by joining multiple data sources by joining tables from multiple data-sources.
• Written manual test cases to test Denodo flows.
• Using Denodo implemented BI reporting solutions across various databases and excel spreadsheets.
• Responsible for conducting manual exploratory testing under the guidelines of senior testing staff.
• Prepare and execute manual Test Scripts for testing of the application.
• Performed the tasks of assisting agile tester in conducting test plans and test cases.
• Testing of the application and reporting the defects in Jira.
• Handle the tasks of identifying testing problem areas and conduct root-cause analysis of software issues.
• Assigned responsibilities of developing production and testing environment of agile software.
• Perform the tasks of preparing test cases and test reports as well as ensure that the testing phase meets quality standard.
• Interacted with Business Analyst and Software Developers for bug reviews and participated in QA meetings.
• Interacted with Business Analyst and Developers in requirement analysis, design reviews, testing and documentation for application developed in Agile environment.

Environment: SQL Server, Denodo Platform, Agile Testing.

Confidential, DC

SQL Server Developer/SSIS/SSRS.

• Wrote several SQL Scripts such as finding tables that have Identity Columns, finding tables that do not have primary key to streamline the process of replication.
• Participated in Creating tables, indexes and designing constraints. Created Backend validations using Insert/ Update and Delete triggers. Created views for generating reports.
• Configured the SSIS Packages using Environment Variables for Dynamic Selection of Development and Production Environment.
• Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers.
• Utilized Integration Services (SSIS) to produce a Data Mapping and Data Mart for reporting, worked with Multi-Threading Concepts and Synchronous and Asynchronous transactions
• Developed, monitored and deployed SSIS packages by exporting data from DB2 Databases.
• Created SSIS Packages for Incremental Loading and slowly changing dimensions.
• Created a SQL Reporting Services (SSRS) and SSIS Infrastructure that pulls data from data sources and provides a simple to use reporting environment.
• Created SSRS reports using Report Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Designed and developed Drill down and Drill Through reports with Drop down parameters.
• Used SSRS Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report Server.

Environment: SQL Server, SQL Server Business Intelligence Development Studio (SSIS, SSRS)

Confidential, Sunrise, FL

SQL BI Developer (SSIS & SSRS)

• Interacted with business analysts and users to discuss the requirements for development
• Developed functional and technical specification document to assist in the design, development and/or maintenance of deliverables
• Created T-SQL queries for schemas, views, stored procedures, triggers and functions to migrate data from staging to production environment
• Modified existing stored procedures, functions using joins following SQL Standards to enhance the performance of the reports.
• Created SSIS Packages using Pivot Transformation, Execute SQL Task, Data Flow task etc. to import the data into data ware house
• Implemented Logging and Error handling in SSIS packages
• Analyzed execution plan and optimized some complex queries by creating indexes and using some SQL best practices
• Created Parameterized, Cascaded parameter Reports using SSRS
• Created dashboard SSRS reports under report server projects and published SSRS reports to the reports server.
• Experienced in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008
• Developed, scheduled and generated various reports like List, Matrix, Drill-Down, Chart and Sub report and standardize company report by implementing SQL Server Reporting Services (SSRS)
• Installed, authored, and managed reports using SQL Server 2008 Reporting Services.

Environment: SQL Server, SQL Server Business Intelligence Development Studio (SSIS, SSRS), .Net framework.

Confidential, Wilmington, DE

SQL BI Developer/SSIS/SSRS/SSAS

• Created complex Stored Procedures, triggers, tables, views and other SQL joins and statements for applications.
• Responsible for transformation and loading into the target SQL Server databases using ETL tools, DTS and SSIS.
• Created SSIS packages with which data resources such as Flat files, Excel files, were loaded daily in order to create and maintain a centralized data warehouse.
• Transferred/Rewrote DTS packages to SSIS Packages. Hands on working experience with configuring every aspects of SSIS.
• Created alerts, notifications, and emails for scheduled SSIS packages execution.
• Coordinated other Reporting Analysts in analyzing data and creating management reports.
• Assisted internal and external report needs and designed solutions based on specific requirements using SQL Server Reporting Service (SSRS).
• Developed reports without formal specifications often.
• Created and developed the stored procedures, triggers, views, and user-defined functions to support application development.
• Worked closely with IT project managers, programmers, and testers.

Environment: SQL Server, Microsoft Reporting Service, SQL server BI development studio

Confidential

SQL DEVELOPER

• Created and managed schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Generated T-SQL scripts for application development.
• Created Stored Procedures and User Defined functions.
• Created Indexes to speed up the queries.
• Participated in re-design and development of back-end SQL Server database, wrote queries, triggers and stored procedure.
• Scheduled Jobs and Alerts using SQL Server Agent.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.

Environment: SQL Server, SQL Server Query Analyzer, T-SQL, Windows 2003/XP