SUMMARY

• Over 7+ years of Experience in IT domain focused on Microsoft SQL Server 2000/20 /2014 , SSIS/SSRS/SSAS, OLTP and OLAP.
• Expertise in Implementing and managing enterprise wide BI/ETL solutions in SQL Server /2012/2014.
• Excellent working skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS.
• Created database objects such as views, synonyms, Tables, Indexes, Sequences as well as custom packages tailored to business requirements.
• Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, cursors.
• Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, and Check, Unique etc.) and Generating Complex Transact SQL (T - SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.
• Writing T-SQL queries (DDL and DML). Creating SQL Scripts for data loads and Upgrades for data migrations and data validations.
• Experience in Performance Tuning and Query Optimization.
• Experience in generating reports using SQL Server Reporting Services, Crystal Reports, and MSExcel spreadsheets.
• Involved in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS 2000/20 /2013 , 2014 across various environments
• Experience in designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/2005/2008 ), use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting services.
• Expert in generating drill down reports, parameterized reports, linked reports, sub reports and filters, charts in SSRS 2005/2008.
• Experience in whole cycle of DTS/SQL server integration services (SSIS 2005/2008/2012/2013 ) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Experience in various Extracting, Transforming and Loading (ETL) tasks using SSIS including tools like BCP utility, DTS and SSIS ( ) Packages with proper control & data flow elements.
• Very good in creating and deploying SSIS (ETL process) packages using various Transformations such as Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Excellent in High Level Design of ETL DTS Packages &SSIS Packages for integrating data using OLE DB Connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Lookup, Conditional Split, Bulk Insert.
• Sound Experience and understanding of SSAS, OLAP Cubes, Slowly changing Dimensions, KPIs and Architecture.
• Knowledge on integration of BI suite of products (SSRS & SSAS) with Microsoft Office range of products like EXCEL 2007, PPS 2007.
• Experience in providing SSRS Security & Accessibility to various reports in multi-user environment.
• Excellent Analytical, Interpersonal and Communication skills, fast learner, hardworking and versatile team player.

TECHNICAL SKILLS

Operating Systems: Windows Server R2 / 2003, Windows 8.1 / 7 / Vista

Languages: T-SQL, C, C++, Java, C#, VB.Net, VB 6.0

Web Technologies: HTML, XML, SharePoint

Databases: MS SQL SERVER / / 7.0, MS Access 2003

Reporting Tools: SQL server Reporting Services (SSRS), Crystal Reports XI/10/9, BO

Analytical Tools: SQL server Analysis Service (SSAS), Performance Point Server 2007, OLAP

ETL Tools: Data Transformation Services (DTS), SQL Server Integration services (SSIS)

PROFESSIONAL EXPERIENCE

Sr. BI/SQL Developer

Confidential, Bridgewater, NJ

Responsibilities:

• Highly responsible for development and management of SSRS, SSAS and SSIS projects.
• Installation and configuration of SQL Server ReportingServices(SSRS)2005.
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Deployed SSRS Reports in SharePoint for web based access for multiple end users
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Extensively worked on Performance Point Server.
• Involved in the non DR team on Reporting Services.
• Created reports using stored procedures. Involved in scheduling, creating snapshots and subscriptions for the reports.(SSRS)(2005/2008).
• Designed OLAP cubes with star schema and multiple partitions using SSAS.
• Understanding theOLAPprocessing forchanging and maintaining the Warehouse,optimizing dimensions, hierarchiesand adding the aggregationsto the Cube.
• Formulated and documented the physical ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations and expressions.
• Created packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements.
• Developed and unit tested SSIS load processes for performance check
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measure groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Worked on slowly changed dimensions and performed partitioning of cubes as well as cube optimization in order to increase the performance of cubes.
• Served as technical expert guiding choices to implement analytical and reporting solutions for client.
• Provided various security standards and subscriptions to report server.
• Wrote complex T-SQL scripts, stored procedures, functions and triggers.
• Worked with the Project Analyst via peer reviews and code inspections to ensure code meets the business and system requirements
• Worked with other developers to ensure the code interdependencies are met and fully tested via a formal system test plan

Environment: Windows 2003 Adv. Server, SQL Enterprise Edition, SSRS, SSAS, SSIS, Performance Point Sever 2007, ProClarity Analytics, VB.Net, EXCEL2007, ORACLE 10g

Sr. BI/SQL Developer

Confidential, Houston, TX

Responsibilities:

• Worked with other report writers, and project teams to refine reporting requirements based on customer’s business needs
• Involved in Logical & Physical Data modeling
• Involved in writing stored procedures, Triggers, User-defined Functions, Views and Cursors for both OLTP and OLAP systems for various modules
• Did performance tuning of reporting data by optimizing indexes and stored procedures
• Worked on Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, and BULK INSERT etc. and used configuration files and environment variables for production deployment
• Created data loads and Upgrade scripts for data migrations and validations
• Involved in dimensional modeling with Star &Snowflake schemas and created the Data Source Views (DSV) and Cubes using the identified Fact and dimension tables.
• Involved in development & Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created different Parameterized Reports (SSRS 2000/2005/2008 ) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Report parameters included single valued parameters, multi-value parameters which also consisted of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Create ad-hoc SQL queries for customer reports and executive management reports
• Written MDX Scripts in order to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Created Reports, Report model Definitions, Scorecards, KPIs, and Dashboards utilizing Performance Point 2007/SharePoint Server
• While developing reports from Cubes also used the KPI’s for decision making, also implemented Cube Partitions and also debugged data connections, data sources and Data Source Views
• Scheduled reports to refresh and run on daily, weekly and monthly basis in the report manager and SharePoint.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Provided documentation about database/data warehouse structures and Updated functional specification and technical design documents.

Environment: MS SQL Server 2008/2005/2000 , VS2008/2005, SQL Server Reporting Services (SSRS 2008/2005), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), T-SQL, PL/SQL, MDX, Microsoft Office SharePoint Server (MOSS ) 2007, Performance Point Server 2007, Oracle 10g/9i, Visual Source Team Foundation Server (VSTS)

BI/SQL Developer (SSRS/SSIS/SSAS)

Confidential, Pittsburg, PA

Responsibilities:

• Gathered the requirements by discussing with the Users, business analysts and team members
• Studied existing OLTP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems
• Wrote complex stored procedures, queries, triggers, functions and cursors for the OLTP batch and online processes
• Created indexes, Constraints, and rules on database objects.
• Updated functional specification and technical design documents.
• Responsible for identifying and defining Data Source and Data Source views mappings for ETL
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes
• Migrated data from various data sources like Oracle, Flat files, upstream systems into Staging, ODS and DWH areas using DTS/SSIS.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Responsible for Dimensional modeling. Defined relationships between Dimensions and Measure groups.
• Created SSAS cubes and loaded dimensions and facts. Defined attribute properties in a Parent Child Dimensions.
• Created the data source views and defined granularity with in a measure group and drill through actions.
• Reviewed cubes, changed the cubes and documentation according to the requirement based on evaluation and revenue opportunities using SSAS.
• Created Reports, Scorecards, KPIs and Dashboards using Performance Point 2007/SharePoint
• Worked with installation, configuration and deployment of SQL Server Reporting Services (SSRS), developed various enterprise reports, drill thru reports, drill down reports and multi-valued parameter reports.
• Worked with SSRS 2008 Report Builder and allow customers build their reports using Report Builder
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Created and maintained Roles and Database users.
• Adhere to Change Control Procedures and Audit controls across all SDLC environments

Environment: MSSQL Server 2013/2012/ 2008/2005/2000 , VS2005, SQL Server Reporting Services (SSRS 2005), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), ETL, MDX, Microsoft Office SharePoint Server (MOSS ) 2007, Performance Point Server 2007, Oracle 10g, Toad, Visual Source Safe (VSS), .Net (Asp .Net, C# .Net)

SQL BI Developer

Confidential

Responsibilities:

• Highly involved in all phases of SDLC including Planning/Analysis/Design (30%), Development (50%) and Support (20%).
• Worked with business users to understand their business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
• Participate in evaluating and analyzing the relational database management systems, utilities and tools offered by BI applications/tools vendors.
• Designed and optimization of conceptual and logical dimensional data models for data marts to support reporting infrastructure.
• Utilized Analysis Services (SSAS) to design multi-dimensional models, including the construction of Data View, Fact and Dimension tables, and OLAP Cubes while adhering to enforced development methodologies.
• Developed parameterized reports through Reporting Services (SSRS) from a variety of data sources including Analysis Services Cubes and prepare for Web publishing.
• Created ad-hoc queries and reports as requested and provide on-going analytical support for these requests.
• Converted existing reporting tools to a standardized reporting infrastructure using SQL and Microsoft products.
• Generated reports with dynamic grouping and dynamic sorting as well as running values.
• Created complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins
• Maintained referential integrity and implemented complex business logic.
• Loading data from various data sources using MS Data Transformation Services (DTS).
• Created and tested DTS packages for importing and exporting data from data warehouse
• Highly involved with developer team on various aspects ranging from usage of utilities to SQL performance, test data and general trouble shooting.
• Wrote and integrated stored procedures to generate the special reports according to client’s need.
• Share knowledge with co-workers and ensures appropriate knowledge transfer to cover duties during illness, vacations,, etc.
• Provided on-call support for all BI projects for immediate problem resolution.

Environment: SQL Server, MS Office, MS SQL Server 2005, SSRS, SSAS, SSIS, DTS