Sql Server Project Sales Management Business .Net
Resume:
SRIRAM SANKARANARAYANAN [pic][pic]
************@*****.*** /
*************@*****.***
Home: 651-***-**** / Cell :
PROFILE
. Having 11+ years of experience in IT in different area of exposure,
including Development, Maintenance, ETL Design, SDLC Process, People
Management
. Possess 5+ years (out of 11 Years in IT) of experience in implementing
ETL process using Business Intelligence at 7 Warehouse locations.
Majorly used MSBI (SSIS, SSRS), Business Objects XI, Crystal Reports
and have experience in SSAS
SUMMARY
. Having more than 11 years of experience in Analyzing, Designing,
Developing and Implementing Software Solutions
. Involved in Huge data migrations, transfers using utilities like Data
Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and
Bulk Insert.
. Experienced in programming tasks-Stored Procedures, Functions, View,
Triggers, Cursors using SQL Server 2012/2008/2005/2000 with T-SQL
. Creating & Managing Job Schedules processing data through XML
. Experience in BI Development and Deployment of DTS, SSIS packages from
SQL Server, Excel, Oracle, DB2, Teradata
. Expertise in generating reports using SQL Server Reporting Services,
Crystal Reports, XML and MS Excel spreadsheets
. Expertise in client Server technology using Visual Basic 6.0, ASP 3.0,
COM+
. Designed Cube & Measure for Analytic services for Data warehouse using
SSAS
. Designed ETL operation for major warehouse operations
. Worked in area of Project Management, SDLC Process
. Showed exceptional performance in building new team, rapport support
to client system, Project Delivery, Estimation in Work and
Communication
. Experience in providing Logging, Error handling by using Event
Handler, and Custom Logging for SSIS Packages.
. Experience in Performance Tuning in SSIS packages by using Row
Transformations, Block and Unblock Transformations.
. Experience in .Net Framework 3.5 (VB.NET and C#.NET), IIS 7.0
. MCP Certified & Brianbench certified professional in VB, Client
Server, RDBMS
. Excelled in guiding technical teams. Articulated project goals and
scope, translated business needs into technical terms
. Manage medium sized team at Onsite & Offshore and have more than 6
years of experience in Project Management
TECHNICAL SKILLS
Operating System Windows 2000, Windows XP, Windows Server
2003, Windows 7
Databases & Tools SQL Server 2000 / 2005 / 2008 R2, 2012,
MS-Access, Oracle
Business Intelligence MSBI (SSIS, SSRS, SSAS) in versions 2005 /
2008 R2 /2012
Reporting Tools Crystal Reports 11, Business Objects XI
(Webi / Desktop)
Programming Languages VB 6.0, ASP, JavaScript, VBScript, HTML,
XML, .Net 3.5 (C#, VB.Net, ASP.Net)
Other Utilities IIS 6.0 / 7.0, COM+, VBA, VSS, Web
services, Component One Source, ABBYY Fine
Reader, Citrix
OTHER SOFTWARE COURSES/CERTIFICATION
No Name of Institution Certificate Year of
Completion
1 Microsoft MCP (070-229) 2006
2 Brainbench Visual Basic 6.0, RDBMS 2006
concepts, ADO.Net, ASP.Net
Fundamentals
3 Brainbench Customer Requirements, 2010
Data Modeling, SCM,
Software Testing,
Programming concepts
4 University of ACIM (Advanced Diploma in 1999
Indianapolis Computer Integrated
Management)
EDUCATION:
* Master of Computer Applications 2001
Bharathidasan University, India 68%
* Bachelor of Science (Physics) 1998
Bharathidasan University, India 75%
EMPLOYMENT HISTORY:
* Cognizant Technology Solutions 2004 - Present
Senior System Analyst
* Future Focus Infotech P Ltd 2003 - 2004
Software Engineer
* PAS Technologies 2001- 2003
Programmer
PROJECT PROFILE:
#1 Title 3M Planning
Duration Dec 2007 - Till date
Client 3M Corporation
Technology SQL Server 2000 / 2005 / 2008 / 2012,
SSIS, SSRS, SSAS, Crystal Reports 11,
Business Object 11 R3/ R4, Cypress,
Citrix Management Console, VB, ASP, True
DB Grid 8.0, C#, ASP.Net, ADO.Net, Java
Script, HTML, Oracle, Teradata, DB2
Team Size 10
This application works at Core Manufacturing area of warehouse with
different modules.
ETL Module :
Designed SSIS Package to port data from different system of DB (Oracle,
Teradata, DB2) to sync in data with Archive & Report. Also using SSRS and
BOXI, reports were created for different set of users. Global users use
BOXI and Warehouse operation uses SSRS reports.
Application Module :
Planning application used at all Warehouse locations in USA and reports
used all over the world. It got migrated from legacy VB 6.0 to Web using
.Net.
When an order is submitted by the user, our system will take care of
combining relevant orders into Trailers and finding the best way of
shipping based on the shipping location, Priority of shipping, Type of
shipping & Expected Ship Date. This also calculates the number of required
work force to ship all the orders within a stipulated time. Through packing
list application, labels were printed and pasted in each and every order
with all shipping information.
ROLES & RESPONSIBILITIES:
. Handling Requirement gathering, Analysis, Construction of application,
Coding, Testing & Delivery
. Migrated about 2000+ DTS Packages to SSIS in SQL 2005 / SQL 2008 / SQL
2012 using MSBI
. Created Datasource, Dataset, Report Schedule, Management with
different types of Reports in SSRS
. Managed Cube, Measure, Partition in SSAS for Warehouse Operations
. Created & Managed 2000+ DB Objects, including Tables, View, Synonyms,
stored procedures, functions
. Managed Security Groups, User Levels with DB Authentication
. Created & Managed more than 2500+ Jobs using SQL Server Management
Studio
. Around 900 different reports migrated from Crystal Reports 9 to BOXI
R2 / R3 / R4
. Extracted data from various sources like SQL Server 2005/2008, Oracle,
XML, .CSV, Excel and Text file from Client servers.
. Experience in providing Logging, Error handling by using Event
Handler, and Custom Logging for SSIS Packages.
. Involved to planning and designing SSAS 2008 Cubes and building
attribute relationships for optimal performance of Hierarchies and
Fact Dimensions.
. Involved in Configuration and Deployment of SSRS Reports
. Created dashboards reports for Warehouse operations using SSRS
. The packages created included a variety of transformations, for
example Slowly Changing Dimensions, Look up, Aggregate, Derived
Column, Conditional Split, Fuzzy Lookup, Multicast, and Data
Conversion.
. Working knowledge of .Net Framework 3.5 (VB.NET and C#.NET), IIS 7.0
. Gathered all requirements and implemented the project in 7 warehouse
locations.
. Prepared unit test plans, Release Notes
. Involved in estimation of major functionalities and training the
functionalities of the application to the new comers and responsible
for deployment in client place.
. Managed team of 10 people to handle all phases of SDLC
. Handled Resource Management & Risk Mitigation
. Slashed turnaround time for helpdesk support issues by as much as two
weeks by introducing work order ticketing process and
tracking/documenting recurring technology issues
. Handling metrics data for the portfolio
. Got "Innovator" award for the year 2011 for introducing Lean Progress,
which saves about 550K p.a. for 3M
. Received client accolades many times and got following awards for this
project execution
* Star Performer - Account Level
* Delivery Excellence - Account Level
* Above & Beyond on Call Duty at Organization level
#2 Title EDV
Duration August 2007 - Nov 2007
Client P2ES (P2 Energy Solutions)
Technology VB.Net, Ado.Net, Web Services, Oracle 9.1,
TOAD, OPC Server, Merant Version Manager
Team Size 4
The objective of the project is to validate data using the application EDV
(Electronic Data Validation) and upload data into upstream system (EU).
According to the rights of user level, they can perform the actions like
Approve / Configure / Data Entry. Also User can configure the required
columns, which needs to be displayed in Events / Wells / Equipments using
Data Column Mapping Screen. In EDV user can create rule (by defining
Constants / System Variables / Formulae / LOVs / SQL scripts) for all
events. Validation will be done for each entry and uploaded into EU System.
ROLES AND RESPONSIBILITIES:
. Worked as Project Lead responsible for Maintenance of the application
. Prepared unit test plans, Release Notes
. Involved in estimation and training the functionalities of the
application to the new comers and responsible for deployment in client
place.
. Managed team of 4 people to handle all phases of SDLC
. Responsible for Planning, Work Scheduling and Team Management
. Responsible for test logs and documents using Merant Version Manager
. Developed Code for new Events & Wells to default the Prior Event
. Created Web Services to access EDV Methods from any system
#3 Title ARENA
Duration Nov 2006 - July 2007
Client Kimberly-Clark Corporation
Technology VBScript, SQL Server 2000, VB.Net,
ASP.Net, Ado.Net, Tivoli
Team Size 3
The objective of the project is to load customer's sales (POS), inventory
and forecasting data into ARENA. This is used for demand planning,
Forecasting & Promotion of a product. We need to monitor the jobs and fix
the issues within timeframe and also support the application for a week
with On-Call support for every fourth week.
ROLES AND RESPONSIBILITIES:
. Worked as Onsite Project Lead responsible for Maintenance of the
application
. Managed about 80+ DTS Packages in SQL 2000 to handle POS Data feed
. Managed Security Groups, User Levels with DB Authentication
. Created & Managed all DB Objects for different customer of POS Data
. Used VB Script to handle Job Schedules
. Responsible for Planning, Work Scheduling and Team Management
. Scripted OLAP database backup and scheduled a daily backup using SQL
Server agent job
. Co-ordinating Onsite - Offshore Model
. Successfully moved the application under Managed Service model
. Handled all phases of SDLC approach
#4 Title Customer Information Management System
Duration Mar 2006 - October 2006
Client John Morrell Corporation, USA
Technology Dot Net Framework 1.1 and 2.0 (C#.Net,
ASP.Net, ADO. Net), JavaScript, VBScript,
HTML, SQL Server 2000
Team Size 7
The objective of the project is to Design, develop and implement to
maintain customer information and Sales information of our customers.
Customers' information was maintained in legacy system. We converted this
into Web application and also added Sales information to maintain both
under single unit. Highlight of this system is Work Flow. We have an
approval process based on the user hierarchy level. This approval process
followed to setup new customer, Sales location, Ship To Unit etc.
ROLES AND RESPONSIBILITIES:
. Worked as Project Leader responsible for developing & maintaining
application
. Started with Requirement gathering, Analysis, DB architecture, Code
Design, Unit / System & Integration testing and delivery
. Created generic class Modules and functions to access business layer
and execution of business rules
. Responsible for Planning, Work Scheduling and Team Management
. Managed activities through internal tools such as Etracker, QSmart,
QView for metrics data
. Handled team of 11 people
. Used SQL Server 2000 in Query Analyser, Profiler, DB Trace etc
. Created Stored Procedures, Functions, Views in SQL Server 2000 to
implement business criteria
#5 Title Marketing Tracking System 1.2
Duration July 2004 - Mar 2006
Client John Morrell Corporation, USA
Technology Visual Basic 6.0, COM+, IIS, ASP, Crystal
Reports 8.1, HTML, Java Script, SQL Server
2000
Team Size 5
Marketing Tracking system is primarily to monitor and track the marketing
activities of John Morrell. Marketing tracking system has a unique security
system. There are two types of security systems. One is at module level and
other is Key level. Module level security governs a User's navigation.
Before opening a page, it is verified whether the user has rights to open
the page Key level security is, all the entities (Budget, Log and Deals)
are associated with a specific key combination (Sales Key, Customer Key,
Brand Key, and Product Key). Hence before a User performs any action
affecting the entities, it is verified whether key of the entity fall
within the key levels at which the User is setup.
ROLES AND RESPONSIBILITIES:
. Played as Lead Programmer to handle Requirement gathering, Analysis,
Construction of application, Coding, Testing & Delivery
. Handled team of 6 people and took care of Onsite / Client co-
ordination
. Responsible for creating certain common utility functions and critical
solutions that is very much appreciated by the client.
. Also responsible for maintaining test logs and documents throughout
the project duration.
. Responsible for setting up of development and review environment for
the project at offshore. This involved the installation and
configuring of the IIS web server and installing the components and
restoring of the SQL Databases. To this end, He utilized Visual Studio
Interdev, Visual Basic Tools, Query Analyzer, Profiler, and Crystal
Reports for Code development activities
. Used Etracker to generate metrics and productivity metrics, Qsmart,
Qview for system quality.
. Handled Quality audits for the Project
. Created more than 200 Stored Procedure with business logics in SQL.
. Also used DB2, Linked Server concepts to interact between Mainframe &
MS SQL Server
#6 Title PayStar DF 2.0
Duration November 2003 - July 2004
Client Data Force Systems, USA
Technology Visual Basic 6.0, COM+, IIS, ASP, Crystal
Reports 8.1, Active Reports, HTML, Java
Script, SQL Server 2000
Team Size 6
"PayStar DF" is focused on Staffing specific back office. It is a native N-
tiered web application built using VB, Active Server Pages, COM, XML and
Crystal Reports is used as a Reporting Tool to generate output. This was
mainly focused on US staffing industry, which provides Registering Persons,
Customers, Order, Timecard, Invoices, Payments, Tax Items, Payroll, Billing, Year End Processing & Reports. Direct interaction made with clients of
Data Force Systems and provides solutions to the customer as per need in
time. Totally, 55 reports were generated, in which 20 reports are complex.
Most of the reports were designed using Stored Procedures and based on user
input it will give the output. For example, a single report is designed and
according to the user input like Quarter-Yearly (Or) Half-Yearly (Or)
Yearly report, it generates the output. Main reports are for Tax
Submission, Wages, Tax withheld, Payroll and Billing, Client Lists etc.
ROLES AND RESPONSIBILITIES:
. Played role as Team Member. Used ASP, VB, VBA, SQL Server, COM+,
Crystal Reports, Active Reports to maintain the System
. Majorly involved in gathering user requirements, Analysis & Design
phases, Database Re -Modeling, Reports creation, and also designed &
developed complex Stored procedures, Business Rules and Reports
. Also took care of developing the Quality documents and developing
Project documents.
. Created Stored Procedures, Functions, Views in SQL Server 2000
. Created new reports in Crystal Reports with sub-report & drill down
reports
. Created new pages and modified existing pages for the Change Requests
. Learnt ISO process in Quality
#7 Title Intranet For CPWD
Duration April 2003 - November 2003
Client National Informatics Center (NIC), India
Technology ASP, Crystal Reports 8.1, Visual Basic 6.0,
VBA, IIS, HTML, Java Script, SQL Server 2000
Team Size 4
This Project was done for the client of PAS Technologies, National
Informatics Centre (NIC), Chennai (an ISO 9001 certified organization).
This was used to integrate all the details of Divisional Offices from all
over India. Officials send their Divisional Data to the server and it is
merged with the Server. Officials of Different levels viz. Regional, Zonal,
Circle & Divisional can be able to view the Details Pertaining to them and
below their level. Enhanced performance by introducing stored procedures
for solving complex reports. Client side reports generated through Excel
and Data restricted based upon their clients' Login.
ROLES AND RESPONSIBILITIES:
. Played role as Team Member. Used ASP, VB, VBA, SQL Server, Crystal
Reports to maintain the System
. Majorly involved in gathering user requirements, Analysis & Design
phases, Reports creation,
. Created Stored Procedures, Functions, Views in SQL Server 2000
. Created new reports in Crystal Reports with sub-report & drill down
reports
#8 Title SOSGEN
Duration July 2002 - March 2003
Client PC Thomas College, India
Technology Visual Basic 6.0, ASP, COM+, Crystal Reports
8.1, VBA, IIS, HTML, Java Script, SQL Server
2000
Team Size 4
This was based upon OMR/OCR Concepts. Application Deals with Reading Answer
Sheets, Comparing Answers, and Scoring, Ranking, Student Admission, Fees
Collection, Relieving Students, Attendance, Hostel Admission, Fees, Room
Admission, Change of Rooms, Reports Generation and students can view their
Results in the Intranet. In this, nearly 22 reports were designed and
officials can view or take printout as per their requirement. User
Interface was designed to give necessary input. So that, they can take
report for any particular period. Core reports are Rank List, Mark sheets,
Toppers and Losers (Classwise, Sectionwise and Groupwise) etc.
ROLES AND RESPONSIBILITIES:
. Played role as Team Member. Used ASP, VB, SQL Server, COM+, Crystal
Reports
. Majorly involved in gathering user requirements, Analysis & Design
phases, Reports creation
. Learnt new technology of OMR / OCR concepts and implemented in the
system
. Created Stored Procedures, Functions, Views in SQL Server 2000
. Created new reports in Crystal Reports with sub-report & drill down
reports
. Handled implementation at client location and made this as a Product
. Also took care of developing the Quality documents and developing
Project documents.
#9 Title SWARNAM (Jeweler System)
Duration February 2002 - June 2002
Location PAS Technologies, India
Technology Visual Basic 6.0, VBA, ASP, Crystal Reports
8.1, HTML, Java Script, SQL Server 2000
Experience in the 5 Months
Project
Swarnam is a Proof of Concept which was developed particularly for
jewelers.. This handles the functionality of the Jewellery Maintenance. It
handles Purchase of Old Gold, Sales (Jewels, Silver, Diamond), Credit
Sales, Exchange of Old Gold, Accounts details, Utilities, Picture
Cataloguing, Reports Generation (DOS Based / Crystal Reports).
ROLES AND RESPONSIBILITIES:
. Played as a team member and learnt on using ActiveX Controls, COM
methodologies
. Created Stored Procedures, Functions, Views in SQL Server 2000
. Created new reports in Crystal Reports
. Worked in Unit Testing and interacting with Quality team
#10 Title Hospital Management System
Duration June 2001 - January 2002
Location PAS Technologies, India
Technology Visual Basic 6.0, VBA, ASP, COM+, MTS, HTML,
Java Script, Oracle 7.1
Team Size 11
This Project was done for a hospital to maintain Patient records. It was
developed in Client / Server model. Following are the main modules in this
system.
o Reception / Nursing
o Cash
o Stock-Office
o Employees
o Out Patient / Reports
Users can be able to find Doctor's schedule / visit. Reports were generated
in DOS.
ROLES AND RESPONSIBILITIES:
. Collecting & Analyzing URD
. Involved in Application Design, Database design, Coding, Testing &
Implementation.
. Developed business rules using COM Architecture and Stored Procedures
Contact this candidate