PROFESSIONAL SUMMARY:

• 11 years of professional experience with complete SDLC in Software development and AMS projects using ETL INFORMATICA and web - based applications using Microsoft Technologies.
• In TATA CONSULTENCY SERVICES, Lead multiple projects such development in MS Technologies and ETL, INFORMATICA CoE.
• Extensively used ETL tool for supporting the Data Extraction, Transformation & Loading in a corporate-wide data warehouse using INFORMATICA PowerCenter 9.1x.
• In-depth knowledge in Data warehouse design, develop and implement DataMart model, Operational Data Store.
• Understanding of Data Validation Option (DVO) in INFORMATICA PowerCenter.
• Understanding of INFORMATICA MDM architecture and Power Exchange.
• Knowledge and expertise in .NET framework1.1, 2.0, 3.5 encompassing ASP.NET, Web Services, WCF, ADO.NET, C#, and Enterprise Library.
• Understanding of MVC and Entity Framework.
• Good understanding of database development, Stored Procedures and Functions using SQL Server.
• Experience with data reporting tools like SSRS and Tableau.
• Knowledge on SPLUNK and Tidal scheduler monitoring tools.
• Understanding of Microsoft Project Plan, ITIL concepts and incidents management.
• Understanding of BizTalk Server2006/2010 and SOA.
• Worked on different client locations at UK (Swindon), PERU (Lima), ECUADOR (Quito) and USA.

TECHNICAL SKILLS:

Database: SQL Server and Oracle11g

ETL & Reporting Tools: INFORMATICA, SSIS, Tableau, SSRS.

Languages: Classic ASP, ASP.Net.1.1, 2.0, 3.5 and 4.0, C#, VB.Net, Web Service, WCF.

Scripting Languages: R, Java Script, XML, XSD, LINQ, PowerShell Script.

Tools: SPLUNK and Tidal scheduler.

Methodology: Agile and Waterfall.

PROFESSIONAL EXPERIENCE:

Confidential, Warsaw, Indiana

Data warehouse Specialist

Responsibility:

• Design, develop and implement enterprise data warehouse and DatMart models, logical data model.
• Involved in implementing end to end ETL and development life cycle.
• Analyse requirements, program and configure warehouses of database information and provide support to warehouse users.
• Review data mart/warehouse deliverables and suggest and co-create standards and guidelines.
• Perform data quality and profiling activities, advice on data quality issues and provide analysis on data collection.
• Develop mappings; define workflows and tasks, monitor sessions, export and import mappings and workflows in Dev, QA and Production environment.
• Translating the requirement into design document like HLD and Integration Mapping and Transformation requirement.
• Involved in designing the dimensional model like STAR schema and Snowflake schema.
• Review mapping, Transformation, session and workflow as per requirement and unit testing for all the ETL components.

Technologies: INFORMATICA Power Centre 9.6.1, ORACLE11g, XML, XSD, DB2, informatica power exchange.

Confidential, St Paul, Minnesota

Project Lead

Responsibility:

• Understanding workflow rules, system requirements. Designing logical & Physical system flows.
• Development in ASP.Net, C#, JavaScript and Unit testing.
• Creating DoU, HLD, LLD and Monitoring document based on the KT session with clients.
• Migration from web services to WCF services.
• Develop mappings; define workflows and tasks, monitor sessions, export and import mappings and workflows in Dev to QA and Production environment.
• Translating the requirement into design document like HLD and Integration Mapping and Transformation requirement.
• Involved in designing the dimensional model like STAR schema and Snowflake schema.
• Review mapping, Transformation, session and workflow as per requirement and unit testing for all the ETL components.

Technologies: DotNet 4.0, Web Services, SQL, C#, WCF, MS-TFS, Visual Studio 2010, XML INFORMATICA Power Center 9.6.1 and ORACLE11g.

Confidential

Technical Architect

Responsibility:

• Understand the current architecture, its inventory, dependencies and complexities.
• High Level Architectural review to identify major and evident architectural enhancements.
• Understand the performance and code review of the current application using Splunk and FxCop tools.
• Identify the performance bottlenecks and improve the performance of the existing jobs.
• Estimate & define the phases and roadmap.
• Capture all the necessary information to define the migration roadmap and identify the various tools required for migration.
• Identify any third party components used in the current systems and their compatibility with .NET 4.0 Framework.
• Identify the scope of PoC and PoT.

Technologies: INFORMATICA, DotNet 4.0, Web Services, Oracle, SQL Server2000, WCF, MS-TFS and UNIX.

Confidential

Technical Lead

Responsibility:

• Analysing the requirements and breaking into simple tasks.
• Coordinating with Client and Microsoft for new builds.
• Supporting, maintaining Microsoft applications.
• Downloading the latest application code and performing a check out/check in operation through TFS.
• Doing the branching, merging for every major code.
• Creating the manual builds from TFS and getting output in drop folder at specified path.
• Deploying the applications onto the different Dev environments.
• Monitoring the application and servers using VMware tool.
• Scheduling of the SSIS jobs on SQL Server 2008.
• Troubleshooting the application, configuration related defects and solving them.
• Coordinating among different teams like testing team relating to defects in QC.
• Handling of regular client calls for technical discussion.
• Provide estimations for enhancements and different tasks.
• Troubleshooting BizTalk Admin console and IBM web sphere MQ.

Technologies: DotNet 3.5, Web Services, SQL, C#, WCF, SSRS, MS-TFS,Visual Studio 2008, SSIS, BizTalk Administrator.

Confidential

Sr. Software Engineer

Responsibility:

• Understanding workflow rules, system requirements. Designing logical & Physical system flows.
• Responsible for producing a reproducible build from the files placed in the software configuration management system.
• Involved in system/integration testing.
• Unit testing, debugging and deployment of the system.
• Documenting the processes as per standards.

Technologies: ASP.net framework 2.0, C#, TFS, Web Service, WCF, SSIS etc.

Confidential

Sr. Software Engineer

Responsibility:

• Development in ASP.Net, Vb.Net, C#, HTML, JavaScript.
• Interacting with onsite team and end users.
• Involved in system/integration testing.
• Unit testing, debugging and deployment of the system.
• Documenting the processes as per standards.

Technologies: ASP.net framework 2.0, C#, TFS, Web Service, WCF, SSIS etc.