SUMMARY

• Over 8 years of strong experience in Software Design, Development and Implementation of Business Intelligence Analytical/Reporting Platforms.
• Strong experience in Data Warehousing(star and snow flake schemas),, SQL Server Integration Services (SSIS),SQL Server Analysis Services (SSAS), Database SQL Server 2005, 2008, 2008R2, 2012 Oracle 10g/11g.
• Expert in modeling OLAP Structures using SSAS and follow MS Best Practices in defining Measure Groups, Cube Dimensions, Hierarchies and Relationships.
• Strong noledge in implementing SSAS Security, managing partitions and creating usage based aggregations in SSAS.
• Strong experience in writing MDX queries and defining Calculations, KPI’s and performing drill through/URL actions in SSAS.
• Configured Report Server using Reporting Services Configuration Manager and Created T - SQl, MDX Reports using SSRS 2005/2008/R2/2012.
• Experience in SSRS design and deployment of Parameterized, Drilldown,
• Drill through, Tablix, Snapshot, Cached, and Ad hoc Reports
• Experience in using Report Builder 3.0, Designing Report Models, Scheduling Reports and Building Charts, Sparklines, Indicators, Gauges and Geo Map Spatial Reports.
• Strong noledge working with ProClarity Desktop Pro, ProClarity Dashboard and ProClarity Web Analytics.
• Admin noledge in maintaining ProClarity Security, Roles and Permissions
• Extensively worked with SSIS packages and strong noledge in automating and scheduling ETL Jobs using SQL Agent and Windows Scheduler.
• Expertise in applying various transformations in SSIS including Conditional Split, Derived Column, Lookup, Multicast, Slowly Changing Dimension, Data Conversion, Merge and Sort.
• Experience working with Control Flow tasks in SSIS like Execute SQL, Execute Package, Data Flow, File System, Send Mail, AS Processing and Script task.
• Highly Proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Functions.
• Experienced in creating Tables, Views, Indexes, Replication, and other SQL joins and query writing.
• Expert in developing T-SQL (DDL, DML) statements, Data Integrity (Constraints), Rules, Performance Tuning, Query Optimization and Validation issues.
• Strong noledge in working with trace files and execution logs.
• Effectively manages time spent on multiple projects to meet deadlines.
• Team player and self-starter with excellent communication skills, ability to work independently or as a part of team and capable of picking up Confidential skills quickly.

TECHNICAL SKILLS

• MS SQL Server 2005/2008/2008R2/2012
• MS SQL Reporting Services
• MS SQL Server Analysis Services
• MS SQL Server Integration Service
• ProClarity Desktop Pro
• Sharepoint
• T-SQL
• PL/SQL
• Erwin
• Oracle 8i/10g/11g
• OBIEE BI Publisher
• Informatica
• HTML
• C#
• ASP.Net
• Java
• Cobol
• Windows 95/98/NT/2000/2003/XP.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

MS BI Developer

Responsibilities:

• Responsible for Analysis, Design, Development, Testing, Documentation and Implementation of Business Intelligence Analytical and Reporting Solutions, Scorecards and Dashboards.
• Worked with Subject Matter Expertise to refine the requirements and developed Technical Specification documents.
• Created OLAP Structures/Cubes, worked with various types of Dimensions, Hierarchies, Measure Groups, Relationships, MDX Calculations, Drill Thru/URL Actions using SSAS
• Implemented several Microsoft Best Practices while creating Cube Structures.
• Responsible for automating, processing all OLAP Catalogs
• Created security roles and applied object level security for accessing the cubes.
• Created Usage Based Aggregations and Partitions to improve the performance of the cubes.
• Created SSIS Packages and Procedures (supports Full and Incremental load) to load data from source to staging and to target warehouse tables, audit logs.
• Developed packages using various transformations in Data Flow like Aggregate, Lookup, Conditions Split, Union All, Derived Column, Merge, Sort, Multi Cast and from Control Flow like Execute SQL Task, Analysis Service Processing Task, Send Mai Task, For Loop Container, Sequence Container, Bulk Insert Task.
• Defined SQL Jobs to automate all the SSIS Packages using SQL Agent.
• Worked on all kind of report structures including Drill Down, Drill Thru, Parameterized, Cascading Parameterized and Matrix.
• Created several reports using Indicators, Sparklines, Gauges, Databars, Charts and integrated them into Dashboards.
• Generated reports using global variables, expressions, functions, stored procedures and cubes..
• Responsible for scheduling and subscribing, condition based subscribing the reports using report server.
• Monitored scheduled jobs and alerts. Improved Report Performance and performed unit testing.
• Worked on many complex Stored Procedures, Triggers, Functions, Indexes, Tables, Snapshot Tables, Views, Joins and Linked Servers.
• Responsible for maintaining Version Control using Tortoise SVN tool.
• Responsible for trouble shooting and resolving tickets raised in JIRA tool for the projects Perfect Order, Labor Management System Tools, Order Aging, Oversell Tool and Operations Visibility.

Environment: MS SQL Server 2012 Enterprise Edition, MS BIDS - Reporting Services, Analysis Services, Integration Services, Sharepoint, SQL Agent, SQL Profiler, T-SQL and Windows Server 2003.

Confidential, Sterling, VA

MS BI Developer

Responsibilities:

• Responsible for gathering/refining requirements from the customer for developing database structure, cube design and reporting.
• Created Logical and Physical data models for the warehouse using ERWIN data modeling tool.
• Created OLAP Structures/Cubes, worked with various types of Dimensions, Hierarchies, Measure Groups, Relationships and Calculations using SSAS
• Created drill thru actions, cube cell actions and called .net assemblies inside the cube.
• Created aggregations using Aggregation Wizards and increased performance of the cube.
• Implemented Data Mining models using mining algorithms for Parts Prediction and Forecasting.
• Worked with DBAs in providing OLAP Server Load Balancing architecture to provide 24*7 Report access to users
• Created several SSIS packages to load from source to target warehouse tables. Used export and import wizard to load reference tables in the database.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Implemented SSIS packages to support Slowly Changing Dimensions Type I, Type II and Type III loading.
• Automated SSIS packages using SQL Agent.
• Configured Report Server and defined Report Server virtual directory and Report Manager virtual directory, database setup and email settings using Reporting Services Configuration Manager.
• Using SSRS, created various types of Drill Down, Drill Thru, Cascading Parametrized Reports.
• Worked on ProClarity Desktop Professional, Dashboard and Web.
• Responsible for resolving ProClarity Issues and Admin support and maintenance of ProClarity Permissions and Security.
• Worked on many complex Stored Procedures, Triggers, Functions, Indexes, Tables, Snapshot Tables, Views, Joins and Linked Servers.
• Implemented Change Data Capture (CDC) mechanism and Table Compression.
• Responsible for maintaining Version Control (Tortise SVN) of DB Objects.
• Worked with users to provide noledge on cube browsing and extracting cube data on spreadsheets.

Environment: MS SQL Server 2008/2008R2 Enterprise Edition, MS BIDS - Reporting Services, Analysis Services, Integration Services, ProClarity Desktop Pro, ProClarity Dashboard, ProClarity Web, SQL Agent, SQL Profiler, T-SQL, PL/SQL and Windows Server 2003.

Confidential, Long Island, NY

MS BI Developer

Responsibilities:

• Closely interacted with subject matter experts in understanding the business process methodology.
• Actively participated in all phases of project Life Cycle.
• Working hands on design, development & promotion of OLAP Cubes into QA and Prod environments.
• Created Dimensions, Hierarchies, Measure Groups and implemented Many to Many Relationships using SSAS.
• Implemented Calculations using MDX, KPIs, Drill Thru Actions, Partitions and Aggregations using SSAS.
• Created Roles and provided permissions in OLAP catalogs and maintained security.
• Created various types of reports and charts using SSRS.
• Identified and worked with Parameters for parameterized Reports in SSRS.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Looked at the reports and fixed bugs in Stored Procedures.
• Created SSIS Packages using various transformation Derived Columns, Condition Split, Execute SQL Task, Data Flow Task, Bulk Insert, Send email and FTP Task.
• Responsible for deploying SSIS packages from multiple environments, importing and exporting from server to file system.
• Applied various transformations in SSIS including Conditional Split, Derived Column, Lookup, Multicast, Slowly Changing Dimension, Data Conversion, Merge and Sort.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Managed index, statistics and optimizing queries by using execution plan for tuning the database.
• Maintained the physical database by monitoring performance, integrity and Optimize SQL queries for maximum efficiency using SQL Profiler.
• Monitored Scheduled jobs and Alerts and Involved in Production Support.
• Responsible for production migration, post migration testing and issue resolution.
• Worked with users in training and support
• Actively participating in enhancement meetings focused at making the application more reliable and also responsible for submitting daily report status
• Communicating with both technical and non-technical staff to support analysis, design, testing, and troubleshooting of project issues

Environment: MS SQL Server 2005/2008 Enterprise Edition, MS SQL Server Reporting Services 2005/2008, MS SQL Analysis Services 2005/2008, Report Builder, Sharepoint, SQL Profiler, SQL Agent, T-SQL, PL/SQL, Windows Server 2003.

Confidential, Portsmouth, NH

MS SQL Server Developer/ BI Developer

Responsibilities:

• Worked with Business Analysts, SMEs and participated in requirement gathering and documented them.
• Created Technical Design documents for user requirements.
• Involved in creating SSAS Projects using MS SQL Server 2005 BIDS.
• Created Data Source Connections, Data Source Views, Logical/Physical Relationships and Named Queries using SSAS.
• Defined relationships between measure groups and dimensions using SSAS.
• Developed Role Playing Dimensions, Junk Dimensions, Conformed Dimensions, Factless Facts, Measures, Partitions & Roles in SSAS.
• Defined Granularity within a measure group and Drill Thru and Report Actions.
• Implemented calculations to Aggregate physical Measures.
• Responsible for Process Database Objects Security Role.
• Created SSIS packages and performed data mapping and transferred data from staging tables to database tables using SSIS transformations.
• Developed the SSIS packages and controlled their order of execution using the precedence constraints and expressions as and when needed.
• Automated ETL and scheduled ETL jobs using SQL Agent
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Created Database Objects - Tables, Indexes, Views, User defined Functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Responsible for writing T-SQL code for creating Cursor and handling the data Validations.
• Designed and implemented Parameterizedand Cascading Parameterized reports using SSRS.
• Created reports and Charts using Tables and Cubes in SSRS.
• Configured Report Server and Deployed User Reports into Report Manager using SSRS.
• Used SQL Profiler and Query Analyzer to optimize SSIS package queries and Stored Procedures.
• Developed complex T-SQL code for the application.
• Transformed the complex business logic and calculations into coding.
• Involved in Production Support and Documentation.

Environment: SQL Server 2005 Enterprise Edition, MS SQL Server 2005, MS Analysis Services 2005, MS Reporting Services 2005, MS Integration Services 2005, Import & Export Data, SQL Agent, T-SQL, PL/SQL, XML, Windows XP

Confidential, Charlotte, NC

MS SQL Server Developer

Responsibilities:

• Worked as a developer on MS SQL Server 2005 and Oracle databases (using T-SQL, scripts, stored procedures and views).
• Created Logical and Physical data models using ERWIN data modeling tool.
• Looked at the reports and fixed bugs in Stored Procedures, Tables and Triggers.
• Worked as a developer in creating complex Stored Procedures, Functions, DTS packages, Triggers, Cursors, Tables, Views, Indexes and other SQL joins and statements for applications.
• Worked on MS SQL Server tasks such as data loading, BCP, Instances and Indexes.
• Implemented Constraints, Rules, Defaults, User defined data types and Indexes on tables.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of TSQL queries and Stored Procedures. Optimized query performance by creating indexes
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Resolved deadlocks issues with the Databases/Servers on a real-time basis.
• Used database maintenance plans for backing up the database and transaction log files.
• Managed and monitored the System Utilization.
• Worked in Enterprise Manager for job scheduling and batch queries.
• Involved in Production Support and Documentation.

Environment: SQL Server 2005 Enterprise Edition, SSIS, T-SQL, PL/SQL, Query Analyzer, BCP, SQL Profiler, Erwin, Import & Export Data, Windows 2000 Server.