SUMMARY:

• Over 8 years extensive experience in Business Intelligence Solutions and Technical Support in Pharmaceuticals, Insurance, Telecommunications, Financial, Manufacturing, and Education Domain
• Expertise in MS SQL Server Management Studio 2005/2008/2008 R2/2012/2014 and MS SQL Server BI suite ( SSIS, SSAS, SSRS and Power BI)
• Expertise in Informatica Power Center ETL Tools.
• Expertise in IBM Cognos Business Intelligence tools like Report Studio, Framework Manager, Query Studio and Analysis Studio
• Expertise on Tableau 9.0
• Experience in database programming in writing T - SQL Stored procedures, views, parameters, functions, constraints and indexes using various DDL and DML commands.
• Experience in writing complex T-SQL queries, sub-queries and complex joins.
• Experienced in Data Extraction, transformation and loading (ETL) between different systems and formats such as MS Access, Excel Spreadsheet, flat files etc. Expert in creating, configuring and fine-tuning ETL workflows designed in SSIS.
• Experienced in creating SSIS packages using various transformation like lookup, derived columns, conditional split, merge join, sort, aggregate, union.
• Expertise in OLTP/OLAP System Study, developing database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Experienced in generating reports using SQL Server Reporting Services (drill-down drill through, cascading parameters, sub - reports) and MS Excel Spreadsheets (functions, subtotal, and pivot tables)
• Experience in creating Ad-hoc reports, data driven subscription reports by using Dashboards, parameters, queries, and reports in SSRS Report Builder, Developed data-driven subscription to end-users.
• Experience in Microsoft Power BI Tools such as Power Pivot, Power Map and Dashboards. Skilled in SharePoint to create secure environment for file sharing, collaborating and document management.
• Worked with end users/customers to understand their business/marketing requirements, recommended technical and business solutions and documented functional requirements.
• Good Communication and Interpersonal Skills, resulting in excellent rapport with employees and executive management as well as being a quick learner and having the flexibility to adapt to any surrounding.

TECHNICAL SKILLS:

• Microsoft SQL Server 2005/2008/2008 /2012/2014
• SQL Server Management Studio (SSMS)
• SQL Server Business Intelligence Development Studio(BIDS)
• SQL Server Analysis Services (SSAS)
• SQL Server Integration Services (SSIS)
• SQL Server Reporting Services (SSRS)
• MS-Excel
• SQL
• T-SQL
• HTML
• XML
• Visual Studio 2005/2008
• Cognos Reports Studio
• SQL Profiler
• MS Visio
• Informatica Power Center Designer
• IBM Cognos Reporting 10/11
• Clinical Trial Management System (CTMS)
• Electronic Data Capture (EDC) .

PROFESSIONAL EXPERIENCE:

Confidential

IBM Cognos Report Developer

• Involved in creating an ad-hoc query model for query studio users. Created and published various packages to meet different requirements.
• Created different types of reports like List, Cross-tab, Chart, Drill-Thru and Master-Detail Reports.
• Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and also worked on the customization of prompt parameters in Report Studio.
• Involved in extensive use of conditional formatting while developing reports in Report Studio.
• Developed Prompt Pages and Conditional Variables, Creating Query Prompts, Calculations, Conditions & Filters in Report Net.
• Evaluated Report Performance upon completion of the reports and validated output data.
• Created complex reports based on business user requirements.
• Deployed the final product and set the report output requirements. Attended User Acceptance sessions, and worked on the feedback from the business users.

Confidential, New York, NY

Microsoft SQL BI Developer

• Designed ER diagrams and mapped the data into database objects involved in Normalization of the Database in OLTP
• Extracted and transformed raw data from a variety of data sources into relevant information to enable more effective management and operational insights using SSIS 2008R2
• Created the mappings using transformations such as derived Column, Pivot and Conditional Split
• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application
• Developed Physical data models and created DML scripts to create database schema and database objects
• Development of custom scripts and stored procedures for data import and manipulation
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Developed various operational Drill-through and Drill-down reports using SSRS
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports
• Used cascaded parameters to generate a report from two different Data Sets.
• Developed Reports for business end users using Report Builder with updating Statistics.
• Database and Log Backups and Scheduling Backups by creating and deploying SSIS packages.
• Generated report models for insurance members profile to take on complex business reporting requirements regarding member billing and CMS bundle payment initiative conformation using SSRS 2008R2.
• Monitoring SQL Server logs to ensure the backup operations, batch commands and processes have completed successfully
• Used multiple join statements to retrieve data from multiple tables and constructed Cubes based on data volumes mostly adhering to Star Schema

Confidential

Business Intelligence Analyst Associate III

• Extracted data from Excel worksheets into SQL Server Management studio 2005 using SQL queries such as Constraints and Joins to designated databases.
• Employed the use of performance tuning to optimize SQL queries using queries.
• Created different types of reports including Parameterized, Matrix, Hyperlink as well as Gauge reports
• Created stored procedures, functions, views and triggers using the SQL Server Management Studio 2005.
• Deliver ad hoc data and report requests, analyze data needs for both users and projects, investigate and analyze data discrepancies .
• Developed physical data models and created DDL scripts to create database schema and database objects
• Designed & developed the reports using Cognos 8 Report Studio, Query Studio, Analysis Studio reports.
• Worked as an administrator on Cognos suit of products.
• Design & development of multiple reports using various templates like list reports, cross-tab reports and chart reports.
• Involved in working with cubes and developed various dashboard reports.
• Extensively worked on Analysis Studio to develop multi dimensional reporting.
• Developed Standard Reports, Charts, Drill Through Reports, Master Detail Reports, Map Reports Using Report Studio and Query Studio.
• Created complex dashboards with pie charts, crosstab and Multi prompts in Report Studio.
• Developed various reports using functionalities like Render Variables, Conditional Blocking, Cascading Prompts, and Conditional Formatting.
• Involved in design, development and maintenance of database for Data warehouse project.
• Involved in Business Users Meetings to understand their requirements.
• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration with Informatica
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems.
• Worked extensively with the connected lookup Transformations using dynamic cache.
• Worked with complex mappings having an average of 15 transformations.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once
• Monitored Workflows and Sessions using Workflow Monitor.

Confidential

Business Intelligence Developer

• The project aims at integrating data in Integrating Services 2008 and generate parameterize reports of the customers.
• Involved in gathering the user requirements.
• Created stored procedures, triggers, Joins, functions and views.
• Created SQL server Reports using SSRS 2008
• Created Cross-Tab, Drill-down, Drill-down and Sub-Report using and linked reports using SQL SERVER Reporting Services.
• Identified the data source and defining them to build the data source views.
• Debugging reports and deploying reports.
• Involved in SSRS report deployment and report server configuration.
• Developed various types of reports like drill down, matrix, cross tab, ad hoc, Parameterized and cascading parameterized reports using SSRS.
• Created SSIS Packages to import and export data from Excel Spreadsheets, Text files and CSV files.
• Launching the report builder for Ad hoc reports
• Scheduled the Reports to run on daily and weekly basis in Report Manager and emailing them to director and analysts to be reviewed in Excel Sheet
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurring during execution
• Created SSIS packages to migrate data from Oracle DB to SQL Server 2008.
• Data migration (Import & Export using BCP) from text to SQL Server 2008.
• Involved in database backup, recovery procedures
• Analyzed the existing application programs and tuned SQL queries using Execution plan, Query Analyzer, SQL Profiler and database Engine tuning Advisor