PROFESSIONAL SUMMARY:

• Over 10+ years of strong experience in the IT industry as SQL Server and BI Developer/Architect in insurance, finance, campaign management.
• Managed teams of up to five developers and testers for timely completion of Project.
• Expertise in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Ad - Hoc Reports and SQL Server Analysis Services (SSAS).
• Knowledge of SQL Server Architecture and all phases of SDLC involving Systems Analysis, Design Development and Implementation.
• Conceptual understanding and working knowledge of ETL using SSIS, Data warehousing, Data marts and OLAP technologies including star schemas, snowflakes using Erwin Tool and Microsoft Visio ETL processes, dimension modeling and reporting tools.
• Worked on facts and dimensional models and also relational data warehouse model
• Experience in using Business intelligence Development Studio (BIDS), GUI to design SSIS packages for Data Management applications.
• Experience in data migration from Oracle to SQL Server and other file formats like flat file and MS Excel etc.
• Knowledge of ACID properties, Database Normalization, designing and creating Indexes, Develop queries and T-SQL Scripts in MS SQL 2012/2008/2005/2000 using Inner, Outer and Cross Joins.
• Proficient in tuning data flow tasks in SSIS using SQL Profiler, SSIS performance monitor.
• Used Transactions and Check Points in SSIS for consistency and atomicity of the data warehouse.
• Experience in Configuration and Managing Servers, data transfer between SQL Server and other heterogeneous relational databases as Oracle.
• Proficient in creating, Configuring and Performance-tuning ETL workflows and SQL queries designed in DTS, MS SQL Server Integration Services (SSIS), SQL Data Tools
• Expert in extracting data from Legacy Systems using SSIS (ETL Tool)
• Experience in ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Experience in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server.
• Hands on experience in implementing Key Performance Indicator (KPI) objects and partitions in SSAS 2005/2008.
• Knowledge of business intelligence / data warehousing practices and tools (SQL Analysis Services-SSAS)
• Expert in developing and modifying multidimensional cubes using SQL Server Analysis Services (SSAS).
• Expert in using Bulk Copy Program, Data Transformation Services and SSIS with MS SQL Server 2000/2005/2008/2012.
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Strong analytical and problem solving skills, excellent communication and presentation skills, and a good team player.

TECHNICAL SKILLS:

Databases: SQl Server 2012,2008,2005 & 2000, MS Access 2000/2003/2007/208/2012 , MySQL,Oracle 9i,10g

Database Tools: Enterprise Manager, Query Analyzer, SQL Server Profiler, DTS, SSIS, SSRS, SSAS, Business intelligence Studio languages: C++,VB,XHTML,XML,C#,T-SQL, .NET, UML

Operating Systems: Windows 2003 Enterprise, Windows NT, Windows Vista, Widows 7

Other Tools: Erwin, Microsoft Visual studio 2003/2005,Microsoft Visio, Microsoft Office, Crystal Reports

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte

BI Architect/Developer

Responsibilities:

• Gathered business requirements and analyzed and designed software solution and database.
• Updated functional specification and technical design documents.
• Designed the ETL framework for both Covariance and Kaspick EDW.
• Wrote Documentation for the ETL framework and complex packages.
• Created SSIS packages to extract data from OLTP to EDW systems and scheduled Jobs to call the packages.
• Designed SSIS Packages to transfer data from various sources like Text Files, SQL Server, and Excel to SQL Server using Business Intelligence Development Studio.
• Wrote T-SQL queries, Stored Procedures and used them to build packages.
• Designed, Developed and Deployed packages in SQL server environment using SSIS-2012.
• Handled a team of four developers and two testers by assigning regular tasks and reviewing the code.
• Helped in the design of the Data warehouse model.
• Created Template packages to be given to the developers to load the data.
• Designed, modified and troubleshoot SSIS packages.
• Used SSIS to load data from various sources into on SQL Server 2012 database and created packages.
• Involved in tuning and configuration of SSIS.
• Deployed SSIS packages from Development to Testing Servers for Covariance deployed the project in production.
• Created Adhoc reports to show the business using SSRS and Tableau.
• Debugging of SSIS packages by using data viewers and the audit logs generated with the MetaData.
• Designed and implemented event handlers, which are workflows that runs in response to the events raised by a package, task or container in SSIS.
• Involved in utilizing SSIS Checkpoint, Loading Dimension and Fact tables for Covariance
• Worked on Data Profiling in SSIS and used Lookup component efficiently.
• Running and Scheduling SSIS Packages.

Environment: Windows 2007, SQL Server 2008/2012, SQL Server Integration Services 2008,SQL Data Tools 2012, SQL Server Analysis Services, T-SQL, SQL Query Analyzer, IIS (5.0), Visual Studio 2005, VB.NET, ASP.NET, MS SSIS 2005,MS SSAS 2005,T-SQL,Windows Server 2003,Erwin 4.0

Confidential, New Jersey

BI Developer/Architect

Responsibilities:

• Worked as a BI Developer/Architect on databases MS SQL Server 2008 using SSIS,T-SQL, stored procedures and views.
• Designed and implemented the Framework to handle the load process, by auditing and automating each load.
• Developed and designed the Master package to handle each batch load.
• Developed complex T-SQL code for the application.
• Modified the existing database by adding the tables and relationships to the tables.
• Performed Data Cleansing is creating new tables for the loading of Data in SSIS.
• Involved in the migration of Data using SSIS packages.
• Involved in performing incremental loads using SSIS packages.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• 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 architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Created OLAP cubes and dimensions for the analysis of sales in specific a reassuring SSAS.
• Developed measures and dimension members using multi-dimensional expression (MDX) to meet additional needs that were calculated from existing measures.
• Developed MDX for cube calculations and KPIs.
• Implemented the calculations to aggregate physical measures using management studio.
• Identified and defined the scoped assignments using script commands.
• Defined d relationships with the measure groups and fact tables.
• Optimized long running stored procedures and Queries for effective data retrieval.

Environment: MS SQL Server 2005 Enterprise Edition, MS SSIS 2005, DTS, T-SQL, Windows Server 2003, Microsoft Visio

Confidential, Philadelphia

SSIS Developer

Responsibilities:

• Responsible for the design of the SSIS packages using various data flows and control flow controls for the ETL for the update of the Data mart from the OLTP database.
• Developed the slowly changing Transportation to maintain the Historical Data.
• Created Alerts for Successful or unsuccessful completion of scheduled Jobs.
• Performed data conversions from flat files into normalized database structure.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Created Triggers to maintain user log for security purpose.
• Created and Maintained Indexes of various fast and efficient reporting processes.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Involved in Data Conversion process from SQL server 2000 to SQL Server 2005 using SSIS.
• Responsible for query optimization using SQL tools such as Query Analyzer, SQL Profiles, Index tuning wizard.

Environment: Microsoft SQL Server 2005/2008, Management Studio, SQL Server Integration Services (SSIS), Microsoft Visual Studio 2005, VB.Net, MS excel 2003, Windows XP

Confidential

Responsibilities:

• Created views as per the requirement of front-end developer.
• Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Wrote complex queries and stored procedures.
• Designed and Created databases, tables, views, stored procedures and triggers.
• Created groups, roles, users and assigning access privileges to users.
• Setting up database backup and recovery procedures for production, quality and development servers.
• Monitored and scheduled existing/new jobs on production environment.
• Periodic checking of all databases with DBCC commands for maintaining data consistency and integrity.
• Coordinated with back-end programmers in writing stored procedures, implemented referential integrity by using triggers, performance and tuning.

Confidential, Orlando, Florida

Software Developer

Responsibilities:

• Developed Views, Stored Procedures and Triggers using SQL.
• Developed SSIS Packages to load the data for the Data warehouse, which was to be used for Campaign management.
• Created reporting tables using Stored Procedures.
• Designing user friendly Interfaces through Executive Information System Dashboard (EIS) for the executives.
• Automated the statistics building on the tables and used oracle hints when required to tune the query to run faster
• Handling Optimization techniques for SSRS like caching the Report, proper linking among Tables and prompting users with custom values. end users with step-by-step instructions to access the pre-build or published reports.
• Performed enhancements to the existing reports based on the requirements and impact analysis of the change.
• Documenting the requirements, design and coding changes. Maintained versions for the code for every change. Followed approval process to migrate the changes from UAT (User acceptance Testing) environment to Production.
• Making provisions for using the common BRIO Reports across all Databases Europe, Australia and Japan and conversion of Europe BRIO Reports into Australia and Japan databases.

Environment: Windows XP, SQL server 2008, ASP, VB 6, Crystal Reports 8, Manual Testing.

Confidential

Software Developer

Responsibilities:

• Developed Views, Stored Procedures and Triggers using SQL.
• Developed SSIS Packages to load the data for the Data warehouse, which was to be used for Campaign management.
• Created reporting tables using Stored Procedures.
• Designing user friendly Interfaces through Executive Information System Dashboard (EIS) for the executives.
• Automated the statistics building on the tables and used oracle hints when required to tune the query to run faster
• Handling Optimization techniques for SSRS like caching the Report, proper linking among Tables and prompting users with custom values. end users with step-by-step instructions to access the pre-build or published reports.
• Performed enhancements to the existing reports based on the requirements and impact analysis of the change.
• Documenting the requirements, design and coding changes. Maintained versions for the code for every change. Followed approval process to migrate the changes from UAT (User acceptance Testing) environment to Production.
• Making provisions for using the common BRIO Reports across all Databases Europe, Australia and Japan and conversion of Europe BRIO Reports into Australia and Japan databases.

Environment: Windows XP, SQL server 2005, C#, SQL, Java Script, HTML, XML Manual Testing.