SUMMARY

• 8 years of IT experience in software development, designing and implementation with major focus around Business Intelligence, Data Warehousing and Database Applications involves ETL, Reporting and Data modelling experience.
• Over 6 years of experience with Business Intelligence tools in Microsoft Suite such as SSIS /SSRS/SSAS services using databases SQL SERVER 2012/2008 R2/2005, Oracle
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Proficiency in creating different types of reports such as Table format and Matrix format, Cross - Tab, Drill-down, Drill-through, Parameterized reports, Snapshot reports, Linked reports, OLAP and Sub reports, and formatting them using both SSRS 2012/2008 R2.
• Creation of Report subscription in SSRS 2012/2008 R2.
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurs in execution
• Responsible for the design and development of reports and SQL queries that pulls data from multiple SQL Server databases.
• Developed Business Intelligence solutions such as Executive Dashboards and Business Scorecards using SSRS.
• Proficient in creating ETL packages using SQL Server 2008 R2 and SQL Server 2012 Integration Services (SSIS).
• Migrated data from various data sources using SSIS Transformations like OLE DB Source, Excel source, Aggregate, Lookup, Conditional-split, Merge Join and Sort.
• Adding the SSIS transformations that meet the business requirements of the package
• Extensive experience in T-SQL to write: stored procedures, triggers, user defined functions, tables, views, cursors, indexes and relational database models.
• Good knowledge of Data Marts, Data warehousing, OLAP, OLTP, Dimensional Data Modelling, Star Schema Modelling, Snow-Flake Modelling, FACT and Dimensions Tables.
• Knowledge in building Multidimensional Expression (MDX) queries for Analysis Services & Reporting Services.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables
• Created data sources, connection strings and defined the datasets for generating the report.
• Experience in database performance tuning and query optimization, data integrity and statistics.
• Knowledge of Software Development Life Cycle (SDLC).
• Excellent understanding of Data Warehousing Concepts in Pharma Sales and Marketing domain
• Extensive experience in Defect Tracking and Reporting tools using Trillium, SSRS and SSAS.
• Extensive experience in test planning, writing test specifications and test execution
• Worked extensively on testing tools like Quality Centre, and other technologies like Netezza, Informatica, Shell scripting and PL/SQL
• Have good knowledge of Data Warehousing Concepts and have working exposer of reporting tool.
• Good understanding of Pharmaceutical business processes and data.
• Strong communication, organizational and interpersonal competencies along with detail-oriented and problem solving skills in the technology arena. Experienced working with flexible schedule to accommodate global business users across time zones.

TECHNICAL SKILLS

Operating Systems: Windows-2000/2003/XP

Languages: Java, C++, C,MDX, SQL,T-SQL,PL/SQL

Web Technologies: Java Script, HTML, ASP

Databases: SQL Server 2012/2008 R2/2005, ORACLE 8i, MS-Access

Data Visualisation: Tableau

SQL Server Tools: BI Development Studio, SSIS, SSRS, SSAS

Data Quality Tools: Trillium

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis,IN

Sr. BI Developer/Data Analyst

Responsibilities:

• Involved in the requirements gathering and analysis.
• Created and deployed SSIS packages using various transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Designed the Data model and Load strategy to get data from different systems.
• Exploring and executing SSIS packages in Business Intelligence Development Studio (BIDS).
• Configured and maintained Report Manager and Report Server for SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Creation of SSRS Subscription and Snapshot reports.
• Created Tableau Dashboards with interactive views, trends and drill downs.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Perform performance testing for the main business areas.
• Trillium Tool to test Quality Checks.
• Assist Test lead to create test plan and strategy for the tasks to mitigate the risks to system quality.
• Create Test Scenarios, Test Cases and expected results for module and system testing
• Review the Test Cases and documents prepared by other team members
• Logging of defects and tracking them till resolution.
• Prepare the validation document like test summary and test process approach document.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query.
• Responsible for creating fact and dimension tables, build cubes using SSAS.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Created indexes, constraints and rules on database objects.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.
• Experienced in making technical specifications report by gathering information from end user.

Environment: Windows XP Professional, SQL Server 2008 R2, SQL Server 2012, Business intelligence Studio.

Confidential, Indianapolis, IN

BI Developer/Data Analyst

Responsibilities:

• Involved in creating tables and their relationships in the data warehouse.
• Assisted in the design of star schema and snow flake schema.
• Created Technical Report Requirement document for the Standard Reports.
• Developed large number of standard and customized reports usingSSRSfor data feeds and for Reports on server.
• DevelopedDynamic Report Enginefor creating the customized reports inSSRS.
• Involved in creatingStored Procedures and views..
• Involved in Creating and Testing theSSISpackages developed for security.
• Creation of SSRS Subscription and Snapshot reports.
• Used SQL Server Agent for scheduling jobs and alerts
• Active part in creating OLAP and ROLAP cubes and used MDX queries to retrieve data from the cubes.
• Used various transformation tasks to create ETL packages for data conversion.
• Involved in creatingSSISpackages to migrate large amounts of data.
• Involved in usingSSASdata sources inSSRSreports.
• CreatedDatabases,Tables,Cluster/Non-Cluster Index,Unique/Check Constraints,Views, Stored Procedures, Triggers.
• Involved inperformance tuningof queries for query efficiency.

Environment: Windows XP Professional, SQL Server 2008 R2, SQL Server 2012, Business intelligence Studio.

Confidential

BI Developer

Responsibilities:

• Interact with the business integrators on a regular basis in order to understand the new requirements.
• Transformed the data using different transformations like Aggregate, split, join, merge, fuzzy lookup of SQL Server Integration Services (SSIS).
• Configured and maintained Report Manager and Report Server for SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Design Dashboards using Filters, Parameters and Action Filters using Tableau.
• Perform performance testing for the main business areas.
• Trillium Tool to test Quality Checks.
• Assist Test lead to create test plan and strategy for the tasks to mitigate the risks to system quality.
• Create Test Scenarios, Test Cases and expected results for module and system testing
• Review the Test Cases and documents prepared by other team members
• Logging of defects and tracking them till resolution.
• Prepare the validation document like test summary and test process approach document.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query.
• Responsible for creating fact and dimension tables, build cubes using SSAS.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Created indexes, constraints and rules on database objects.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.
• Experienced in making technical specifications report by gathering information from end user.

Environment: Windows XP Professional, SQL Server 2008 R2, SQL Reporting, Business intelligence Studio.

Confidential

Developer

Responsibilities:

• Active Interaction with clients to understand business requirements.
• Configured and maintained Report Manager and Report Server for SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Perform performance testing for the main business areas.
• Trillium Tool to test Quality Checks.
• Assist Test lead to create test plan and strategy for the tasks to mitigate the risks to system quality.
• Create Test Scenarios, Test Cases and expected results for module and system testing
• Review the Test Cases and documents prepared by other team members
• Logging of defects and tracking them till resolution.
• Prepare the validation document like test summary and test process approach document.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query.

Environment: Windows XP Professional, MicrosoftSQLServer2005, SQL Reporting, MS SSAS 2005 Business intelligence Studio, HTML, Microsoft Visio 2000, Microsoft Visual SourceSafe-SQL.

Confidential

Developer

Responsibilities:

• Active Interaction with clients to understand business requirements.
• Configured and maintained Report Manager and Report Server for SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Perform performance testing for the main business areas.
• Trillium Tool to test Quality Checks.
• Assist Test lead to create test plan and strategy for the tasks to mitigate the risks to system quality.
• Create Test Scenarios, Test Cases and expected results for module and system testing
• Review the Test Cases and documents prepared by other team members
• Logging of defects and tracking them till resolution.
• Prepare the validation document like test summary and test process approach document.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query.

Environment: Windows XP Professional, MicrosoftSQLServer2005, SQL Reporting, MS SSAS 2005 Business intelligence Studio, HTML, Microsoft Visio 2000, Microsoft Visual SourceSafe-SQL.

Confidential

Developer

Responsibilities:

• Active Interaction with clients to understand business requirements.
• Configured and maintained Report Manager and Report Server for SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Perform performance testing for the main business areas.
• Logging of defects and tracking them till resolution.

Environment: Windows XP Professional, MicrosoftSQLServer2005, SQL Reporting, HTML, Microsoft Visio 2000, Microsoft Visual SourceSafeT-SQL.