SUMMARY

• A Microsoft Certified BI Professional with around 8+ years of strong experience in the IT industry, with Microsoft SQL Server 2000/2005/2008 R2/2012, SSIS/SSRS/SSAS for both OLTP and OLAP (Data warehousing) environments.
• Good knowledge of Data warehousing, Bottom - Up and Top-Down Design methodologies, Operational Data Store (ODS), OLAP, Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using Analysis Services.
• Experience in BI Suite for ETL Development DTS/SSIS, Reporting (SSRS) and Analysis SSAS, Performance Point Server, MOSS and Dashboard reporting.
• Experience in designing Database Models using MS Visio and ER-Win for both Relational and dimensional modeling.
• Experience in Developing and Extending SSAS OLAP Cubes, Dimensions, KPIs and Report Action and Deploying and Processing SSAS objects.
• Knowledge in writing MDX for the Reports that uses OLAP Cubes.
• Strong experience in database programming in writing T-SQL Stored procedures, Triggers, Constraints, Indexes and Batch Scripts using various DDL and DML commands.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in conversion of packages from legacy systems (DTS to SSIS) and migrating, deploying the packages across Dev/QA/UAT/Prod environments.
• Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, DMV’s, DMFs and Query Execution Plans.
• Involved in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services across various environments.
• Involved in huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Involved in configuring SSRS Reports in SharePoint Integration mode.
• Expertise in generating reports using SQL Server Reporting Services and MS Excel spreadsheets.
• Created various SSRS reports involving variety of features like Reports, Maps, Charts, Sub-Reports, Linked Reports, Drill-Down, Drill-Through, Multi-valued parameters.
• Experience in administrative tasks such as data loading, batch jobs, data unloading, Backup, Recovery and scheduling the backups.
• Experience in Database administration activities for DB Security (creating users, roles, assigning permission to them and resolving deadlocks).
• Leverages good database design understanding and capable to optimize development efforts in a distributed environment and also possesses a good understanding of programming languages, development tools.
• Good working knowledge of application development and analysis. Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
• Excellent analytical/communication skills, Team Play and very much result Oriented.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, SQL Server BIDS

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

Operating Systems: Windows 2000/2003/XP/VISTA/WIN 7/WIN 8 Servers Windows NT/ 2000/2003/2008/2012

Databases: MS-SQL Server 2012/2008R 2/2008/2005/2000 , MS-AccessOracle 10g/11i,IBM DB2

ETL Tools: Data Transformation Services, SQL Server Integration Services (SSIS) 2012/2008R 2/2008/2005/2000

Reporting Tools: SQL Server Reporting Services 2012/2008R2/2008/2005, Report Builder, Crystal Reports

OLAP Tools: SQL Server Analysis Services 2012/2008R2/2008/2005

Data Modeling Tools: Visio, Erwin

Scripting Language: PowerShell

PROFESSIONAL EXPERIENCE

Confidential, Baton Rouge LA

Sr. MS SQL BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Created technical designs and user documentation.
• Converted complex Oracle PL/SQL packages, functions, procedures to SQL Server 2012(T-SQL).
• On a Regular basis created Store Procedures, Indexes, Views, User defined Functions, Constraints etc. on a daily basis for the reporting and query optimization.
• Configured, Installed and Administered Reporting Services 2012.
• Converted 100+ reports from Business Objects, Oracle Report Builder and Crystal Reports to SSRS 2012.
• Creating complex ad-hoc Reports, Sub Reports, Linked Reports, Drill through, and Drill down Reports.
• Integrated reports to the Application.
• Designed custom Report Templates.
• Provided Ad-hoc queries and Reports for users to create their own reports.
• Involved in Dimensional modeling by identifying the fact and dimension tables and design star schemas for the SQL Server Analysis services.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Defined relationships between Measure groups and Dimensions.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Responsible for the analysis, design, development, testing and maintenance of ETL solutions.
• Designed Complex Packages with Error Handling and Package Logging that stores the Logging results in SQL table and file files.
• Experience in configuring and deploying SSRS reports on to Microsoft Office SharePoint Server 2010.
• Responsible for creating the reports based on the requirements using SSRS 2008.
• Generated reports from the cubes by connecting to Analysis server from SSRS.
• Created parameters for these cube reports using MDX.
• Created a whole brand new set up for Canada Finance department. This includes moving all the databases, its objects, SSRS reports and cubes.
• Created and modified existing schema objects like tables, views and stored procs
• Followed agile methodology and coordinated daily scrum meetings.

Environment: SQL Server 2012, Windows Server 2008R2, T-SQL, PL/SQL, SSIS, SSRS, SSAS, SAP Business Objects, Oracle Report Builder, Crystal Reports, Oracle

Confidential, Westchester IL

Sr. SQL Server BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Work closely with management and end-users to create and evaluate business requirements.
• Used DTS/SSIS for ETL processes, SSRS for Reporting needs and SSAS for Analytical reporting.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse using SSIS.
• Involved in migration and conversion of Reports from Business Objects to SSRS 2008R2.
• Creating, Editing and Managing Report Models for Reporting Services.
• Involved in Creating Complex ad-hoc Reports, Sub Reports, Charts, Drill through and Drill down Reports.
• Experience in writing expressions in SSRS and expert in fine tuning the reports.
• Integrated SQL Server Reporting Services with Microsoft Office Share Point Server (MOSS) 2010.
• Analyzedreportsand fixed bugs in stored procedures and data table.
• Designed & created OLAP Cubes with star schema using SSAS 2008 R2.
• Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server 2008 Analysis Services (SSAS).
• Created and deployed analytics reports on to RoamBI.
• Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Experience inError handlinganddebuggingcoding issues andtroubleshootproduction problems.
• Monitoring nightly ETL process from various highly disparate source systems. Sources included SQL based databases and XML Files.Also ensured that nightly backup jobs or cube processing or other ETL jobs didn’t interfere with each other. Managed SQL 2005 and 2008 R2 databases and nightly SSIS Processes.
• Monitoring the scheduled SSRS and Business Objects reports. Re-running the reports in case of any failures or data mismatches.
• Deploying reports and dashboards to SharePoint 2010.
• Managed security and user access Analysis Services cubes using creation of Groups and Roles by creating of windows AD and also Perspectives within the OLAP cube.
• Security and user access Administration in SharePoint BI center.
• Deploying the changes to QA, Staging and UAT Environment’s.
• Involved in Product Releases.

Environment: SQL Server 2012/2008R2, Windows Server 2003/2008R2, T-SQL, SSIS, SSRS, SSAS, SAP Business Objects, Share Point 2010, BIDS, RoamBI, Reports Builder

Confidential, Chicago, IL

SQL DEVELOPER

Responsibilities:

• Use to get the user requirements from the Business Analyst.
• Designed different type of reports including: Tabular forms, Matrix form, List items, Charts and Linked reports.
• Designed reports using table filters, single value parameters, multi value parameters, and cascading parameters
• Scheduled reports using Standard and Data Driven Subscriptions.
• Actively involved in creating SSIS packages to transform data from OLTP database to a data warehouse.
• Used differentControl Flow Tasks and Data flow Taskfor Creating SSIS Packages. Used different types ofTransformationsfor Data Conversion, Sorting and cleaning the data from different Sources into Company Format.
• Design and create report models based on user requirements, explain and train users to use report builder to generate their own personalized reports.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Created reports using stored procedure and also involved in scheduling, creating snapshots and subscriptions for the reports SSRS.
• Generated Tabular, Sub reports, Parameterized reports, pie charts and bar charts for the Business users and created report models to support AD HOC REPORTING.
• Scheduled the DTS package for migration data from old system to MS SQL 2005.
• Reconciled data for transformation from SQL 2000 to SQL 2005 using SSIS
• Designed and developed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Fuzzy grouping, Fuzzy lookup, Bulk Insert, merge and union all.
• Scheduling & Maintaining ETL packages in terms of data validation and consistency.
• Created packages in SSIS with error handling as well as created complex SSIS packages using proper control flow and data flow elements.
• Created Package Configurations, Event Handlers for On Error, On Warning, On Task Failed Event Types
• Written PowerShell script to generate SQL scripts to recreate the tables, stored procedures, views, triggers, key constraints, indexes, functions, jobs and more using SMO objects.
• Involved in creation of PowerShell script to run the SQL scripts to build a new Database.
• Used Toad Server for Comparison of Database Schemas.
• Written Dynamic queries and executed them through PowerShell.
• Written PowerShell script to Export the data from tables into CSV files.
• Written PowerShell script to Import the data into tables using OPENROWSET from CSV files.
• Written Dynamic SQL to update the date columns in the tables and run them through PowerShell.
• Involved in creation of PowerShell script to deploy SSRS reports to target server, using RS.exe.
• Created PowerShell script to deploy SSIS packages to target server, using SQLPSX.
• Created PowerShell script to deploy & process SSAS cubes to target server, using AMO objects.
• Added logging functionality, which makes sure that any important information shown on the console during execution, is also captured in a file for later analysis.
• Build .CMD files to which will be used to automate the process.
• Implemented XML files as configuration file.
• Written complex stored procedures and functions.

Environment: SQL Server 2008 (SSIS/SSRS/SSAS), Windows Server 2008, T-SQL, PowerShell, CSV files, Toad Server.

Confidential, Houston TX

SQL BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase)
• Created SSIS packages with error handling and different methods of logging.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Designed packages using Lookup Transformations, Merge Joins, Fuzzy Look Ups, Derived Columns with Multiple Data Flow tasks
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Experience in SQL Server Analysis Services (SSAS) for data mining to identify rules and patterns in the data.
• Involved in Dimensional modeling by identifying the fact and dimension tables and design start flake schemas for the SQL Server Analysis services
• Involved in creating calculated members, named set, advanced KPI’S for theSSAScubes.
• Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model.
• Deployed the SSIS Packages from development server to production server.
• Developed Multi-dimensional Objects (Cubes, Dimensions) using MS Analysis
• Involved in creating Named calculations and named queries.
• Created Dimensions with the cube wizard and also individually.
• Extensively involved in the SSAS storage and partitions and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Worked on Multidimensional Expressions (MDX) to query multidimensional data or to create MDX expressions for use within a cube
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Tested queries to optimize the procedures and triggers to be used in production.
• Querying and manipulating multidimensional cube data through MDX Scripting.
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
• Analyze historical trends, identify issues and analyze root cause on ProClarity Dashboard.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Wrote store procedures to generate account statements for different types of accounts
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Environment: SQL Server 2005, SSAS, SSIS, T-SQL, SSRS, Windows Server 2003, Oracle 9i.

Confidential

SQL Server Developer

Responsibilities:

• Created new tables, written stored procedures, triggers for Application Developers and some user defined functions.
• Created SQL scripts for tuning and scheduling.
• Involved in performing data conversions from flat files into a normalized database structure.
• Created and managed users, roles and groups and handled database security.
• Defined Check constraints, Business Rules, Indexes and Views.
• Worked with Configurations on the Server for sending automatic e-mails to the respective people when a DTS process failure or success.
• Import/Export using MS Access, Excel and Text file to/from SQL Server
• Transformed data from various data sources like Excel, Flat file using OLE DB connection by creating various DTS packages.
• Involved in Administration of the SQL Server by creating users & login ids with appropriate roles & grant privileges to users and roles.
• Perform daily database backup & restoration and monitor the performance of Database Server
• Automate and enhance daily administrative tasks, including space management, object alteration, backup & recovery and performance monitoring.
• Developed DTS Packages, worked with DTS Import/Export for transferring data from Heterogeneous Database (Oracle and Text format data) to SQL Server.
• Performed Data migration (import & export - BCP) from Text to SQL Server.
• Performed development support, document reviews, test plan, integration of the system.
• Developed database objects such as DTS Packages, Procedures, Functions, Tables, Triggers, and indexes using T-SQL/PL SQL, SQL Analyzer and Enterprise Manager.
• Creation/ Maintenance of Indexes for various fast and efficient reporting processes.
• Managing historical data from various heterogeneous data sources (i.e. Excel, Access).

Environment: SQL Server 2000, ASP, ADO, Java Script, and Microsoft Visual Studio 6.0., Visio, IIS.