Application

Gopinathan from India applies for Blue Card Germany

Engineering professionals not elsewhere classified

Personal data:

For personal data please contact us
with the following Applicants-ID: 10201

Profession:

Name of profession: Engineering professionals not elsewhere classified Name of latest business sector: Software Industry Latest occupation/title: IT Consultant Latest main activities: Involve in analysis, design, coding, testing, deployment and maintenance of the Business Intelligence application

Education:

Completed education: bachelor Title or Qualification: BE Specialisation: Information Technology Additional trainings:

Preferred countries:

1. Preferred country | region / city: Germany | 2. Preferred country | region / city: United Kingdom | 3. Preferred country | region / city: Denmark |

Language skills:

1. Language skills: english => excellent 2. Language skills: 3. Language skills: =>

Personal note /detailed application:

Core Mission:-
To be known as a reputed Software Professional who adds value to the Client, their businesses and reduce the operating costs.

Educational Qualifications

• B.E (Information Technology) from Periyar University, With 80%( Distinction)
• HSC from G.H.S.S, with 91%.
• SSLC from G.H.S.S, with 92%.

Experience Summary

? 7+ years of experience in MSBI (SSIS, SSRS and SSAS) technologies.
? 1+ year On-Site Experience (USA, UK)
? Executed various domain (Energy & Utilities, Manufacturing, Banking and Investment) projects
? Experience in creating Stored Procedures, Views, User Defined Functions, Indexes, Jobs and DBA activities.
? Involved in Data Base Design
? DB performance tuning and partitioning
? Hands on experience in writing and debugging stored procedures and triggers, troubleshooting database issues.
? Involved in all the stages of SDLC process.
? Knowledgeable on UML and Design Patterns
? Client Interaction Skills and Team management skills.
? Have flair for working quickly and under high pressure, while producing results beyond expectations.
? Good communication and time management skills.

SNo. Company Name From To
1. Logica (now part of CGI) May 2010 Till Date
2. AXA Group Solutions Mar 2009 May 2010
3. WIPRO Technologies Oct 2006 Feb 2009
4 Amba Research (I) Pvt Ltd Feb 2006 Sep 2006

Technical Experience Summary Table

Technology Tools
Data Warehousing SQL Server Integration Services(SSIS), SSRS, SSAS,DTS
Databases SQL Server 2000/2005/2008, Oracle 9i
Development/Productivity Tools Visual Studio.NET
E-Com Frameworks/Web Technologies ASP.NET
Functional Areas Content Management, Supply Chain Management
Programming Languages C#
Software Engineering Methodologies/Tools/Technologies .NET Framework, CVS, MS Visual SourceSafe
Verticals Manufacturing, Securities, Utilities



Certifications
Microsoft Certified Technology Specialist (MCTS:070-445, 070-431)
Microsoft Certified Application Developer (MCAD)


Papers Published

Paper Published Publishing channel
SSIS - Performance Tuning white paper K-Net in WIPRO Technologies
SQL Server 2008 Overview – White Paper AXA, KM Portal


Key Projects


1. LMR

Description LMR (Local Management Reporting) system facilitates management reporting from all Logica Group applications and some local specific applications. In LMR these are called “Domains”. LMR is able to serve a wide variety of users, including Finance, Sales, Delivery, HR and General Management, as well as project managers. It will be customized for each country.
Operating System(s) Windows-XP
Skills SQL Server 2008, MSBI (SSIS,SSRS,SSAS)
Environment SQL Server 2008 - SSIS - SQL Server Integration Services, Cognos 8
Client Logica
Role Service Lead
Contribution * Requirement gathering and analysis
* Attending client meetings
* Preparing Technical Design Document
* Guiding the team members in terms of sharing the SSIS knowledge, providing best practices tips and also resolving their technical queries.
* Involved in Cube design using SSAS
* Designing the SSIS packages
* Developed, modified and optimized complex queries for data retrieval and modification.
* Creating the SQL Server jobs and schedule the packages
*Writing new stored procedures, modifying existing ones and tuning them for optimal performance.
* Involved in developing/deploying the reports using SSRS
* VSS (Configuration Tool) Management
* Involved in performance tuning


2. GCGMKTG_DB

Description Keep It Running services for GCG Marketing Data Store. Kodak uses this system to manage customer's information around the globe. There are different modules in this application, such as i. Accounts ii.Products iii. IBase_Service iv. DI Migration v. Contacts cleansing vi. Contact Permissions.
Operating System(s) Windows-XP
Skills SQL Server 2005, SQL BI (SSRS, SSIS, SSAS)
Environment SQL Server 2005 - SSIS - SQL Server Integration Services, SSRS, SSAS, DTS
Client Eastman Kodak
Role Senior Developer
Contribution *Requirement gathering and analysis
*Attending client meetings
*Preparing Technical Specs.
* Designing the SSIS packages
*Created views, indexes, triggers.
*Created User Defined Functions to perform frequently used calculations or expressions.
*Developed, modified and optimized complex queries for data retrieval and modification.
*Writing new stored procedures, modifying existing ones and tuning them for optimal performance.
Tuned T-SQL queries for optimizing the performance.
Worked extensively on SSIS packages designs for Import/Export from various data sources and schedule the jobs.
* Used SSIS (SQL Server Integration Services) for the data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
*Migration of legacy data and tables to SQL Server using SSIS.
*Create Complex SSIS packages utilizing data flow, script, slowly changing dimension and other tasks to generate daily calculation data.
* Involved in developing/deploying the reports using SSRS

3. Global Insight
Description It is a Business Intelligence solution for HP ESS SC Organization to integrate, analyze and provide actionable information (including reports and alerts) to make better business decisions and assist in forecasting, trend analysis and decision support.
Role Senior Developer
Operating System(s) Windows Server 2003
Environment SQL Server 2005, SSIS, SSRS, SSAS, PPS, MOSS, VSS 6.0
Client HP
Contribution * Involved in analyzing and gathering business requirements
* Involved in creating the Technical Specs.
*Created views, indexes, triggers.
*Created User Defined Functions to perform frequently used calculations or expressions.
*Developed, modified and optimized complex queries for data retrieval and modification.
*Writing new stored procedures, modifying existing ones and tuning them for optimal performance.
Tuned T-SQL queries for optimizing the performance.
Worked extensively on SSIS packages designs for Import/Export from various data sources and schedule the jobs.
* Used SSIS (SQL Server Integration Services) for the data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
*Migration of legacy data and tables to SQL Server using SSIS.
*Create Complex SSIS packages utilizing data flow, script, slowly changing dimension and other tasks to generate daily calculation data.
*In charge for maintenance and deployment of SSIS packages into the databases.
* Involved in cube design using SSAS
* Used reporting services (SSRS) to create and schedule the reports required.
* Unit Testing

4. CAT
Description This tool has been designed by using SSIS Integration Services, SQL Server and MS Access technology. It has designed to cater for all RKS standard conversion templates used for the AAAM Amsterdam Funds & Investec Funds. These funds are converted onto the Enterprise RKS platform. Investment types are Equity, Fixed Income, Foreign Exchange, SWAPS and Futures. There are multiple RKS conversion templates that require source equivalent extract files (CSV format), 7 of which are applicable to both Amsterdam and Investec portfolios; i. Settled Cash Balances ii. Traded Security Positions iii. Traded Security Positions OTC Options iv. Traded Security Positions Warrants Rights v. Open Purchases and Sales vi. Open Spot / Forward Foreign Exchange vii. Dividends Gone “Ex” Not Yet Received. These are converted into the following RKS standard conversion templates: i. Data Template Security Contribution ii. Data Template Cash Contribution / Withdrawal iii. Data Template Open Spot_Forward Foreign Exchange iv. Data Template Purchase_Sale v. Data Template Warrants_Rights vi. Data Template Options vii. Data Template Dividend Data
Role Senior Developer
Client State Street
Operating System(s) Windows-XP
Domain Securities
Environment SSIS (Business Intelligence), SQL Server 2005, MS Access 2000, Windows XP, VSS 6.0, ASP.Net, C#
Contribution * Involved in analyzing and gathering business requirements
* Involved in creating the Technical Specs.
*Created views, indexes, triggers and roles.
*Developed, modified and optimized complex queries for data retrieval and modification.
*Writing new stored procedures, modifying existing ones and tuning them for optimal performance.
Tuned T-SQL queries for optimizing the performance.
Worked extensively on SSIS packages designs for Import/Export from various data sources and schedule the jobs.
* Used SSIS (SQL Server Integration Services) for the data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
*Migration of legacy data and tables to SQL Server using SSIS.
*Create Complex SSIS packages utilizing data flow, script, slowly changing dimension and other tasks to generate daily calculation data.
*In charge for maintenance and deployment of SSIS packages into the databases.
* Used reporting services (SSRS) to create and schedule the reports required.
* Unit Testing

5. AAPO - ETL Middleware Solution
Description The main objective of this project is to facilitate data flow between APO system (GSAP) and Legacy Systems (P71 and JDE). There are two major classifications, such as 1. Inbound Interface 2. Outbound Interface. 1. Inbound Interface (Legacy Systems to APO): • Pull the CSV files from the Inbound Legacy System file share • Store the data from the CSV format file to input staging tables of the ETL Middle ware Staging Database • Perform the data validation, mapping, cleansing and the business logic • Convert the data from output staging tables to IDOC format. • Using the SFTP adapter push the IDOC format files to the Inbound APO IDOC format file share. 2. Outbound Interface (APO to Legacy Systems): • Pull the IDOC files from the Outbound APO IDOC format file share • Store the data from the APO IDOC format file to input staging tables of the ETL Middle ware Staging Database • Perform the data validation, mapping, cleansing and the business logic • Convert the data from output staging tables to CSV format. Using the SFTP adapter push the CSV format files to the Outbound Legacy System File Share
Client Shell
Role Senior Developer
Operating System(s) Windows 2003 Server
Domain Energy & Utilities
Environment SSIS (Business Intelligence), DTS, SQL Server 2005, Windows XP, VSS 6.0
Contribution * Involved in creating the Technical Specs.
*Created views, indexes, triggers and roles.
*Created User Defined Functions to perform frequently used calculations or expressions.
*Developed, modified and optimized complex queries for data retrieval and modification.
*Writing new stored procedures, modifying existing ones and tuning them for optimal performance.
Tuned T-SQL queries for optimizing the performance.
Worked extensively on SSIS packages designs for Import/Export from various data sources and schedule the jobs.
* Used SSIS (SQL Server Integration Services) for the data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
*Migration of legacy data and tables to SQL Server using SSIS.
*Create Complex SSIS packages utilizing data flow, script, slowly changing dimension and other tasks to generate daily calculation data.
*In charge for maintenance and deployment of SSIS packages into the databases.
* Used reporting services (SSRS) to create and schedule the reports required.
* Unit Testing
Client Shell Petrochemicals



6. Visitor Tracking System
Description Visitor Tracking System is a package that automates the inflows and outflows of the factory at the gate for the internal security. This has been developed as two modules named as visitor flows and truck flows. Visitor modules keep tracks the visitor information and the truck module maintains the truck details, such as destination of loaded goods.
Client Saint Gobain
Role Developer
Domain Manufacturing
Operating System(s) Windows-XP
Skills Oracle 9i,Content Management,C#,.NET Framework
Environment ASP.NET, C#, Oracle 9i
Contribution • Created Stored Procedures, functions and triggers • Unit Testing

7. Field Force Incentive System
Description FFIS is a project done for Hindustan Lever Limited, which is Number one FMCG Promoter, listed top in the Best Indian Private Companies. The project has been developed for them to ease the calculation and analysis of the employee performance. Each Month all employee are set with some target and according to their achievements they are recommended by this system for incentive. The incentive is calculated Monthly, Quarterly and annually. This project apart from calculating the incentive will also give report to Area Sales Manager, Regional Sales Manager and other top official with the reports of Performance, Growth and comparison.
Client HLL
Role Developer
Domain Manufacturing
Operating System(s) Windows-XP
Skills SQL Server 2000,ASP.NET,C#,.NET Framework
Environment ASP.NET, C#, SQL SERVER 2000
Contribution • Created Stored Procedures, functions and triggers • Unit Testing
Personal Details

D.O.B 07-Jun-1983
Sex & Martial Status Male & Single
Nationality Indian
Hobbies Playing Chess, Cricket, Swimming, Listening Music
Passport No E8238449
Visa Details US (L1 Visa) and UK (Business Visa/ Work Permit Visa)

 

Facebook

Google Plus