SUMMARY:

• Over 6+ years of IT Experience in end to end Agile project & deliverables using various technologies and understanding the SDLC/AGILE methodologies for smooth project execution.
• Experienced Datawarehouse Specialist in delivering end to end projects.
• Offering vast years of experience in Software Development of Data Warehousing projects encompassing Development, Testing and maintenance of Informatica power center as ETL on Teradata, Unix and Mainframes.
• A project executor with exposure in handling projects and ensuring delivery of projects within the time & cost parameters; executed multiple key projects involving Data warehousing using various technologies like Informatica Power Center 7.1, Informatica Power Center 8.5.1, Informatica Power Center 8.6 and Informatica Power Center 9. (Workflow Manager, Workflow Monitor, Warehouse Designer, Mapping Designer, Mapplet Designer & Transformation Developer).
• Development of Informatica mappings using varied transformation logic using filter, expression, router, aggregator, joiner, lookup, and update strategy.
• Lead projects running with development, Testing and production support of data warehousing projects.
• As a business analyst facilitated onshore - offshore and multi-location co-ordination and work distribution based on the stakeholder requirements and priorities.
• Timely support and maintenance of the production jobs running in production environment.
• Experience in Linux, UNIX, Oracle, COBOL, JCL, VSAM, and DB2 Incident, Change/Release Management in Production Environment, extensively involved in various phases of production support (24/7).
• Ability to deliver comprehensive Business Intelligence through integration of BI suite of products(SSAS, SSRS) including MS solutions like MS EXCEL 2007, Microsoft Office SharePoint server(MOSS) 2007, Performance Point Server 2007 and ProClarity analysis server.
• Knowledge on full software development life cycle (SDLC) starting from collecting business specifications, user requirements, confirming the design decisions regarding data, process, interfaces, reviewing/audit the code and documenting effectively the entire life cycle.
• Lead the projects using Linux, UNIX and IBM Mainframes platform level 1 & 2 support
• Expertise in Developing and Tuning T-SQL,PL/SQL Complex Queries, Stored Procedures, UDF’S, triggers, views, Indexed views and error handling using Try-Catch blocks
• Skilled in Informatica power center design, development of mappings from varied transformation logic using filter, expression, rank, router, aggregator, joiner, lookup, and update strategy.
• Possess strong communication, relationship management, analytical and problem-solving skills.
• Comfortable in interacting with people across hierarchical levels for smooth project execution.
• Experience in SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services).
• Developed Informatica Mappings using Designer to extract, transform data according to the requirements and loaded into database from relational sources and non-relational sources.
• Involved in different environments of testing, trouble shooting of Informatica mappings and SQL queries for unit testing and developing test cases. Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Experience in Tuning SQL queries and T-SQL queries, MDX & improving the performance of the queries.
• Worked in performance tuning, query optimization, client/server connectivity, and Database Consistency Checks using DBCC utilities.
• Experience in developing Life Cycle using Agile Methodology.

TECHNICAL SKILLS:

Databases: DB2, HBASE, Teradata, SQL server 2012/2014, Hive, SQL Server 2012, SQL Server 2008/2008 R2, SQL Server 2005, SQL Server 2000/7, Access, Oracle 8i/9i/10g, MYSQL

Tools: ETL- Informatica Power Center, Supersession, ESP Workstation, Vantive, NMC, Q-Messenger, UMON, AOTS, NETCOOL, UMON,CHGMAN, SQL Server Management Studio, Performance Monitor, Query Analyzer, Query Optimizer, SQL Profiler, Data Transformation Services (DTS), Bulk Insert and BCP, ODBC, Business Intelligence Development Studio(BIDS), SQL CMD.

Languages: VS COBOL II, JCL, SQL, VSAM, UNIX Shell Scripting T-SQL, MDX, C, C++, VB 6.0, PL/SQL, C# 4.0, Shell Scripting, LINQ, ASP.NET, UML, XML, XMLA, MS SharePoint

OLAP Reporting Tools: SQL Server Reporting Services (SSRS), SSAS, SSIS, Crystal Reports 9.0/8.5,OLAP, Erwin

Change Management Tool: Tortoise SVN, Visual Source Safe (VSS), Team Foundation Server (TFS)

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Technical Associate

Responsibilities:

• Analyzing deeply on applications daily basis and to make a proper conclusion on the batch and online schedule to avoid conflict in scheduling jobs. So, that we can meet our online and batch commitments.
• Resolve problems/exceptions for online and batch applications on Informatica.
• Provide technical assistance for the DSFS Applications.
• Develop and execute batch jobs and monitor job streams completion to meet batch and online service level commitments.
• Interact with clients and other work groups to co-ordinate delivery.
• Nurture and guide team members to understand business requirements and technical deliverables.
• Handling Teradata job failures, fixing Multiload, Fast load abends.
• Designed the business requirement collection approach based on the project scope and SDLC Methodology.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Created Informatica mappings with T-SQL procedures to build business rules to load data.

Confidential

Sr. Technical Associate, TechM/Deployment Manager

Responsibilities:

• Perform Sanity Checks and validation
• Resolving service requests and issues appropriately
• Prepare Problem reports, Request Management (RM), Change Request (CR), RFC Maintain shell scripts
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema design (Star Schema) and maintenance.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Responsible for creating summary Reports, Sub Reports, Drill Down Report, dynamic grouping.
• Used DBCC commands for checking database consistency and fixing data corruption in user databases.
• Done performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks.
• Developed and implemented Backup and Recovery strategies. Day-to-day activities such as backups to the disk and restore the databases and transaction log on production/development servers as per the business needs.
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.

Confidential

Technical Associate TechM

Responsibilities:

• Understanding and preparing High Level and Low level Designs. Preparing Business understanding documents for ADR/FSP application.
• Contact with Application KT team and setup meeting sessions with client and KT team.
• Understanding core business to benefit customer.
• Preparing initial estimates by analyzing the requirement and Coding.
• Peer to Peer review of all the deliverables.
• Preparing Application Information baseline document for project initiation
• Preparing ASCP(Application support & control plan) for Production support understanding
• Analyzing and solving Abends & Updating the AOTS ticket.
• Creating a strong Interface between the customer and delivery teams to ensure expected quality and accuracy of the deliverables.
• Worked closely with Database Lead to design and implement database components in timely manner.
• Managed index and optimized queries using execution plan.