Summary

Experience

• 12 years of experience in analysis, design and development of business systems.
• Strong domain and data warehouse design experience in Container Shipping, Transportation industry, Membership Management, Retails and E-Commerce domains.
• Proven experience in Analysis, Design & Development of high performance database objects.
• Sound knowledge in SQL Server Administration Tasks.
• Excellent Team Management skills.

Business Intelligence

• Skills in SQL Server 2005/2008 Business Intelligence Tools, Data Warehousing and ETL process.
• Extensive experience and proficiency in design, construction and implementation (Star Schema, Snow Flakes) of Business Intelligence.
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS)
• Dimensional Data Modeling and Cube development in SQL Server Analysis Services (SSAS)
• Sound knowledge in Multidimensional Expressions (MDX).
• Advanced reporting skills using SQL Server Reporting Services (SSRS), PerformancePoint 2010, Excel Services 2010, Scorecards, KPIs, Dashboard Designer and Crystal Reports
• Good knowledge in Microsoft SharePoint 2010
• Expert in SSRS configurations such as Caching, Snapshots and Data Driven Subscriptions
• Expert in designing Enterprise reports using SSRS 2008 such as drill down reports, parameterized reports, linked reports, sub reports, tables, matrix and charts
• Experience in creating Ad-hoc reports using Report Builder in SSRS.
• Expert Enterprise Data Modeler with a deep understanding of developing transactional enterprise data models that strictly meet normalization rules, as well as enterprise data warehouses using Kimball data warehouse methodologies.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Extensive experience of using Script Task and Script Component using the languages C#.NET and VB.NET
• Scheduling and Monitoring ETL Processes using SQL Server Agent, DTS Exec utilities and batch files.
• Experience in Database Migration from SQL Server 2000 to 2005 and 2008
• Good development skills in VBA and Excel Macro

Database Design and Programming

• Extensive experience in writing Complex Stored Procedures, Triggers and User Defined Functions in SQL Server 7/2000/2005/2008.
• Development and implementation experience in SQL Server 7/2000/2005/2008.
• Sound knowledge in Transact SQL.
• Proven experience in large database design for ERP Systems
• Supported front-end applications under .Net framework, using C#.Net and ASP.Net

Database Administration

• Creating and Managing Databases and Database Files
• Implementing Administrative Tasks such as Automated Database Maintenance tasks by creating Jobs, Alerts and Operators through SQL Server Agent.
• Used Database engine Tuning Advisor (DTA) for Performance Tuning
• Implemented Data Partitioning for large databases
• Administered Database Recovery Planning and Process
• Protection and Distribution of Data
• Implemented different types of Replication Models (Snapshot, Merge and Transactional) and database Mirroring
• Database Security and Native Data Encryption

Application Development

• Good experience of SDLC with OOPS/OODs for Microsoft .Net Technologies.
• Experience in Analysis, Design, Development, Testing of Client-Server & Web applications with .NET 1.1/2.0, C#.Net, VB.Net, VB6
• Good Knowledge of .NET fundamentals, .NET framework, CLR, CTS
• Proficient on Windows Forms, Windows Services, Web Forms & ASP.Net Web Services
• Development and implementation experience in Visual Studio 2010, 2008, 2005, 2003 and 6.
• Development and implementation experience in Delphi 5.0
• Experience in using Crystal Reports 7.0 to 11.0

Others

• Experience with Software Development Processes & Models: Agile, Waterfall and V-Model
• Ability to solve any programming tasks. Willing to shoulder challenges in technology.
• Capability in debugging and optimizing programs with Delphi/Visual Studio.
• Excellent capabilities in Mathematical Analysis.
• Ability to undertake Team Works.
• Capable of analyzing any process and formulating a solution.

Technical Skills

Programming Languages : C#.Net, VB.Net, JavaScript, VBA, T-SQL, PL/SQL
RDBMS & Tools : SQL Server 7/2000/2005/2008, Database  Engine Tuning Advisor, SQL Profiler, MS  Access
Reporting Tools : SSRS, PerformancePoint 2010, Excel Services 2010, Dashboard Designer, Crystal Reports 7.0 to 11.0 
Microsoft Technologies : SSIS, SSAS, Microsoft SharePoint 2010,  SQL Server Business Intelligence  Development Studio 2008, Visual Studio 010/2008/2005, MS Visio, VB 6.0
Version Control : Visual Source Safe (VSS), Vault

Qualifications

Masters Degree in Computer Application (M.C.A.) 
Post Graduate Diploma in Computer Application (PGDCA) 
Bachelors of Science Degree in Statistics

Projects Experience

Client: Confidential, [Jan 2011 - Till Date]

ETL/BI Development Lead/Database Modeler

Environment : SQL Server 2008, SSIS, SSAS, SSRS, Visual Studio 2008, C#.NET, Microsoft SharePoint Designer 2010, PerformancePoint Dashboard Designer 2010, Excel Services 2010.
Responsibilities :

• Analysis of file/feed formats from different Data Providers and prepare the Data Model for PDV (Relational DB) and CDW (Star Schema).
• Gather the report requirements from business users and design the system.
• Data modeling – Kimball, star schema design
• Build efficient SSIS packages for processing data feeds and load into relational DB and Warehouse DB (fact and dimension tables) with complex transformations such as type 1 and type 2 SCDs.
• Creates MS SSAS 2008 cubes using the Unified Dimensional Model (UDM)
• Creates KPIs in the cube using MDX
• Develop and deliver reporting solutions using MS SSRS 2008, PerformancePoint 2010 and Excel Services 2010
• Design and develop KPIs, Scorecards and Dashboards using PerformancePoint Dashboard Designer
• Design intranet website in Microsoft SharePoint Designer 2010
• Create efficient DB objects such as Store Procedures, Views and Functions
• Implement best practices to maintain optimal performance.

Client: Confidential, [Jan 2009 – Dec 2010] Technical Lead/Database Modeler/Senior BI Developer

• Captures data from source systems and translates it into reporting dimensions.
• Position data for effective and consistent reporting and analytics.
• Provide Standard Reports incorporating all data sources.
• Provide ad-hoc reporting capability to allow select individuals the means to create datasets for additional analysis.

The DW has data marts from below business processes

• Membership System
• 3rd Party Universe (Population/Census Data and Jurisdiction File)
• Retail (Merchandise, Cookie Sales and Nut Sales)
• Fund Development (YourMembership.com, Raiser’s Edge/Donor Perfect Council Data and Personify Fund Development Module)

Environment : SQL Server 2008, IIS 6, SSIS, SSAS, SSRS, Crystal Reports 11
Responsibilities :

• Analysis of Production system, Preparation of Design specification for the Data Warehouse based on the user requirements and Translation of Design Specification to the Data Model using Visio.
• Data modeling – Kimball, star schema design
• Responsible for all ETL operations within group including client feeds, warehouse loads, and data extraction.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
• Creates MS SSAS 2008 cubes using the Unified Dimensional Model (UDM)
• Creates KPIs in the cube using MDX
• Develop and deliver dynamic reporting solutions using MS SSRS 2008 and Crystal Reports
• Design and develop Store Procedures, Configuration Files, Views, and Functions; implement best practices to maintain optimal performance.
• Identifying performance bottlenecks and tuning SQL queries and the Database optimization using SQL Server Profiler and Database engine Tuning Advisor (DTA)
• Working with the database administrator to design disaster recovery processes

Client: Confidential, [Sep 2007 - Dec 2008] Module Lead/Senior BI Developer

Environment : SQL Server 2005, SSIS, SSRS, SSAS, ASP.NET, Visual Studio 2003, IIS 5.0, Crystal Reports 10.0
Responsibilities :

• Worked in Database Design and Database Optimization in SQL Server 2005
• Active Interaction with clients to understand business requirements.
• Worked as a senior developer in creating complex stored procedures, triggers, cursors, tables, and views and other SQL objects.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse Migrated data from different sources including flat files, MS Access to SQL Server 2005 by using SSIS. Converting DTS packages into SQL Server 2005 Integration Services.
• Used Lookup, Merge Join, Conditional split and other component using SSIS.
• Designed, developed and deployed reports using SSRS.
• Developed drill down and drill through reports using SSRS.
• Involved in creation of Star Schema and Snowflake dimensional schema.
• Developed MIS reports using VBA and Excel Macros
• Involved in Database Migration from SQL Server 2000 to 2005

Client: Confidential, [Sep 2006 - Aug 2007] Technical Lead/Senior BI Developer

The key activities defined to achieve the objectives are:

• Implementation of new DW methodologies, logical architectures, tools, processes and controls for DW design, development and management
• Implementation of a new BI infrastructure
• Establishment of consistent ETL and Data Quality frameworks
• Migration of rationalized existing BI data and content to the new BI infrastructure
• Detailed Database, ETL & OLAP design

Environment : SQL Server 2005, IIS 5, SSIS, SSAS, SSRS, Crystal Reports 8.5
Responsibilities :

• Worked in Database Design and Database Optimization in SQL Server 2005
• Play the role of the Data Modeler in the project by interacting closely with the Data architects and Business users at Sonoco and analyzing the different source systems in place at Sonoco to design the optimal data model for the Data-Warehouse.
• Creating logical data models using specialized modeling tools like Microsoft Visio based on the requirements identified.
• Creating various database objects like stored procedures, functions, view and triggers
• Coordinating with DBAs to create the databases in the Test and Production environments.
• Designing the Extraction, Transformation and Loading (ETL) logic to load the Data-warehouse being designed from the different source systems using SSIS 2005.
• Creating canned reports using SSRS and Crystal Reports

Client: Confidential, [Jan 2006 – Aug 2006] Technical Lead/Senior .NET Developer

Environment : ASP.Net 1.1, ADO.Net, C#.Net, JavaScript, SQL Server 2005, Visual Studio 2003, IIS 5.0, SSIS, Crystal Reports 8.5
Responsibilities :

• Worked in Database design and Database Optimization in SQL Server 2005
• Developing the Web Forms using ASP.Net 2.0, ADO.Net and C#.Net
• GUI design using Master Pages, Site Map, Tree View Controls, and CSS.
• Developing Web Services in C#.Net to interact with Personify Application.
• Used JavaScript for Client side scripting
• Writing & reviewing Stored Procedures, Triggers and various database objects.
• Creating SSIS packages and testing the complex business rules

Client: Confidential, [Jun 2005 – Dec 2005] Module Lead/Senior .Net Developer

Environment : ASP.Net 1.1, ADO.Net, C#.Net, JavaScript, SQL Server 2000, Visual Studio 2003, IIS 5.0, VB 6.0
Responsibilities :

• Worked in Database Design and Database Optimization in SQL Server 2000
• Developing the Web Forms using ASP.Net 1.1, ADO.Net and C#.Net
• Used JavaScript for Client side scripting
• Worked with Infragistics controls.
• Writing & reviewing stored procedures, triggers and various database objects.
• Creating DTS packages for batch processing
• Developing various reports using Crystal Reports 8.5

Client: Confidential [Aug 2003 – May 2005] Team Lead/Data Molder/Senior Developer

Environment : Visual Basic 6.0, Crystal reports 8.0, VBA, SQL Server
2000, Analysis services and Replication
Responsibilities :

• Involved in Database Design, writing Stored Procedures, creating and managing Indexes and Views in SQL Server 2000
• Creating Windows forms using VB 6.0
• Created flexible reporting tool using SSAS
• Developed canned reports using Crystal Reports 8.5
• Configured the SQL Server Transaction Replication between branches and HQ

Client: Confidential [Feb 2003 – Jul 2003] Team Leader/DBA/Senior Developer

Environment : Visual Basic 6.0, Crystal Reports 8, VBA, SQL Server 
2000, Analysis services and DTS
Responsibilities :

• Involved in Database Design, writing Stored Procedures, creating and managing Indexes and View in SQL Server 2000
• Creating Windows forms using VB 6.0
• Developed canned reports using Crystal Reports 8.5
• Configured the SQL Server Transaction Replication between branches and HQ
• Developed MIS reports using VBA and Excel Macros
• Created DTS packages to read data from flat files and merge