SUMMARY:

• More than 11 years of experience in IT Industry with expertise in Enterprise Application Integration, delivery management, staff development, stakeholder management, trading partner management, systems analysis, testing, and all aspects of SDLC.
• Leading teams of professionals in the consistent, on - time, on-budget delivery of complex, medium and large-scale projects in highly challenging environments. Extensive hands-on and leadership experience with in diverse industries and corporate environments.
• 9+ years enterprise data integration and architecture experience using Informatica Powercenter 9.6,SSIS,MS SQL, Tera Data, Syabse, C#, Informatica Cloud, SSAS,SSRS, Power BI,SQL azure.
• Experience in working with unstructured data using Informatica data transformation services (DTS). Experience in working with multiple flat files as sources and targets.
• Experience in Data Modelling, Data Base design, Data Ware house design, Data mart design.
• Good knowledge of client and server installation of Informatica Power Center 9.6. Hands on experience of using Iformatica Administation tool.
• Good knowledge in installation and configuration of SSIS, SSAS, SSRS.
• Experience in designing Fact and Dimension model, Start Schema and Snow Flake Schema
• Experience in Writing complex T-SQL and PL/SQL queries. And proficient in wrigin high performance Database Queries, Stored procedures,Views,Triggers.
• Experience in analytics and reporting tools such as SSRS,SSAS, Power BI, Tableau. Experience in writing MDX, DAX queries, Expressions, KPI,desiging Cube using MS-SSAS
• Good understanding of Data mapping, data validation, data manipulation and data analysis use case.
• Working knowledge in no SQL database mongoDB
• Experienced on development of webapplications using ASP.NET, C#, Java Scripts.
• Eperience in creating Web services using REST and SOAP, to fetch data from external sources.
• Hands on experiene in doing data analystics using Python.
• Utilize agile methodologies and adhere to coding standards, procedures and techniques while contributing to the technical code documentation
• Exposure to Enterprise Cloud Strategy - IaaS, PaaS, SaaS, Hybrid Cloud, Public Cloud, Private Cloud, Microsoft Azure
• Knowledge on business process design, business capability development, business process reengineering.
• Stakeholder/Team Management, Performance Appraisal, member of recruitment panel, annual budgeting, budget forecasting, focused recognition for team members, Knowledge of finance, accounting, valuation and metrics development.
• Good knowledge of ITIL process for Incident, Request, Change and Problem management. Good knowledge about Project management principles as per PMI standard
• Good exposure to Financial Domain, Life Science Domain and Health Care domain.

TECHNICAL SKILLS:

Database: MS SQL Server, SQL Azure, Oracale, Mongo DB, Sybase, Tera Data

Database Scripting: T-SQL, PL/SQL

ETL Tool: MS SSIS, Informatica Power Center, Informatica Cloud

Analytics/Reporting Tools: MS SSAS, MS SSRS, Power BI, Power View, Tableau

Data Cleansing Tools: DnB,Melissa

Scripting Language: PowerShell, Python

.NET Technologies: ASP.NET, C#.NET, Web Services, XML, XSLT, WCF, LINQ

Source Control Tools: MS Visual Source Safe (VSS), TFS, PVCS

Methodologies: Agile, Waterfall, Iterative

Data modeling tool: MS Visio, ERWIN

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Technical Architect, Market Data Analytics

Roles and Responsibilities:

• Designing, developing and testing complex Extract, Transformation, and Load routines using Informatica.
• Providing direction, guidance, and technical support to clients, applications, and operations areas; analyzing data requirements and developing ETL solutions to support Data Warehouse initiatives.
• Actively work with Business and IT teams to do system study, gap analysis and ensure business requirements are met.
• Create and configure Domain, Repository and Integration services using Informatica Administrative Console.
• Designing complex Workflow, Session,Mapping using Informatica Powercenter 9.6 to fetch data from flat file source, excel sources, Tera Data, Oracle DB, MS SQL sources and loading them to MS SQL target DB.
• Using appropriate active and passive informatica trnasformations for efficient data load.
• Doing necessary configurations in mapping designer and workflow designer. Using the Workflow monitoring tool to monitor and analyze of any failures.
• Creating ICRT mapping to load to and from Sales Force to SQL database.
• Involved in data analysis, data modeling, data profiling and data sampling processes.
• Interacting with external systems to get data for Members, Employers, Brokers and deciding the frequency of data loading.
• Interacting with the business team and sales/marketing team to unsderstand their reporting requirement and accordingly doing data modelling.
• Intergration of Broker, Emloyer, Member, Email data to sales force.
• Designing data mart using Start Schema and Snow Flake Schema, and Fact and Dimension design.
• Involved in Data cleansing and sampling through Melissa and DnB (third party) and fetching data from DnB using Web Services over SOAP using C#.
• Preparing all the required technical, design and requirement documents at every stage
• Writing high performance, complex Stored procedures,Views,Triggers, Functions.
• Involved in DB tuning, Query Tuning, Using the most efficient ways for better DB performance
• Creating test cases and unit testing ETL code to ensure it can be delivered and run in the system testing environment. Participation and contribution in quality assurance walk through of ETL compenents.
• Technically leading the team providing proof of concept allocating the task and reviewing the task.
• Helping Data and Analystics CoE for any kind of issues in any of the ETL performance issue and Data modelling issues.
• Work with the higher management for resource planning, budgeting, resource hiring.

Environment: SQL 2008/2014, SSIS, SSRS, SSAS, C#, Informatica PowerCenter, ICRT, Sales force, Web Services

Project Lead

Roles and Responsibilities:

• Leading the team of developers, analysts and contract staffs.
• Leading projects related to Purchase Order, Order Acknowledgement, Ship Notice, Order Change Request, Invoice, Outage Notification. Product Activity Data, Sarbanes-Oxleya and Summation Pro.
• Interacting with business and customer in Requirement analysis, requirement gathering and preparing high level and low level design documents.
• Technically leading the team providing proof of concept allocating the task and reviewing the task.
• Designing complex Workflow, Session,Mapping and different transformations to fetch data from sources like MS SQL, Oracle, Sysbase and loading data into Oracle target DB Informatica Power Center and SSIS .
• Doing pre and post processing data analysis, data cleansing.
• Involved in desing reports using SSRS, at the same time migrating reports from old version to new version.
• Designing SSAS cudes, wriring MDX and DAX scripts, designing KPI for data analysis.
• Bug fixing and new enhancement to cleint’s existing .NET and C# applications.
• Preparing Unit test case and planning of UAT by co-ordinating with business and system owner
• Addressing the issue raised by the testing team and deciding the priority and helping them to understand the process.
• Attending weekly portfolio meetings and addressing various concerns issue.
• Managing end to end response and resolution SLA.
• Work with the higher management and director for the annual budget forecast for the coming year and work on prioritizing the ongoing and upcoming projects accordingly.
• Providing Ideas in HCL Value portal for the process improvements.

Environment: Oracle,PL/SQL, ASP.NET, C#.NET, MongoDB, MS SQL, SSRS, SSIS, informatica, SQL Azure

Technical Lead

Roles and Responsibilities:

• Leading the team for transition of multiple of applications during project initiation phase in clinical and pre-clinical space.
• Technically leading the team in defining development Standard, naming conventions and Implementing Integration best practices.
• Interacting with business and customer in Requirement analysis, requirement gathering and preparing high level and low level design documents.
• Heavily involved in designing the Clinical Data repiostary system which is the main data mart for all clinical test data.
• Creating Informatica mappings, sessions, workflows to fetch data from various subsidiary regional data base to centralized data ware house system.
• Heavily involved in pre and post processing Data cleansing and data quality process.
• Designing web services using .NET and C# to extract WSDL from external sources
• Involved in writing complex T-SQL queries using latest SQL functionality
• Acted as a change manager and r eviewer of technical and functional designs as well as other artifacts related to change management, such as deployment/mitigation plans and risk and impact analysis
• Directly engaged with the business users for their data requirement and providing solution.
• Monitor the day to day activities of the Service request team and provide feedback on each complex issues and assigned it appropriately to each team members
• Provide Timely Project status report to Client and higher management.
• Maintain the expected Service Levels.

Environment: SQL Server 2008, Microsoft SSIS,Informatica,Oracle 11g,Tera Data,PL/SQL, ASP.NET, C#

Lead Consultant

Roles and Responsibilities:

• Leading the team for Deal Capturing System, Reference Data System (DTW), Forex trading system, Market Data server (MDS).
• Create and configure Domain, Repository and Integration services using Informatica Administrative Console.
• Designing complex Workflow, Session,Mapping using Informatica Powercenter 9.6 to fetch data from flat file source, excel sources, Tera Data, Oracle DB, MS SQL sources and loading them to MS SQL target DB.
• Using appropriate active and passive informatica trnasformations for efficient data load.
• SME for super critical ETL nightly data load process from different regional financial institutions like, various stock exchanges, various external feeds, RIC codes, Tickers from Bloomber, Fidess and few other source systems to centarliazed data warehouse MDS system.
• Doing necessary configurations in mapping designer and workflow designer. Using the Workflow monitoring tool to monitor and analyze of any failures.
• Region wise Broker and user data analysis using SSAS, Python, Tera Data system, SSRS,MDX.
• Using file watcher for fetching EOD stock prices, files from rating agenies from various stock exchanges to load into the MDS system.
• Writing high performance complex Stored procedures, Views, Triggers, Functions, SQL windows functions.
• Creating Web Services to fetch data from external sources for data analyasis and reference purpose.
• Preparing high level/ low level design and technical documents using MS Visio and SharePoint
• Directly engaged with the business users for their data requirement and providing solution.
• Coordinating with different systems like Bloomberg, Reuters, Fitch etc. for ticks, prices, market data, RIC code, exchange data.
• Involved with Reconciliation team for reporting.
• Provide Timely Project status report to Client and higher management.
• Maintain the expected Service Levels.

Environment: MS SQL 2008, Sybase, SSIS, Informatica Power Center, Share Point, ASP.NET, C#NET

Software Developer

Roles and Responsibilities:

• Developing web applications for e-Learning applications using using ASP.NET and C# .NET, MS SQL.
• Developing document repository system using Share Point.
• Creating Data mart using SSIS for sales analysis.
• Writing complex SQL Queries, Views, Stored Procedures, Functions
• Doing Unit testing after development and helping testing team for creating test cases.
• Preparing and updating various documents according to SDLC standard using Water Fall methodologies.
• Involved in Deployment of application into UAT and IT environment.
• Doing Post-Deployment checks and communicating to all the stake holders about the status
• Involved in Analysis/Creating various sales Report using SSRS.

Environment: Visual Studio 2005, ASP.NET 2.0,C# 2005, SQL Server,SSIS, SSRS, Share Point 2007

Software Developer

Roles and Responsibilities:

• Developing Web and Windows applications using ASP.NET and VB .NET
• Writing complex SQL Queries, Views, Stored Procedures, Functions
• Doing Unit testing after development and helping testing team for creating test cases.
• Preparing and updating various documents according
• Involved in Deployment of application into UAT and IT environment.
• Fixing the issues raised by Testing team and direct users.

Environment: Visual Studio 2005, ASP.NET 2.0,C# 2005, SQL Server, VSS, Crystal Report

Software Developer

Roles and Responsibilities:

• Developing Web and Windows applications using ASP.NET and VB .NET
• Writing complex SQL Queries, Views, Stored Procedures, Functions
• Doing Unit testing after development and helping testing team for creating test cases.
• Preparing and updating various documents according
• Involved in Deployment of application into UAT and IT environment.
• Fixing the issues raised by Testing team and direct users.

Environment: Visual Studio 2005, ASP.NET 2.0,C# 2005, SQL Server, VSS