PROFESSIONAL SUMMARY:

• Over 8 years of Industry experience in Data warehousing experience with Microsoft SQL Server 2005/2008/2008 R2/2012/2014, SSIS/SSRS/SSAS/MOSS OLTP and OLAP.
• Extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.
• Experience in using T - SQL in SQL Server 2000/2005/2008/2008 R2/2012 and 2014 platforms.
• Experience in developing the applications using T-SQL Programming (DDL, DML, and DCL).
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints. Designed schemas. Built tables, FKs, PKs, etc. by providing a structure that meets the business needs.
• Experienced in creating Entity relationship (ER) diagrams.
• Expertise in monitoring SQL Server Performance tuning in SQL Server using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
• Hands on Experience SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment
• Extensive experience in creating interfaces using SSIS and its different tools like SSMS (SQL Server Management Studio), BIDS (Business Intelligence Development Server) and SQL Server Configuration Manager.
• Expert in designing ETL data flows using SSIS. Created mappings/workflows to extract data from heterogeneous sources SQL SERVER, ORACLE, (Excel, CSV, flat file, Text Format Data) using SQL Server Integration Services(SSIS).
• Expertise in Microsoft Integration Services SSIS (Control Flow tasks, Data Flow tasks, Transformations, Database administration tasks).
• Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
• Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Good understanding and designing of Star and Snow Flake data models Schema used in relational, dimensional and multidimensional data modeling.
• Good experience in Creating, Populating and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts and creating Dimensional models in Data Marts.
• Solid Knowledge in developing cubes using Partitions, KPI’s, and Perspectives, slow changing dimensions (SCD) etc. and created various user roles (SSAS).
• Experience in writing expressions in SSRS. Created many Drill through, Drill Down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports using SSRS.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Experience working with Azure SQL Database Import and Export Service.
• Experience in deploying SQL Databases in CLOUD (AZURE).
• Created reports by mixing Excel, Charts & Power Pivot.
• Strong experience in VBA coding, MS Office.
• Expertise in Business object universe for data warehouse analytical reporting.
• Experience in creating Ad hoc reports with complex formulas to query the database for BI Intelligence.
• Experienced in .NET Framework 2.0/3.0, Microsoft Visual Studio 2008/2010/2012.
• Exceptional background in analysis, design, development, customization, implementation and testing of software applications and products.
• Extensive experience in data analysis and strong in data mining and data management skill.
• Strong data mining and data management skills.
• Experience in working closely with testing teams and with business users on create automated scripts on data validation and data analysis.

TECHNICAL SKILLS:

Programming Languages: C, C++, T-SQL, PL/SQL

Databases: SQLServer2000/2005/2008R2/2012/2014,Oracle10g,Sybase,MS Access2003/2005/Teradata

Tools: Performance Monitor, Backup Utility, SQL LiteSpeed, Spotlight, DB Artisan, SQL Server Management Studio, Query Analyzer, Enterprise Manager, Profiler

Other Tools: DTS, Business Intelligence Development Studio, SSRS, SSIS, SSAS. OPEN FT

Web technologies: HTML, XML,VB Scripts, IIS, PhP

Platforms: UNIX, LINUX, Windows 2003/2000, Windows XP, Windows NT

PROFESSIONAL EXPERIENCE

Confidential,Waukegan, IL

Senior BI Developer

Responsibilities:

• Excellent report creation skills using Microsoft SQL Server 2012/2008 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Created SQL Server Reports based on the requirements using SSRS 2012.
• Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements. Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Created complex reports which involve more number of groupings and multi-value parameters.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2012/2008 (SSAS)
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Analyzed, designed and implemented Data warehouse, Data marts and File Validation Process.
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Designed and developed Data Warehouses, Data marts and Business Intelligence solution using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes.
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing
• Create an alternate work flow for Datastage ETL process using SSIS.
• Using SSIS packages moved the data from SQL server to Azure.
• Used Excel Pivot tables with Access data. Reported Access data using the Excel presentation layer Move data between Excel and Access using VBA, ADO and SQL.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Scheduling the SSIS packages and Jobs.
• Gathered business requirements and analyzed and designed software solution for the Data migration from the Microsoft GP databases into the Warehouse and also to Windows Azure for AX Dynamics. Databases which will be used by application for POS systems and also linked to the AX Dynamics.
• Maintained high degree of competency across the Microsoft Application Platform, focusing on .NET Framework, WCF, Windows Azure, AppFabric, and SQL Azure
• Developed Complex Stored Procedures, Functions, Triggers, Views, Temporary Tables and user defined datatypes as per the requirement.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Checked the configuration and performance of the existing databases including data file allocation, index, fragmentation and impact on system performance. Analyzed potential problems (response delay, locking, server down time, etc) to avoid and optimize by following the Normalization standards to maintain data consistency and by performing data validation.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: Windows server 2003, IIS 6.0, MS SQL Server-2012/2010/2008 R2/2005 Enterprise Edition, Tabular, VBA, ETL, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Erwin VB.NET, OLAP, Crystal reports, Java, OLTP, UNIX, Linux, DAX, MDX, Erwin, Oracle, Performance Point Sever, C++, Tableau, Excel Pivot, Office-2007, DB2, MS Excel, C#.NET, PowerShell, ProClarity Analysis.

Confidential, Austin, TX

Sr. SQL Developer

Responsibilities:

• Installation of SQL Server 2012/2008R2 on Production and Development environment.
• Assigned for Database Optimization that involved re-engineering the databases, data and index organizing, performance tuning and query tuning.
• As a part of the team, configured Transactional Replication with multiple publishers and centralized subscriber for real time reporting.
• Also implemented Mirroring for DR Plan.
• Created/altered/modified and tuned T-SQL complex Stored Procedures, Queries, views, tables, and functions on OLTP and OLAP environments.
• Migrated the SCOM (System Center Operations Manager) 2007 R2 and installed required Service packs and cumulative updates to the SQL Server 2008R2 environment.
• Broke down complex VBA code from existing Excel reports which has all pivoted data and wrote SQL scripts to overcome the Excel issue as we will be using SSRS for reports down the line.
• Experienced in writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and complex joins and sub queries in SQL Server Management studio (SSMS).
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Creating Logins and Roles with appropriate permissions.
• Resolving blocking and deadlocks using DMVs, Profiler and killing respective SPIDs and also optimizing the queries, which are involved in blocking and deadlock issues.
• Created numerous reports using reporting services SSRS and deploying them on SharePoint
• Broke down complex VBA code to better understand the Excel reports and create SSRS reports out of it.
• Scheduling SQL Server Agent Jobs for updating statistics, checking fragmentation, checking database integrity and backup plans.
• Involved in capacity planning, sizing and database growth projections.
• Monitor and modify performance using execution plans and Index tuning.
• Optimize the performance of queries with modifications in T-SQL queries like remove unnecessary columns, eliminate redundant and inconsistent data, and normalize tables.
• Interacting with development team in writing good standard TSQL queries.
• Applied patches, hot fixes, cleared .NET framework corruption errors.
• Experience in using different PowerShell (DSC, ISE) environments that helps for testing, deployments and for debugging scripts.
• Documentation, Training and mentoring the staff.
• As a part of the team, was always involved in production deployment.

Environment: MS SQL Server 2005, 2008 R2, 2012, ERWIN, MS Visual Studio 2010, PowerShell, Excel, HTML, SSAS, SSIS, SSRS, SQL Server Management Studio (SSMS), T-SQL, Excel VBA (Visual Basic for Applications), BIDS, Oracle, PL/SQL. Idera, RedGate.

Confidential, Frisco, TX

SQL BI Developer

Responsibilities:

• Imported data using SSIS packages and using custom Sql server stored procedures.
• Worked on Data Migration and ETL operations using SSIS.
• Configured linked servers to fetch data from another server (in our case it’s Oracle).
• Develop Stored Procedures, Functions, Views, CTE’s, Joins and Sub queries to enforce the business rules. Fine-tuned SQL queries to improve query performance and to reduce runtime.
• Optimized Stored Procedures, Views, and User-Defined Functions based on requirements.
• Performed Debugging on the stored procedures for the requirement to handle the errors.
• Created Data Profiling packages to check the data discrepancies between the source data and data warehouse data, profiling was done on column level. Created some effective ways to cleanse the wrong data entered.
• Developed Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for Developing Cubes using MDX.
• Expert in creating Star schema cubes using SSAS.
• Good knowledge on working with Dimension Usage properties, Dimension relationships, Dimension Hierarchies properties, SSAS Actions, perspectives and Browser.
• Developed Aggregations and calculated members for cube as per business requirements.
• Defined appropriate Hierarchies, measure groups and KPIs & deployed cubes.
• Created Analysis cubes, dimensions and business KPI’s using Sql server analysis services representing aggregations in several different ways - hierarchically and using custom groupings. Created basic Time series MDX functions and MDX queries to support the business requirement.
• Designed Partitions in Cubes on time for improvement in performance using SSAS.
• Involved in deployment of SSRS reports on the SharePoint Portal.
• Generated parameterized/Drilldown, Drill through & Cascaded reports using SSRS and Crystal Reports.
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Responsible to support the issues with reports on the enterprise environments (Development, UAT, Test and Production).
• Implemented Business Intelligence Reports using Sql Server reporting services, Excel reports using Excel and then Uploaded to SharePoint Server 2010 using Excel Services and Report Server Web parts.
• Key product areas utilized also include data modeling, SSRS report subscription and data driven subscriptions, SSAS Analysis Services processing tasks, cube processing options and roles.

Environment: SQL Server 2005,2008,2008 R2 SSIS, SSRS, SSAS, XML, Share Point 2010, InfoPath, C#,PowerShell, .Net

Confidential,Towson, MD

SQL BI Developer

Responsibilities:

• Responded to ad-hoc requests from Business Analyst and Project Managers by providing accurate data/reports in a timely manner.
• Involved in database Schema design and development.
• Created database objects like Procedures, Functions, Triggers, Indexes, DML and DDL statements.
• Worked on monitoring and tuning of SQL scripts, Created clustered and non-clustered Indexes for production database.
• Extensively worked in T-SQL programming.
• Created and managed schema objects such as tables, views, indexes, procedures, and triggers & maintained Referential Integrity.
• Created Generic SQL scripts to circumvent the tedious and error prone pivot task in MS Excel.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Used Execution Plan, SQL SERVER Profiler to trace the slow running queries and tried to optimize SQL queries for improved performance and availability.
• Excellent knowledge in Data profiling and reconciliation.
• Extensively used Temp variables and Temp tables, user defined and table valued functions for data analysis.
• Refined the performance of variousSQLscripts and stored procedures by using UDFs, CTEs and System stored procedures along with usage of tools likeSQLProfiler and Database Tuning Advisor.
• Created copy-only backups from production environment and Applied to Test\Dev environments to test functionality on the latest data.
• Designed ETL packages to load the data from staging server to Data marts on Data warehouse.
• Worked with various SSIS control flow tasks and data transformation tasks like Data conversion, Derived Column, Look-up, Fuzzy Look-up, script task, etc. as part of ETL.
• Worked with configuring checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
• Automated execution process, scheduling, deploying of packages using SQL Server Agent.
• Deployed SSIS packages with minimal changes using XML configuration file.
• Created SSRS reports using complex SQL Queries/Stored Procs which have sub-reports, Drill-Down reports and charts.
• Created data sources, connection strings and defined the datasets for generating the report.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules as per the Client requirements.
• Created the test data to test the performance and functionality of the SSRS Reports.
• Created subscriptions to provide a daily basis reports.
• Experienced in managing and troubleshooting report server related issues.

Environment: Microsoft SQL Server 2008R2, SSIS, SSAS, SSRS, SSMS, Visual Studio/BIDS, Windows, C#MS ACCESS, EXCEL, TFS, VSS

Confidential

SQL Server Developer / ETL Developer

Responsibilities:

• Worked on developing Tables, Indexes, Views, creating complex stored procedures, Triggers, Functions.
• Involved in gathering business requirements from clients about the credentials needed to access their servers, firewall settings and management about the table structures that are to be defined and the data structure that is to be collected from the clients.
• Created functional requirement specifications and supporting documents for business systems. Experience in database design process and data modeling process for Billing Method using Erwin.
• Designed Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008) and Excel Pivot tables based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Built Drill Down, Drill through, linked and sub reports using SSRS 2005.
• Designed reports using Pivot-tables, bar-charts, Line-charts and Pie-charts on data from cubes and SQL Server in Excel 2007.
• Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Transform and Load the Data from various Databases and into Siemens servers using SQL Server Integration Services (SSIS).
• Scheduling and maintaining SSIS Packages and batch jobs thru SQL Server Agent and thru various Shell scripts, VB script, and batch (.bat) files on a day to day basis.
• Experience in configuring with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
• Deploying the packages (both the methods File system & SQL Server system) to different environments (test environment, production environment).
• Experience in developing Life Cycle using Agile Methodology.
• Experience in optimization of queries, improving the performance and maintaining the database consistency with DBCC at regular intervals.

Environment: SQL Server 2000, 2005,2008, SSIS, SSRS, SSAS, XML, MS Project, MS Access 2000 & Windows 2K platform, Share Point, Crystal reports, Oracle 9i, C#, .Net.

Confidential

SQL Developer

Responsibilities:

• Determined the MS SQL Server 2000 installation options. Installed SQL Server Management tools using SQL Server Setup Program. Test the Installation of SQL Server and implemented different security modes.
• Worked on Client/Server tools like MS SQL Server 2000 Enterprise Manager and Query Analyzer to Administer SQL Server
• Used Aggregation Design Wizard to decide best possible aggregation for a given amount of disk space in MS Analysis services 2000.
• Experience in DTS for data flow from one source files like Excel, Tables, and Views to other databases or files with proper mapping.
• Implemented a successful security plan by creating statement permissions, linked servers and encryption of connections by creating certificates.
• Experience in writing stored procedures, functions, triggers and calling them in the packages.
• Created number of jobs, alerts and operators to be paged or emailed in case of failure for SQL 2000.
• Participated in maintaining and modifying tables and constraints for Premium Database using MS SQL Server
• Configured Database Mail, created operators, jobs and alerts for automating databases.
• Created DTS packages using Active X Task to migrate data from heterogeneous data sources such as MS Access, Excel etc
• Designed DTS package, with DTS Import/Export wizard for transferring data.

Environment: SQL Server 2000/2005 Enterprise Edition, Enterprise Manager, Query Analyzer, Import & Export Data, VB.Net, Windows 2005/2008, Windows Active Directory, MS Access, MS Excel.