ANILKUMAR PULLAPPILLIL RAMAN

Email: c87cc2@r.postjobfree.com

Cell: 201-***-****

Summary

Experience

11.5 years experience in analysis, design and development of business systems.

Strong domain and data warehouse design experience in Container Shipping, Transportation industry, Membership Management Systems, 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 2005/2008 Business Intelligence Tools, Data Warehousing and ETL process.

Extensive experience and proficiency on the 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)

Advanced extensible reporting skills using SQL Server Reporting Services (SSRS), Crystal Reports, and MS Excel spreadsheets

Expert in designing Enterprise reports using SSRS 2008 such as drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts

Experience in creating Ad-hoc reports, data driven subscription reports by 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.

Scheduling and Monitoring ETL Processes using 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 6, 2003, 2005, 2008 & 2010.

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, Crystal Reports 7.0 to 11.0

Microsoft Technologies : SSIS, SSAS, MS Visio, VB 6.0,

SQL Server Business Intelligence

Development Studio 2008, Visual Studio 2005

Version Control : Visual Source Safe (VSS), Vault

Qualifications

Masters Degree in Computer Application (M.C.A.) - First Class, Bharathiar University, INDIA

Post Graduate Diploma in Computer Application (PGDCA) - XBCE, INDIA

Diploma In R.D.B.M.S.

Bachelors of Science Degree in Statistics – Mahatma Gandhi University, INDIA

Projects Experience

1. InfoScout - The GSUSA Data Warehouse project

Client: Girl Scouts of the USA, NY [Jan 2009 - Till Date]

Technical Lead/Database Modeler/Senior BI Developer

InfoScout is the one stop shop for all Membership, Retail, Fund Raising, Accounting Reporting and other data sources. Multidimensional analysis gives the ability to end users to observe data from various viewpoints. In this way, an end user can spot trends or exceptions in the data. InfoScout will:

• 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)

• 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

2. Performance Management System

Client: Mediterranean Shipping Company, NY [Sep 2007 - Dec 2008]

Module Lead/Senior BI Developer

This Business Intelligence Software is designed as innovative Business Intelligence tool, for Mediterranean Shipping. A first of its kind, in the shipping industry is delivered on state of the art technology. The multi-stage system assists this transport company to "Convert Data to Profitability". This DW is an integrated system across the boundaries of the organization like Inventory Management System, Container Booking System, Documentation Management System, Intermodal System, Import and Export Management System.

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

3. Sonoco Data-warehouse Implementation

Client: Sonoco Products Company, SC [Sep 2006 - Aug 2007]

Technical Lead/Senior BI Developer

The objective of the project is to build a platform that is uniform across the company and would provide a one point of view to the stakeholders and users. 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

4. Data Conversion Product

Client: TMA Resources, VA [Jan 2006 – Aug 2006]

Technical Lead/Senior .NET Developer

This Product can be used to convert data from legacy systems into a new Membership Management product, “Personify”. Personify customers can be used this web based application to define their data mapping, validation rules dynamically and execute validation process and finally load into the Personify system from their legacy system. The actual data load is happening thru the SSIS packages, which can be initiated by the end user.

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

5. E-Signature - Physician’s Inbox & E-Signature System

Client: Spheris - Medical transcription technology and services, VA [Jun 2005 – Dec 2005]

Module Lead/Senior .Net Developer

E-Signature is a system where the physician’s can view and sign reports electronically. The system allows the physician’s to view, edit and electronically authenticate/reject the reports prepared by medical transcriptionists. Physicians can also reject the documents with comments and thereby return the report to originator for changes.

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

6. Multi Modular Integrated Application (MIA)

Client: PSF, Dubai UAE [Aug 2003 – May 2005]

Team Lead/Data Molder/Senior Developer

A feature-loaded system that manages the complete business needs of Shipping Liner Agencies. From Budgeting and Business Planning, to Results and Financials, the MIA handles the business with a single source of input and seamless data integration. It works with minimal hardware investments, has a very short set-up and implementation process and hence, makes an excellent value proposition

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

7. Freight Forwarding System.

Client: Agis-Aweka Ltd, India [Feb 2003 – Jul 2003]

Team Leader/DBA/Senior Developer

The system provides facilities for Freight Forwarding Company to handle the Door-To-Door cargo movement. It gives options to keep the buying rates for multiple lines to single or multiple POL-POD combinations. The marketing executive can book the container by selecting the buying rate once the buying rate(s) are updated in the system. System provides the facility to handle the Pre Carriage and On Carriage. It shows the Net Receivable (Local and Destination), Net Payable (Local and Destination) and Net Profit Loss. It also does the automatic Booking Accounting. The Client is the Indian Sector (HO at Chennai) of a German Company, which has 9 branches in India.

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

8. Coastal Shipping (Line)

Client: Trans Asia Shipping Line, India [Aug 2002 – Jan 2003]

Senior Application & Database Developer

An integrated back office system developed for a shipping line. The system allows data import/export from/to Text and Excel files to communicate with the liner agents. System allows rating, booking, documentation, financials and container tracking.

Environment : Visual Basic 6.0, Crystal Reports 7, VBA and SQL

Server 7.0

Responsibilities :

• Created database objects like Stored Procedures, Indexes and Views in SQL Server 7.0

• Creating Windows forms using VB 6.0

• Developed reports using Crystal Reports 7.0

• Developed MIS reports using VBA and Excel Macros

9. Payroll Processing System

Client: Nortrans Marine Services, India [Jan 2002 – Jul 2002]

Senior Application & Database Developer

This system is developed for handling end-to-end payroll processing. Also create all MIS reports and statutory reports and reports to Bank.

Environment : Delphi 5.0 and SQL Server 7.0

Responsibilities :

• Created database objects like Stored Procedures, Indexes and Views in SQL Server 7.0

• Creating Windows forms using Delphi 5.0

• Processing Text /CSV files from Statutory Bodies and loading to database

10. Integrated Back Office for stock broking company

Client: Geojit Financial Services Ltd, India [Jul 2001 – Dec 2001]

Application & Database Developer

The system has the capabilities to do trade monitoring, offline order entries for NSE/BSE/CSE, NSE/BSE/CSE trade processing, margin calculation (Share & Cash), daily brokerage monitoring, client wise and script wise performance reporting, market analysis, share delivery, share certificates wise tracking, fake certificate marking, allocation stock maintenance, bad delivery, automatic accounting, etc.

Environment : Delphi 5.0 and SQL Server 7.0, Processing Text /CSV files

Responsibilities :

• Created database objects like Stored Procedures, Indexes and Views in SQL Server 7.0

• Creating Windows forms using Delphi 5.0

• Processing Text /CSV files and loading to database

Developing various entry modules, modules to process TEXT/CSV files and report writing. Created customized report writer.

11. Integrated Shipping and Logistics System

Client: Nortrans Marine Services, India [Mar 1999 – Jun 2001]

Application & Database Developer

This shipping agency system has the functionalities like route and time analysis for enquiry with schedules of their principal services and feeder services, quotation facility with automated funding mechanism, export booking, inland container movement handling; container tracking; export and import documentation for statutory bodies, payment modules for vendor/port, financials, Market Identification and Business Forecasting (MIBF) and MIS Reports. The system can handle multiple Lines.

Environment : Visual Basic 6.0, Crystal Reports 7, VBA and SQL Server 7.0

Responsibilities :

• Created database objects like Stored Procedures, Indexes and Views in SQL Server 7.0

• Creating Windows forms using VB 6.0

• Developed reports using Crystal Reports 7.0

• Developed MIS reports using VBA and Excel Macros

Contact this candidate