PROFESSIONAL SUMMARY:

• A software professional having 11+ years of extensive experience in all phases of Software Development Life Cycle (SDLC) conceptualizing business needs and translating them into viable technical solutions. Having strong communication, interpersonal and organizational skills.
• Experience in both application development and application maintenance services including OLTP, OLAP, CRM and COTS systems. Primarily experienced in various development, implementation and maintenance of databases MS SQL and Oracle (PL/SQL) with Business Intelligence tools.
• Commendable skills in various information systems like transaction processing systems, decision support systems and database management systems.
• Strong knowledge in SDLC life - cycle phases including application development and maintenance processes.
• Experience in Automotive and Manufacturing Services business domains.
• Experienced in working with different development methodologies like Waterfall, Prototype model, Iterative, Agile (Scrum).
• Experience in development and maintenance of Oracle and PL/SQL programming.
• Expertise in the development, implementation and maintenance of SQL Server 2000/2005/2008/2012 including the MS SQL Server suite of products like SSIS, SSRS and SSAS.
• Highly proficient in all aspects of database implementation including development, normalization, de-normalization and performance tuning.
• Expert in T-SQL and PL/SQL Programming skills.
• Expert in Data Analysis, Data Migration and Integration of disparate systems
• Experience implementing and managing Data warehouse and Data mart applications and reporting tools SAP Business Objects XI and Web Intelligence.
• Experience in various facets of ETL: Requirement Elicitation, Data Modeling, ETL Design, Implementation and Reporting Solutions.
• Experience in managing applications hosted in Unix/Linux platforms with shell programming.
• Experience in database applications in Stored Procedures, Functions, Triggers and developing other DB objects in MS SQL Server, Oracle, My SQL and IBM DB2.
• Experience in performing ETL / DTS operations into OLTP and OLAP databases from heterogeneous databases using SSIS, BCP and SQLCMD utility.
• Hands on experience in performing various SSIS data transformation tasks like Script Task & Component, Look-ups, Fuzzy Look-ups, Slowly Changing Dimension, Merge Join, Conditional Splits and Error Handlers.
• Experience in create, deploy and manage reports in SSRS and Business Objects XI.
• Experience in designing cubes with dimension and fact tables using star or snowflake schema in OLAP warehouse using SSAS.
• Knowledge on Big Data eco-system like HDFS, MapReducev2, Pig, Hive and HBase. Having good knowledge in Object-oriented programming and its concepts.
• Experience in developing and managing Web and Windows platform applications of Microsoft technologies like VB.Net, C#, ASP.Net, VB 6.0, VBA, Classic ASP and COM components and COTS products.
• Knowledge in application build and deployment tools like Ant, Build Farm, RepliWeb, etc.
• Knowledge in configuration management and change request tracking tools from Rational Suites.
• Expertise in team handling, direct client interaction and offshore & onsite team coordination.
• Production Support, Maintenance Service and Process Knowledge
• Excellent knowledge and working experience in Incident Management and Problem Management with ITIL processes.
• Good knowledge on production support and maintenance service levels performance measurement like SLA and KPI.
• Managed critical incidents/outages, incident alerting process, resolution/recovery to the incidents, RCA and incident closure.
• Developed monthly/quarterly/yearly SLA dashboard reports to client and senior executives.
• Knowledge in working IT service management tools like BMC Remedy and Peregrine.
• Excellent knowledge on software maintenance categories Adaptive, Perfective, Corrective and Preventive.
• Knowledge about Sarbanes-Oxley (SOX) Act and followed in all our software maintenance activities and generated reports for quarterly external auditing.
• Experience in supporting enterprise level infrastructure and application Technology Uplift activities.
• Experience in preparing incident and change management reports using Logi Analytics (LogiXML) reporting tool for application team to comply the SLA/KPI and for better tracking the incidents and changes.
• Developed Disaster Recovery documents and Business Continuity matrix for production support applications.
• Participated in quarterly/annual Disaster Recovery exercise for production and DR data centers.

TECHNICAL SKILLS:

Systems worked on: OLTP, OLAP, Data warehouse systems, CRM and COTS

Databases worked on: Microsoft SQL Server, Oracle, DB2 and MySQL

Business Intelligence: SSIS, SSRS, SSAS, SAP Business Objects XI, Web Intelligence, Informatica, Redwood and Self-Service BI.

Operating Systems: Microsoft Windows, Unix, Linux platforms, Shell programming

Programming Languages: T-SQL, PL/SQL, VB.NET, C#, ASP.NET, VB and Core Java

Web Technologies: HTML, XML, CSS, JavaScript, VBScript, AJAX, Web Service and jQuery

Web Servers: Microsoft IIS, Oracle Web Logic, Apache Tomcat

Office Suites: MS Office, MS Project and MS Visio

Other IDE/Tools: BIDS, SSDT, Toad for Oracle, WinSQL for DB2, Visual Studio

PROFESSIONAL EXPERIENCE:

Confidential, CA

Technology Lead/Distributed & COTS Lead

Environment: MS SQL Server, Oracle, SSIS, SSRS, SSAS, BO XI, DB2, MySQL, VB.NET, C#, ASP.NET, VB, ASP, COM, XML, .NET Web service, Oracle Web Logic, IBM MQ

Responsibilities:

• Performed requirement gathering with business groups and transform into Business Requirement Document (BRDs)
• Developed high-level and detail-level specification document for the requirements
• Created detailed level design document with AS-IS and TO-BE models
• Conduct meetings with various stakeholders of the project for the BRD and Design sign-off before start the development
• Responsible for providing estimates and schedule for the requirements and manage the deliverable on time with quality.
• Defined coding standards, created templates for database objects development
• Created SSIS packages for data importing and parsing etc. Packages include business logic for the transformation and load with details logging and exception handling.
• Created SSIS packages using derived columns, condition split, term extraction, aggregate and etc. to generate underlying data for the reports.
• Designed data model and SSAS cube for DDOA reporting and dashboard reporting for executives.
• Performed database administration and migration activities, includes developing database objects, reviewing the objects that was developed by team.
• Developed scripts to perform the data migration activity from legacy dealer daily system to one dealer daily during the dealer migration.
• Developed oracle procedures and packages to provide asset data that is collected by Discovery component of BDNA.
• Designed data model to store the monthly asset data for various reporting needs of Asset Management team. The data will be stored for rolling period of 36 months and later it will archived.
• Automated archival batch script in CMD shell and scheduled as part of monthly data load.
• Developed SSIS packages to ETL the asset data collected by Discovery and Normalize into the TMS custom data mart for reporting.
• Involved in performance tuning using SQL execution plan and indexes.
• Created Standard Operating Procedure (SOP) document to capture the monthly data load, Technopedia update and data mart load for reporting.
• Involved in testing, monitoring, managing, and validating the activities in different environments
• Performed code build and release activities with proper version controlling
• Managed team on their day-to-day activities and performance evaluation
• Conduct regular weekly governance meetings with client to discuss about critical open issues, resolutions, enhancements and review the plan and next steps.
• Supported user acceptance testing on each and every major release that goes to production
• Followed SOX compliance on every development and change request initiated by business. This makes sure that created appropriate documents with approval and no impact to production systems by rolling out the development and change request
• Attended Daily Stand-up meeting to review the tasks (completed, in-progress and pending).
• As part of the agile methodology team has to report the impediments in their task and help will be provided to resolve it. This is introduced to increase the productivity, because team should not spend longer period of time in a same problem.

Confidential

Programmer Analyst/Team Lead

Environment: MS SQL Server, C#, ASP.NET, AJAX, XML, JavaScript, Telerik Controls, IIS

Responsibilities:

• Developed high-level and detail-level specification document for the functional requirement
• Defined coding standards, created templates for database objects development
• Developed stored procedures, functions and triggers to meet the functionality
• Performed database administration and migration activities
• Written complex T-SQL that encapsulates and manages business rules
• Developed data load packages using DTS to transform the input data from various sources
• Developed ASP.NET webpages and customized based on client requirements with AJAX and Telerik RAD controls
• Designed application reports using SQL Server Reporting Services
• Offshore Team lead for the project and managed four member team
• Performed code build and release activities with proper version controlling
• Managed team on their day-to-day activities and performance evaluation

Confidential

Programmer Analyst/Team Lead

Environment: MS SQL Server, C#, ASP.NET, AJAX, XML, JavaScript, Telerik Controls, IIS

Responsibilities:

• Performed database administration and migration activities
• Team lead for database related task, managed three member group to address all DB related work
• Developed high-level and detail-level specification document for the functional requirement
• Defined coding standards, created templates for database objects development
• Developed stored procedures, functions and triggers to meet the functionality
• Involved in performance tuning using SQL execution plan and indexes
• Involved in testing, monitoring, managing, and validating the activities in different environments
• Performed code build and release activities with proper version controlling
• Performed mentor role on product and processes to team members
• Managed team on their day-to-day activities and performance evaluation

Confidential

Sr. Systems Engineer/Team Lead

Environment: MS SQL Server, C#, ASP.NET, ADO.NET, JavaScript, IIS, Lotus Notes, VSS

Responsibilities:

• Team lead for Employee Data and eRecruitment modules of the product
• Involved in GAP analysis and documented functional and change request from clients
• Involved in database migration and administration activities
• Performed tuning on T-SQL queries, stored procedures and indexes with help of profiler
• Performed code build and release activities with proper version controlling
• Resolved production incidents, applied defect fixes and managed the assigned modules
• Performed mentor role on product and processes to team members
• Managed team on their day-to-day activities and performance evaluation

Confidential

Sr. Systems Engineer/Module Lead

Environment: MS SQL Server, VB.NET, ASP.NET, ADO.NET, JavaScript, VSS, IIS

Responsibilities:

• Module lead for Material Management and Production Planning modules of the product
• Involved in GAP analysis and documented functional specification
• Involved in creating database design and various database objects
• Involved in database migration activities
• Database administration and maintenance
• Developed ASP.NET webpages and customized based on client requirements
• Performed mentor role on product and processes to team members
• Managed team on their day-to-day activities and performance evaluation

Confidential

Software Engineer

Environment: MS SQL Server, VB, ASP, JavaScript, COM, IIS, Crystal Reports

Responsibilities:

• Designed User Interface and Proof Of Concept(POC)
• Involved in database design
• Developed stored procedures and triggers
• Developed ASP web pages to interact with mid-tier components
• Developed components for the mid-tier business logic using MTS services
• Performed Unit Testing
• Performed Configuration Management