.Net Sql Data Server Application Sales Marketing
Resume:
Venkateswaran Periyasamy
*****.*****@*****.***
Experience& Education Summary
Near to 12 years of IT Experience in the Analysis, Design, Architect, Development and Implementation.
Currently Working for Wipro Technologies from June 2005 to Present.
Master of Computer Applications (MCA), University of Madras, Chennai, April 1998.
Bachelors of Computer Science (B.Sc), University of Madras, Chennai, April 1995.
Strong technical knowledge in SSIS, SSRS, SQL-SERVER 7/2000/2005/2008 and Worked on several Data warehouse Projects and designed OLAP/OLTP databases.
Successfully completed several ASP.Net Projects using C# and VB.Net
Technical Skills
Operating System Windows 9x/NT 4.0/2000/2003, Linux, UNIX
Languages C#
GUI Visual Basic 6.0, VB.Net
Internet Technologies ASP 3.0, ASP.NET, Java Script, VBScript
Back-End MS SQL Server 7.0/2000/2005/2008, MS Accesses
Middleware COM, DCOM
Reporting Tool Crystal Reports 10.0,SSRS
Data Warehousing MS Business Intelligence (SSIS, SSAS), Data Stage, Microstrategy
Data Modeling Erwin, Visio, EA
Projects Handled:
Client: Hospital Corporation of America, TN Apr ’09- Present SQL Server 2008/SSIS/SSRS/C#
An HPG DWH ETL project includes different source Feeds like FDB, Home, Genesis, Upside, RAFT and Rx Daily Data Feeds. The ETL jobs will take care of loading Data in to DWH and maintain the history with SCD to Type 6/Hybrid with End to End Auditing. We designed the package differently for each feed (Delta, Full and DB to DB Load). The Jobs are scheduled in SQL Agent and each feeds have been scheduled to different run frequency like Daily and Weekly.
Responsibilities:
• Involved in Analyzing the different Source and Target System.
• Responsible for creating Technical Design document and Requirement Specification Document
• Designed the Package differently for each feed and developed ETL packages for moving data into warehouse using SSIS2008.
• Packages are tested using the End to End Auditing built inside the package and Schema manually.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Deploy SSIS Package into Production/QA/INT and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified job status to DWH data users.
• Imported data from text files and excel spread sheets into SQL Server 2008 database using SSIS package.
• Used Query Execution Plan, Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Used Database Engine Tuning Advisor tool for analyzing the Procedures and Queries for effective Indexes and Statistics.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Involved in scheduling, creating snapshots and subscriptions for the reports.
• Responsible for writing SQL Agent jobs to Schedule the packages.
• Responsible for monitoring all the Jobs scheduled in the Prod/QA/INT Environment. To do this task, I have design and Automated the job status package to monitor the package and send info on the job status.
• C# Script is used for coding the Script component and Script task (SSIS 2008)
Client: Target Corporation, MN May ’08- Jan ‘09 SQL Server 2005/SSIS/SSRS/VB.Net
C-STAR main purpose is to find the Card defaulters new phone numbers for the collection purpose. The Dialer and Recovery Management system will be using the C-STAR application for skip tracing the phone numbers. The System will be storing the last seven years data at any point of time. Report (Metrics) will be generated based on the hits and Misses. The Misses data will be send to skip trace vendors for getting the new numbers. The Hits file will be consumed back by the collection systems
Responsibilities:
• Analyzed the System and determined the business requirement needs.
• Responsible for creating Technical Design document and Requirement Specification Document
• Involved in Design, Architecture of the System and worked as an onsite Coordinator.
• Developed ETL packages for moving data from DB to DB using SSIS2005.
• Packages are tested using the End to End Auditing built inside the package.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs.
• Prepared the SSIS Package Deployment and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Used Query Execution Plan, Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Used Database Engine Tuning Advisor tool for analyzing the Procedures and Queries for effective Indexes and Statistics.
• Worked with T-SQL to create Tables and stored Procedures.
• Worked on Parameterized Reports and Sub Reports.
• Responsible for writing SQL Agent jobs to Schedule the packages.
• VB.NET Script is used for coding the Script task (SSIS 2005)
Client: Microsoft Corp., Redmond Apr ’06- Nov ‘07
SSIS 2005/ SQL Server 2000/5/Epiphany/ASP.NET/C#
EMMA((Enterprise Marketing Management Application) Sustenance handles all the Production issues concerning US, Worldwide, Suppression List, Paddington and Security Census Marts. SSIS/Epiphany will load data from different sources to the Marketing DB. It involves resolving all the issues of User support and Production support and business solution team. The issues might Require Data Analysis and Issue Resolution and more importantly delivering Quick Engineering Fixes (QFE)/Service Packs/Taxonomy build for every year that requires Dev/Test/Release activities.
Responsibilities:
• Involved in writing the Technical design document.
• Involved in migrating the Epiphany ETL extractors to SSIS 2005 Packages and OLAP (Snow Flake Schema) database.
• Packages are tested using row count logs and Schema manually.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Prepared the SSIS Package/Epiphany extractor deployment and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages/Epiphany extractors and 24/7 supports provided for the ETL operations. In case of failure, it will be notified to the marketing users
• Used Query Execution Plan, Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Used Database Engine Tuning Advisor tool for analyzing the Procedures and Queries for effective Indexes and Statistics.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Involved in scheduling, creating snapshots and subscriptions for the reports.
• Responsible for writing SQL Agent jobs to Schedule the packages.
• VB.NET Script is used for coding the Script task (SSIS 2005)
• Developed ASP.NET pages for maintaining the Marketing users.
Client: Microsoft Corp., Redmond Dec ’05- Apr ‘04
SQL Server 2005/SSIS/C# /ASP.Net
Role Based Reporting Application helps Sales personnel (Account Manager’s, Sales Managers, Partner Account Managers, Specialists, Specialist Managers) belonging to different roles to view a Summary of their Sales activities. I have worked extensively in developing packages and procedures for transformation, by interacting with client based on OLAP architecture. ETL (PAM Dashboard) Refresh through SSIS, which pulls data from various external sources, transforms the data and moves into the Staging table. This Staging Table Database was copied to Target (Production). The UI Part helps in saving the user preferences, the next time the user logs in he/she will be viewing the last saved data.
Responsibilities:
• Involved in designing the package, normalizing the table in OLAP (Snow flake schema).
• Developed ETL packages for moving data from DB, Web Services to DB using SSIS2005.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs.
• Prepared the SSIS Package Deployment and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Used Query Execution Plan, Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Used Database Engine Tuning Advisor tool for analyzing the Procedures and Queries for effective Indexes and Statistics.
• Worked with T-SQL to create Tables and stored Procedures.
• Worked on Parameterized Reports and Sub Reports.
• Responsible for writing SQL Agent jobs to Schedule the packages.
• Developed ASP.NET pages to store the user preference regions for viewing the report.
• Configured the IIS on Windows Server 2003 and deployed ASP.Net build.
Client: Microsoft Corp., Redmond Jun ’05- Dec ‘05
SQL Server 2000/5/C# /ASP.Net/VC++
SSGM on Dashboard Reporting application helps in monitoring the status of the health of MSN Platform Services infrastructure. The application provides reports on performance counters for the Platform Services servers in near real-time, and presents visual alerts for any anomalies observed in the data, based on pre-defined threshold values. The application has a multi-layered architecture and an extensible framework. Collection Agent is the key component that runs on each server to collect the performance counter data and store into the database.
Responsibilities:
• Developed ASP.NET Pages to support Administration UI, which is used to set system wide configuration settings.
• Dashboard UI, which allows users to view the server performance dashboard reports, with features like personalization of the default view, drill-down views, graphical and tabular views, basic/advance filters, toolbar customization to customize the graphs on home page
• Involved in designing the OLTP schema for the system.
• Responsible for Unit testing the ASP.NET pages and Stored Procedures.
• Used Query Execution Plan, Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Used Database Engine Tuning Advisor tool for analyzing the Procedures and Queries for effective Indexes and Statistics.
• Worked with T-SQL to create Tables and stored Procedures.
• Configured the IIS on Windows Server 2003 and deployed ASP.Net build.
Client: SWS America Information Systems Inc., TX Jul ’04- Jun ‘05
SQL Server 2000/C# /ASP.Net/VB.NET/Crystal Reports
IPS(Integrated Procurement System) is time-phased priority planning technique that calculates material requirements and schedules supply to meet changing demand across products in one or more plant.
Material Requirement Planning (MRP) is the core of IPS. The system facilitates the user to plan material requirement in advance for a specified number of weeks and suggests Purchase Orders based on the Master Product Schedule, Inventory Levels, Supplier lead-time and other related information. Other features of the software include interface with IHS-CAD, C&C System, and EDI through text import/exports, multi-currency and multilingual support. Main modules of system are Planning, Purchase, Receipt, Issue, BOM, Multi-Site Material Consolidation, MIS and Supplier website.
BOM (Bill of Material) data will be generated from IHS CAD and set G-BOM Servers in JAPAN SEWS Design Engineering feed and maintains CAD data NDMC, bowling green; KY.G-BOM data will then be verified by SWS DE and sent back to BOM Server at SEWS as G-BOM files.
MCS Server will be treated as BOM servers and it will receive G-BOM files multiple times a day as automatic schedules or DE can download G-BOM files on demand by a web interface already functional and built by SWS from G-BOM servers.
DE users will maintain a part substitution Master using the new BOM system to substitute the material in the BOM files, this gives the benefit to update all the SEWS systems(Factory MCS,C&C and other SEWS systems) by same information rather than updating each system independently and notifying the each involved user. The Number of files which is received in a day will be get uploaded in the Concerned table after applying the business logic to it. For this we have developed Window services logic to pick the file every 15 minutes and it will take a backup of files on daily basis. After updating of data, the files will be get deleted from G-BOM server folders.
Responsibilities:
• Involved in writing the Technical design document.
• Developed ASP.NET pages for different modules (Planning, Purchase, Receipt, Issue, BOM, Multi-Site Material Consolidation) on the need basis.
• Used Query Execution Plan, Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Worked with T-SQL to create Tables and stored Procedures.
• Worked on Parameterized Reports and Sub Reports.
• Developed Generalized Lookup component, which was used across the ASP.NET project
• Configured the IIS on Windows Server 2003 and deployed ASP.Net build.
Client: GlobalVantEdge, INDIA Apr ’03- May ‘04
SQL Server 2000/VB 6.0/VB.NET/ASP.NET/Davox Dialer/ Mainframe Replicator
Falcon Integrator-GUI application will helps to reduce the agents work less, which ultimately increases the number of calls per hour and the productivity increase. The Davox Dialer throws call to the customer and in turn customer will document the result of the call in the Mainframe Replicator and the contacts should be got captured. So we plan to integrate the three entities into a single application. If agents picks a call he has to terminate the call in dialer, documenting the Mainframe replicator at the end of call, and capturing the Contacts data to evaluate the agents effectiveness for VIC. The above said Problem is solved by Integrator-GUI. The first thing it will talk to the Mainframe for Documentation and secondly it will scrape the required information from the Mainframe Replicator and finally it will terminate the Call in the Davox Dialer by using the (Com Technology).If new call is thrown by dialer the Integrator-GUI will automatically pull the particular account in the Dialer.
This application helps in
Consistent and Error Free Documentation in Mainframe Replicator.
Reduces Call time
Increase in Productivity
Capturing Data and Evaluating user Performance(VIC)
Helps MIS People for Evaluate the Overall Performance of the Portfolio.
E-Pay Automation is needed, to help the Employees of the GV, which provides the information regarding their pay details. The E-pay Automation is mainly divided into two parts, the first web (Intranet) part and the second E-pay Upload (Windows) based. The E-pay upload will populate the needed data from Payroll and HR databases and it will encrypt the Data and get stored in the E-pay Database. By using the Intranet Web application users can able to view their salary slip whenever they need. The Needed Security has been embedded in the web part; so that users have been restricted from Viewing others Pay slip.
This Inbound Tracker Application use to find the effectiveness of Source of call whether it may be through Letter, Blaster, Credit Report, Message Left, Transferred calls. By using the Application we can able to find the Effectiveness of the user. Application will pull account from the mainframe using the following options. They are Phone number SSN number, Client Reference Number and by Account Number. It will scrape the Promise account from the Mainframe Replicator by using the Macro. The Accounts will be get checked whether it has been broken or kept from the Main frame Screen by using the Excel sheet. The Report will be generated using the Excel sheet with Graph Format and in data Format.
Responsibilities:
• Developed ASP.NET pages for E-pay and Inbound tracker
• Developed VB 6 application for Falcon Integrator
• Used Query Execution Plan, Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Worked with T-SQL to create Tables and stored Procedures.
• Worked on Excel Reports, Generated by the .NET Application
• Developed the Interface for interacting with the DAVOX dialer.
• Configured the IIS on Windows Server 2003 and deployed ASP.Net build.
Client: GE Capital International Services, INDIA Dec ’02- Mar ‘03
SQL Server 2000/VB 6.0/ASP
This Application Support Group (ASG) takes care of the applications, which are running at present in GE Capital International Services, India. Whenever the user of any process faces any problem he/she will lock a ticket against the problem at the Help Desk. Based on the problem the tickets will be dispatched to the corresponding team like Hardware Support Group, Network Management Group, Application Support Group, etc. using the CRM tool Clarify. As soon as it comes to our pool we have to communicate with the client and check it out the application. Based on the ticket priority we have to identify the problem and solve it. Here we have to go through the application, which was developed by someone, and study the problem as well as the application and the flow in an efficient and effective manner.
As a System Consultant, was responsible for the following:
System study, preparation of documents like problem definition and possible cause with solutions.
Analyzing and writing Stored procedures if necessary
Analyzing and coding of the modules using Visual Basic 6.0 if necessary
Taking backups of programs coded and test plans.
Client: [B.N.T Connections Ltd, UNITEX, GITEX]- INDIA,
Korea Lanka Garments, Sri Lanka Favorite Group, SKYTRACK - Sri Lanka,
Tang Garments-Mauritius,
Oceanic – Gems Garments, Dubai Jun ’01- Dec ‘02
VB 6.0/ SQL-Server 7.0/ASP/JavaScript/ Crystal reports 8.0/ True DB Grid 7.0
GARMEX is the ERP Product of PC INDIA targeting complete automation of all processes of Medium Sized Garment Companies. GARMEX has been implemented in about 10 sites spread over 4 countries. The Product has an intelligent mechanism based on PUSH technology for monitoring daily activities and triggering of alert messages based on performance or Non-performance of Activities. The Product has an MS – Exchange Server, Outlook part through which all approvals for activities from managing hierarchy is automatically sent and received through outlook mail over the Internet. The product also includes optional services like web site managing software through which the buyers and shippers interact and also a Supply Chain Management System for Raw Material Procurement Tracking.
ASP Module:
The ASP Module is almost in final stage so that there should be a direct communication between the shipper & buyer. If you take a Big ERP we should link the two entities belong to this. So there must be a direct communication between the Shipper and the Buyer. If the company gets any Confirmation order it directly contacts the Shipper for the Raw materials. The order can be placed directly on the net. The ordering includes the raw Materials colors, Fabric Type, Quantity needed and the Payment details etc.
PRDayEndProcess Application will integrate the Merchandising Module with the Purchase Module.
The Material needed for the buyer will automatically take to the Purchase Module by running this Application. If the item needed by the Buyer is already in stock (Inventory), then it will block the needed Quantity for the particular order, and then for the remaining quantity it will raise the purchase order. From this application a Mail will be sent through outlook to the purchase department for Approval. Autosnd application will send mail to the consumers about the new updates on Garmex ERP.
Responsibilities:
• Developed ASP pages for buyer and shipper modules
• Developed VB 6 forms for most of the modules.
• Used Query Execution Plan, Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Worked with T-SQL to create Tables and stored Procedures.
• Worked on Crystal Reports and developed parameterized reports and sub reports.
• Developed the module integrating PRDayEndProcess exe.
Contact this candidate