SUMMARY

• 8 years of professional work experience in Business Intelligence Applications Design, Development and Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS).
• Good Experience in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2012/2008/2005.
• Strong working experience on Data Warehousing applications, directly responsible for the Extraction, Transformation and Loading (DTS/SSIS) of data from multiple sources into Data Warehouse.
• Has very good experience in complete ETL cycle including data analysis, database design, data mapping, conversion and data load.
• Experience in Tuning/Optimization of SQL Queries, Views, Stored Procedures for improving the performance in SQL Server and Oracle.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• Good SQL Server Administrator skills including user authorization, Database creation, tables, indexes and cluster creation.
• Created complex DTS Packages for Data Migration and Transformation. Experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2012/2008.
• Great experience in creating SSIS Packages for integrating data using OLE DB connection from sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union.
• Expertise in designing SSIS packages (2012/2008/2005 ) to import and transform data between databases and external data sources.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Extensive knowledge and experience in producing tables, reports, graphs and listings using various procedures and handling large databases to perform data manipulations.
• Supported team in resolving SQL Reporting services and T - SQL related issues.
• Experienced in designing and developing large number of reports in SSRS/Business Objects using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Experienced in creating various types of reports such as simple and complex Drill Down reports, Drill through reports, Cross-Tab, Conditional, Matrix reports, Sub Reports and charts using SSRS based on Relational and OLAP databases.
• Experienced in creating customized and Complex Reports using various tools like Business Objects and Crystal Reports.
• Experienced in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized views of large sets of data and used Multi-Dimensional Expression (MDX) & DAX queries to access them.
• Experienced in installing, configuring, managing, monitoring and troubleshooting SQL Server 2005/2008/2012.
• Extensively used SQL profiler to monitor events and SQL Server Agent to Schedule job alerts.
• Experienced in large volume data processing and data analysis.
• Worked on administration tasks such Backup and Recovery, user and application table management, upgrades, user authorizations, Database creation, tables, and indexes.
• Expert knowledge of Data Warehousing methodologies and concepts, including Star schemas, Snowflake Schema, ETL processes & Dimensional Modeling.
• Good knowledge on Ralph-Kimball Methodologies.
• Have good understanding of Tableau architecture, design, development and end user experience.
• Mid-Level Experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau.
• Knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Has relative experience in Pareto charting, advanced calculations, work with demographic and geographic fields.
• Experience in developing rich Interactive reports and dashboards, Storylines and integrating various reporting components from multiple sources.
• Experienced in all phases of project life cycle starting from business requirement gathering, analysis, design, implementation, testing, and production.
• Ability to quickly adapt and learn, works well in team environment as well as independently with minimum supervision.
• Strong analytical and problem-solving skills coupled with excellent written, verbal and inter-personnel communication skills.

TECHNICAL SKILLS

Data Warehousing/ BI Tools: SQL Server Business Intelligence Development - SSIS, SSAS, SSRS, DTS, BI Stack (Power pivot, Power query, Power map).

Database Tools: SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, T-SQL, PL/SQL, OLAP, OLTP, Cubes.

Reporting Tools: SQL Server Reporting Services (SSRS), Business Objects XI R3/XIR 2/6.5/6.1/6.0/5.1 Supervisor, Designer, Info view, Business Objects SDK, Web-Intelligence 3.2/2.7/2.6/2.5 , Xcelsius, MS Excel, Oracle Report Builder.

ETL: SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Informatica 6.1, Business Objects Data Integrator/Data Services (4.x, 3.x).

Databases: MS SQL Server 2016/2014/2012/2008/2005 , Oracle 11g/10g/9i/8i/8.0/7.x, Teradata V2R5/V2R4/V2R3, Sybase 12.x/11.x, MS Access.

Programming: Unix Shell Scripting, Perl Programming, SQL, PL/SQL, SQL Plus, Transact SQL, VB, Java, C, C++

PROFESSIONAL EXPERIENCE

Confidential, Houston

Sr.MS SQL Developer/BI Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users as per agile methodology.
• Designed and developed SSIS packages to move data from staging environment to EDW environments within the organization.
• Used Team Foundation Server (TFS) as a tool for repository of codes and version control, also maintains test scripts and documentation following the standards.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Designed high level ETL (Extraction Transformation Loading) architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Extensively used SSIS for transferring data by utilizing various control flow and data flow elements.
• Developed and maintained a combined data store for reporting purposes.
• Generated reports using Global Variables, Expressions and Functions using SSRS 2012.
• Identified the database tables for defining the queries and defined datasets for report generation.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2012.
• Generated daily, weekly and monthly reports for the managers.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
• Used ProClarity for accessing and analyzing cubes and dimensions, and worked on integration of SharePoint with SSRS.
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
• Experience in upgrading SQL Server software to new versions and applying service packs and hot fixes and unattended Installations.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Tested the reports and fixed bugs in the stored procedures.
• Managed the Metadata associated with the ETL (SSIS) processes used to populate the Data Warehouse.
• Established backup and recovery of SQL server 2012.
• Used Visual Source Safe (VSS) for version control.

Environment: MS SQL Server 2012, SSRS 2012, SSIS 2012, MS SQL Server Data Tools, T-SQL, Visual studio 2010, ASP.NET, DTS, Data Analyzer, java script, MS Access,Excel, SQL Profiler, Windows XP, Erwin 4.2

Confidential, Owings Mills

SQL/SSIS/SSRS Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, DB2, SQL 2005, and SQL 2008).
• Configured to make package portable and created Event handlers for handling package error.
• Created and edited alerts on Reports, as per User request.
• Worked with users and helped Build a Tabular Data Model and published it to Share Point.
• Modify the existing reports by adding new logic and deleting existing logic as the line of Business changes periodically.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Export reports in various formats like MS Excel, PDF, MS Word, Text and CSV, generate reports with parameters, sub reports, cross tabs, charts using SSRS.
• UsedSSRSto create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports inSSRS.
• CreatedSSRSReport Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Coordinate with QNXT implementation analyst on validating provider rates and reimbursement methodologies
• Tested SSIS package that generates member demographics, member medical condition, Lab data and Member Provider extract in CSV file from all 13 QNXT Health Plans.
• Highly involved in creating, structuring, formatting using Report Designer andReport Builder.
• Created and modified various Stored Procedures used in the application using T-SQL.
• Designed Cubes with star schema in SSAS and Executing Analysis Services Processing Task in SSIS for processing cubes in packages.
• Worked withMDXto query cube's data.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Involved in dimensional modeling with Star &Snowflake schemas and created the Data Source Views Involved in development & Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008. Create Calculate member in MOLAP cube using MDX in SSAS 2008.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Created Web Forms using C# and deployed as per Client Requirements.
• Created Project Expense Statements in all Data marts and other Financial Reports using SSRS.
• Developed yearly and quarterly company expense reports.
• Responsible for Deployment of the report using SSRS and used Report subscription (Data Driven and Email) to publish reports.
• Published Tableau Workbooks by creating user filters so that only appropriate teams can view it.
• Experience in creating dashboards and storylines using chart types, visualizations and complex calculations to manipulate the data.
• Usage of Trend Lines in Tableau Workbooks to showcase the incremental behavior.
• Tuning SQL query for better performance using SQL Profiler.
• Actively supported business users for change requests.

Environment: SQL Server 2008/2012, Enterprise Edition, SQL, Enterprise manager, SSRS 2008, SSIS 2008, SSAS, Tableau 8, Spotlight, MS SharePoint, MS Access 2000 & Windows 2007 platform, VB.NET, ASP.NET.

Confidential

Responsibilities:

• Analyzed and designed software and database solutions.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Worked on other packages of the SQL server 2008R2/2012 Edition SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services).
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Created DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Created data mapping between two distinct models.
• Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema and database objects.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Involved in Installation, Configuration of Share Point Form in Cluster Environment.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS and deployed them onto the Report Server.
• Designed and developed Star and Snow Flake Schema.
• Reviewed Cube with End user and changing the cube according to their requirements.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Created Indexes, Constraints and Rules on database objects.
• Created components, tools, techniques, methods and procedures used in an on OLAP environment for accessing and translating data into understandable and usable business information using SSAS.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2008 Server to achieve the efficiency of SQL Server Analysis (SSAS).
• Created reports with Analysis Services Cube as the data source using SQL Server 2008 Reporting Services.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created DDL/DML Triggers and performed Database Mirroring, Migration, Upgrading using SQL Server 2008 R2.
• Automated Database Maintenance tasks by creating Jobs, Alerts and Operators through SQL Server Agent.
• Performed tuning to optimize SQL queries using SQL profiler and query analyzer.

Environment: MS SQL Server 2008R2, SSAS, SQL Server Reporting Services 2005, SSIS, Erwin 4.2, SSRS 2005/2008, SQL Server Management Studio Enterprise Edition, SQL Profiler, Front Office 8.3 / 10.2 / 10.3 , Windows XP / NT / 2000/2003, MS Office 2003/2007.

Confidential

MS SQL Developer

Responsibilities:

• Created scripts for tables,stored procedures, ETL Process performed by using SSIS as per design and analysis of project documentation.
• Involved inperformance tuningof TSQL related objects.
• Performed data conversions from Flat files into a normalized database structure.
• Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Responsible for creating constraints, Indexes, and Views.
• Performance tuning of SQL queries and stored procedures using Index Tuning Wizard.
• Involved in migration of database from DTS to SSIS.
• Configured Server for sending automatic mails to the respective people when a SSIS scheduled process fails or succeeds to keep a track on the data.
• Performed Data Staging, Data cleansing and loading the data to OLE DB destination by performing necessary transformation using SSIS.
• Defined report layouts as per client requirements.
• Identified and defined the Datasets for report generation.
• Wrote queries for Simple & Drill Down reports.
• Identified and included report parameters.
• Involved with Unit testing of the code developed on Dev and Prod environments.
• Involved with the Query performance using Query plan.

Environment: MS SQL Server 2000/2005, T-SQL, DTS, SSIS, MS-Excel, MS-Office, Oracle8i and C#.

Confidential

Responsibilities:

• Actively involved in Normalization & De-normalization of database.
• Installed and ConfiguredSQL Server 2000on servers for designing and testing. Designed DDL and DML for MS SQL Server 2000/2005.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2000.
• UsingData Integration Services(DTS)to populate data from various data sources
• Developed web based front-end screens using MSFrontPage, HTMLandJava Script.
• Actively designed the database to fasten certain daily jobs, storedprocedures.
• Optimized query performance by creating indexes.
• Involved in writingSQL batch scripts.
• Involved inPerformance Tuningof T-SQL queries for optimization.
• Merged existing databases and designed new datamodels to meet the requirements.
• Createdjoinsandsub-queriesfor complex queries involving multiple tables.
• Performed Backup of Database, Transaction log backup & differential backupin daily routine.
• Monitor production Server Activity.
• Worked with DTS packages to load the consistent data into Data warehouse system.
• Tuned the SQL queries using SQL profiler and involved in tuning the database.
• Experience with Troubleshooting related queries.

Environment: SQL Server 2000/2005, DTS, Windows 2003 server, FrontPage, IIS 5.0.