SUMMARY

• Highly accomplished and solution - driven ETL/Database Developer with 14 plus years of combined experience in the HR compensation and publishing domain.
• Experience in database architecture, Data Mart and ETL development. Strong experience in Data Mapping / Extraction / Transformation and Load using Infromatica and Azure Data Factory.
• Hands - on experience in Azure Cloud Services (PaaS & IaaS), Storage, Active Directory, Application Insights, Logic Apps, Data Factory, Azure Monitoring, Key Vault, Visual Studio Online (VSO), SQL Azure.

TECHNICAL SKILLS

Cloud Technologies: Azure SQL Database, Azure Data Factory, Azure Logic App, Azure Storage Blobs, SFTP, Performance insight, Azure DevOps.

Programming Languages: Sybase TSQL, SQL Server TSQL, Visual Basic 6.0

Database Systems: Sybase 15.7/12x, Azure Sql Database, MS Access, MS SQL Server

Operating Systems: Windows 9X, Windows 2000/XP, Linux

Microsoft Technologies: Visual Basic 6.0

Business Areas/Domains: HR Compensation Publishing, CRM, SCM, Energy

Tools: Infromatica 9.5/8.6, IBM WebSphere Datastage, Erwin data modeler, DBArtisan, TOAD, Sql Advantage, Business Objects, Cron Tab, BCP, Remedy, MS Office 2003/2007, FileZilla, BCP, JIRA, MS Excel, MS power point. Azure SQL Database, Azure Data Factory, Azure Logic App, Azure Storage Blobs, SFTP, Performance insight, Azure DevOps.

Methodologies: Agile, SDLC

PROFESSIONAL EXPERIENCE

Senior Principal consultant

Confidential

Responsibilities:

• Hands - on experience in Azure Cloud Services (PaaS & IaaS), Storage, Active Directory, Application Insights, Logic Apps, Data Factory, Azure Monitoring, Key Vault, Visual Studio Online (VSO), SQL Azure.
• Designed and developed Cloud Service projects and deployed to Web Apps, PaaS, and IaaS.
• Used SQL Azure extensively for database needs for current ongoing project.
• Extensively worked on SQL, T-SQL, stored procedures, functions, triggers, views, joins, schema, Linked Servers and Transactions.
• Hands - on experience in Infromatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Hands - on experience in developing new Infromatica mappings, mapplets, session, workflows. Migrating code to other environments.
• Use Azure DevOps processes TFS-Git Repositories for versioning control, CodeFlow for code review.
• Designed dataflow diagrams using Visio, project timeline using MPP, and documented every phase of design & development of app. Configure new net cool alerts for application issues.
• Hands - on experience in Setup New Autosys jobs and newer version.
• Trouble shooting of performance issues occurred on Sybase database server and identify the root cause by analyzing query plans, table stats and MDA tables.
• Perform analysis on slow running database queries and tune those by correcting indexes. Flattening or re-write the process.
• Implemented Azure Application Insights to store user activities and error logging.

Assoicate project manager

Confidential

Responsibilities:

• Design data model design using Erwin. Provided database architecture, design, configuration, & development.
• Extensively developed Sybase stored procedures, Triggers, views and UDF
• Analyzing tables and indexes for performance tuning. Troubleshoot the existing stored procedures, functions, triggers and views.
• Using Infromatica Power Center created mappings and mapplets to transform the data according to the business rules.
• Used various transformations like Source Qualifier, Joiner, Lookup, sql, and router, Filter, Expression and Update Strategy.
• Determined unnecessary indices, dropped/restructured indexes with very poor selectivity.
• Suggested multiple tempdb as a solution to heavy usage of tempdb & frequent blockage on system tables.
• Invoked sp sysmon to probe & monitor system performance under normal and load conditions.
• Developed application performance reporting from Sybase tables.
• Wrote Unix Scripts and Sybase stored procedures for data migration and scheduled jobs in Autosys.
• Write technical specification and get reviewed and approved by client technical manager.
• Assign the new development tasks to the team members as per the plan.
• Analyzed data for business users and answer specific questions.

Project lead

Confidential

Responsibilities:

• Have the Ownership of Production Support of the LexisNexis EIS warehouse Applications like vistacrep, crepvista, mrm, ALS Catalog.
• Monitoring the Datastage job on daily basis by running the UNIX shell script and made a force start whenever job fails.
• Resolving webstars/problems of Non Vista application. Webstars are basically enhancements in the existing applications, tables, logic etc.
• Designing ETL processes for loading the different data marts using Data Stage & SSIS Packages.
• Used the DataStage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data mart.
• Developed complex jobs using various stages like Lookup, Join, Transformer, Dataset, Row Generator, Column Generator, Datasets, Sequential File, Aggregator and Modify Stages.
• Providing estimates for the new applications using the different estimation techniques like
• Creating new reports and customizes data models in Humming Bird BI reporting tool which is used by the customers to run business queries.

software engineer

Confidential

Responsibilities:

• Develop Siebel EIM process to load new orders into the database.
• Handling various interfaces which are responsible to send the updated data from eCo to other systems of BT to generate the MIS Reports. Interfaces executed automatically by setting the different cronjobs for interfaces.
• Involve in development and fixing of new Change Requests and problem requests in Oracle PL/SQL.
• Handling of Hunter Tool which traps the error from the log files of interfaces and raise a bridge case in case of any error found