PROFESIONAL SUMMARY:

• 9 years of IT experience in the Analysis, Design, Development, Implement, Test and Administrating
• Expert in Microsoft Business Intelligence Services like SQL Server Integration Services, SQL Server Analysis Services and SQL Server Reporting Services.
• Good working knowledge of Extraction, Transformation and Loading (ETL) between homogenous and heterogeneous sources using SSIS packages.
• Experience in designing Star, Snowflake schemas and database modeling.
• Working experience with OLTP and OLAP databases in MS SQL Server (2012/2008R2/2005).
• Experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
• Hands on experience in Data Migration and Transformation from different file formats like Flat file, MS Excel and Oracle to SQL Server 2012/2008R2/2005.
• Proficient with the various components of SSIS including Control Flow, Data Flow, Transformations, Scripting, Logging, Error Handling, Expressions and Event Handlers.
• Expertise in creating Databases, Tables, Cluster/Non - Cluster Index, Unique/Check Constraints, Functions, Views, Stored Procedures, Triggers.
• Expert in developing and modifying multidimensional Cubes in SQL Server Analysis Services.
• Proficient in the SSAS storage and partitions, aggregations, calculation of queries and developing reports using MDX and T-SQL.
• Experienced in generating On-demand and Scheduled reports and dashboards for Business Analysis using SSRS.
• Developed drilldown, drill through, Parameterized reports and Ad hoc reports.
• Expert in writing SQL Queries and Stored Procedures, also involved in Query Optimization and Performance Tuning.
• Experience in working with programming language such as C#, .Net, to maintain and continue development for existing application.
• Strong programming and analytical skills besides competent experience in handling critical situations.

TECHNICAL SKILLS:

BI Tools: SQL Server Integration Services(SSIS), SQL Server Analysis Services(SSAS), SQL Server Reporting Services(SSRS)

Databases: MS SQL Server 2012/2008R2/2005/2000, Oracle 8i,9i/10g, MS Access 97/2007/2010

Languages: T: SQL, PL/SQL, C#, ASP.NET, XML, HTML,VBA

Operating Systems: Windows Server 2003/2008R2/2012, Unix, Linux, Sun Solaris

Other Tools: Data Transformation Studio (DTS), Business Intelligence Development Studio(BIDS), SQL Server Management Studio(SSMS), SQL Profiler, SQL* Loader, Crystal Reports.

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

Sr. MS BI Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems
• Assisted in the design ofstar schemaandsnow flake schema
• Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server and Flat files
• Modified existing SSIS packages to meet current business needs.
• Used SSIS to create ETL packages to validate, extract, transform and load data into data marts.
• Created SSIS packages for Data Conversion using data conversion transformation
• Wrote stored procedures to be used in the SSIS packages.
• Implemented Event Handlers and Error logging in SSIS packages and notified process results to various user communities.
• Worked with Control flow elements like ForeachLoop Container, Sequence container, Forloop container, Execute package task, send mail task, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task, Rebuild index task.
• Worked with SSIS packages involved Dataflow transformations like cache, lookup, sort, conditional split, multicast, Fuzzy Grouping, Merge, Merge join, Pivot and Unpivot
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created On demand (Pull) and Event Based delivery (Push) of reports according to the requirement.
• Deployed and configured the reports in the Report Server.
• Involved in scheduling, creating snapshots and subscriptions for the reports.
• Configured SQL mail agent for sending automatic emails when SSIS packages fails or succeeds.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Schedule the packages to keep extracting the data from OLTP at specific time intervals.
• Responsible for rebuilding the indexes and tables as part of performance tuning.
• Written and executed complex T-SQL queries using SQL Server Management Studio for back end data validation testing
• Optimized queries using SQL Profiler and Database engine tuning advisor
• Used SQL Server Agent for scheduling jobs and alerts
• Involved in design of dimensional data model - Star schema and Snow Flake Schema.

Environment: SQL Server 2012/2008R2, SSRS, SSIS, T-SQL, Oracle 9i/10g, SQL * Profiler, SQL * Loader, Visual Studio 2008, XML,, XSLT, MS Office, Windows 20012/2008R2 and UNIX

Confidential, Phoenix, AZ

Sr. MSBI Developer

Responsibilities:

• Actively involved in gathering requirements from Business Users, and converting them into system requirement specifications and creating detailed use-cases and design documents
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Responsible for creating SSIS packages to extract data from different sources consolidate and merge into one single source.
• Modified existing SSIS packages to meet current business needs.
• Developed large number of standard and customized reports usingSSRSfor data feeds and for Reports on server.
• Created custom and Ad hoc reports using Report builder.
• Generated different types of Reports like Tabular, Matrix, and Charts.
• Generated several drill down and drill through reports using SSRS.
• Part of Relational Data Warehouse Designs and effectively identified and created Facts and Dimensions tables.
• Worked with Managers and Management to design customized Reports to view OLAP cube Data.
• Responsible for developing Stored Procedures, Triggers, Views and User defined functions.
• Made Efficient use of Joins and sub-queries in queries that involve data from multiple tables.
• Responsible for Creating and ModifyingT-SQLstored procedures/triggersfor validating the integrity of the data.
• Involved inperformance tuningof queries for query efficiency.

Environment: SQL Server 2008R2, Analysis Services(SSAS), Reporting Services (SSRS), Integration Services (SSIS), DTS, Oracle 10g, C#, ASP.NET, Visual Studio 2005, Windows Server 2008R2, MS Office.

Confidential, Houston, TX

MS SQL Server Developer

Responsibilities:

• Involved in transferring old data from various sources like flat files, MS Access, and Excel into MS SQL Server using DTS Packages.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Created SQL server Reports using crystal reports for the manager and the brokers involved.
• Tested to optimize the procedures and triggers to be used in production.
• Performed efficient tuning of SQL queries for data load/ Usage of stored procedures for performance
• Administered tasks such as scheduling, deployment and security.

Environment: MS SQL Server 2000/2005/2008 R2, MS Access, DTS, SQL Query Analyzer, SQL Developer.

Confidential

SQL Developer

Responsibilities:

• Wrote various Stored Procedures for the purpose of application development
• Involved in developing and maintaining the database objects like tables, views
• Tuned SQL statements (e.g.: using Indexes) and Stored Procedures
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Performed job scheduling and alerts
• Created database objects for improving the performance
• Fine-tuned Procedures, Functions and Triggers for optimum performance
• Involved in creating SQL reports
• Involved in the SQL Query Performance Tuning
• Designed and implemented user log in and security
• In-Depth working knowledge of ODBC.
• Worked in front end designing using .NET for developing Win forms, websites and console applications using C#.
• Created many complex Stored Procedures and user defined functions.

Environment: MS SQL Server 2000/2005, T-SQL and Windows NT 4/2000/2003

Confidential

Software Developer

Responsibilities:

• Gathering and analyzing the end user requirements.
• Developing technical design documents as per functional requirements.
• Customizing & Creating Fields, Records, Views, Pages, Components and Menus as per the client’s requirements.
• Design of user interface screens according to the low level design documents.
• Developing reports using PS Query, nVision and SQR from the tech specs given from onsite team.
• Participate in unit testing, integration testing
• Writing SQLs to use in application development
• Writing database stored procedures and triggers to as specified in low level design
• Participation in team planning activities and training sessions and reporting to project manager.

Environment: Oracle 10g, SQR, SQL/PL-SQL, Forms and Reports 6i, peopletools8.49 Windows 2000/XP, MS SQL Server 2000/2005, Microsoft Excel, Microsoft word.