PROFESSIONAL SUMMARY:

• An accomplished senior software developer with 8 years demonstrating success in designing and implementing technology solutions for constructing efficient data warehouse and business intelligence systems.
• Expertise in troubleshooting, supporting the critical break fixes with accurate results to the client satisfaction.
• Experience working in global delivery model projects, requirement gathering from cross - functional teams, collaborating successful deliveries with various technology teams and supporting production environment.
• 13 Years of Progressive Experience Working with Multiple Technologies with good understanding of full Project Life Cycle of Data Warehousing & Integration, BI and Web Application Models. Participated in business analysis discussions to gather the requirements and convert them into technology solution model keeping the overall project parameters in view.
• Employed Informatica to load Data from disparate source and Target RDBMS ODBC like Oracle, SQL Server, DB2 UDB, Netezza and application sources like Salesforce and CSV/Flat Files,and XML Files and SharePoint Data Sources building a large data warehouse consisting various subject areas across Confidential . Experience in creating SSIS packages to transform-load into targets as well.
• Expertise in Autosys and JIL Scripts for implementing complex Scheduling requirements among Batch Jobs. Worked on Microstrategy environment for the BI reporting solutions built upon the DataWarehouse including analyzing & solving the production defects. Created UNIX Shell Scripts For Informatica Pre-Load, Post-Load Operations and for runtime Parameter Modifications, FTP Activities Or Multiple Conditional Workflow Kick-offs
• Created mappings using transformations like SQL, Aggregator, Expression, Joiner, Router, TC
• Familiar with DB Oriented Pushdown Optimization and Partitioning Concepts in Informatica
• Experience in Database (SQL & PL-SQL &T-SQL) Coding. Familiar with Various Objects like Indices, Hints, Views, Materialized Views, Procedures, Functions, Triggers, Collections, Cursors. Experience in designing logical and physical data models using ERWIN tool.
• Implemented Data Quality and Enterprise Data Management Control Methodologies as Part of Project Data Maintenance Stages at Confidential .
• Worked in Assessments of Data Cleanup and Data Gap Reduction between Source and Target Systems. Have knowledge on Informatica MDM, TDM.
• Working Knowledge of Data Warehousing and BI Concepts Like Star Schema and Snowflake Schema, Slowly Changing Dimensions Used In Relational, Dimensional Modeling. Delivered an SCD-II solution at Confidential for a complex Multi-Family DW requirements along with customizing an in-house Data control framework to achieve the desired data quality.
• Performed tuning and error handling of Informatica mappings and DB Objects within the given environment Boundaries/Parameters. Familiar with Utilizing/Overriding Various Mapping/Session/Transformation) Levels of Parameters & Variables to achieve the Reusability of ETL Objects on an Overall Project Perspective. Familiar with Reusable ETL Objects Creation and Propagations Rules. Familiar with Informatica Versioning Capabilities to Narrow Down Analysis Parameters, Migration of Informatica Objects Across Folders Or Environments and Debugger Troubleshoot Mode for Mappings to tap into Performance or load discrepancies of Data Loads.
• Have working experience in Core Java. OOPS Concepts and Java Application & Webserver Technologies and Configurations. Worked on Middleware products Metamatrix, JBOSS EDS to an Extent for Data Federation Strategies in Virtually Coupling Transactional Source & Warehouse Target Systems
• Good Team Player with Excellent Interpersonal and Communication Skills, Technically Competent and Result-Oriented Work Attitude. Possesses Leadership & Motivational Skills to enhance the Team-Productivity overall. Well versed with the Microstrategy Schema and Application objects creation and maintenance. Microstrategy coupled with the ETL knowledge gives me an edge in understanding overall DW needs

AREAS OF EXPERTISE:

Software Development Lifecycle (SDLC) Management - agile - waterfall - Relational Databases - Troubleshooting & Support - Data warehouse & BI model - Project Management Performance/Data Analysis - Process Improvements - Testing & Implementation

TECHNOLOGIES:

DataWarehouse: Informatica, SSIS, Microstrategy, Autosys, Dimension-Fact modelling, Tableau

Languages: SQL, PL/SQL, Shell script, VQL, Core & Advanced java, J2EE, HTML, JavaScript, VB

Databases: Oracle (9i, 10g, 11i), MS-SQL Server, DB2 UDB, Netezza

Tools: Informatica Power Center Tools, Microstrategy Desktop, Autosys, Maestro, SOAP UI tool, Squirrel, JBOSS developer studio, Toad, ERWIN, PL/SQL Developer, Oracle SQL Developer, Metamatrix (Query Builder, Designer, Console), WinSCP, SSH Tectia, Putty, SubversionCVS, JUNIT, DJ compiler, Microsoft office Tools, WSAD, Eclipse, JDeveloper, JBuilder, MS-SQL server management Studio, MS Visual Studio(for SSIS), Rapid sql, Aginity Workbench

Enterprise tools: BladeLogic, IBM Maximo, HP Peregrine Service Center, HP Quality Center, HP ALM, JIRA, ITSM-Remedy

Systems: Windows, UNIX, MS/DOS, Sun Solaris, AIX

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Technical Lead / Software Engineer

Technologies/Architecture/Tools: Informatica Power Center, Oracle, SQL/PL-SQL, Data warehouse Concepts, UNIX, Autosys, Netezza, SQL Server, Microstrategy, tableau

Responsibilities:

• Lead the project team in GDC model for BI & DataWarehouse components maintenance using Informatica, Microstrategy and Oracle, Netezza databases.
• Interacted with business partners to gather, interpret, analyze the requirements, do the feasibility study and implement the fitting technology solutions within the boundaries defined by the LoB
• Worked with Different Technology and Business Teams in designing the technology solutions for expanding the Warehouse with increasing data integration needs of the LoB.
• Successfully completed eDOT project migration for the Netezza warehouse from previous Oracle
• Worked on power center tools to build workflows, deploy them across the environments and scheduling the data load jobs in Autosys Scheduler.
• Implemented solutions for Data Quality and Data control by designing the Workflows in PowerCenter
• Worked with a good understanding on data federation strategies to achieve data integration objectives of the application
• Participated in the various upgrade & migration activities of the project ensuring the Confidential regulatory and compliance standards are met
• Gained the full SME of the application and utilized the knowledge to enhance the functionality of the application and in resolving the production state defects
• Coordinated migration and SIT UAT testing activities of the project ensuring the requirements are met

Confidential, McLean VA

Technical Lead /Solution Architectt

Technologies/Architecture/Tools: Informatica Power Center, Data warehouse Concepts, DB2 UDBRapid Sql, UNIX, Autosys, MS SQL Server 2012, Oracle, SQL

Responsibilities:

• Lead the project team in onsite-offsite model for data warehouse development using Informatica, MS-SQL server DB, DB2 UDB and Oracle DB.
• Interacted with business partners to gather, interpret, analyze the requirements, do the feasibility study and implement the fitting technology solutions within the boundaries defined by the LoB
• Worked with the Different Technology and Business Teams in designing the technology solution for the data integration needs of the LoB.
• After designing the low level Plan of the development effort, coordinated the work among the team
• Developed the ETL mappings and workflows using Informatica in an optimized way and reusable manner wherever is applicable to make the code concise and easy-to-manage.
• Worked on power center tools to build workflows, deploy them across the environments and scheduling the data load jobs in Autosys Scheduler.
• Implemented Data Quality using an house framework to design the Workflows in Power Center
• Developed the UNIX components (shell scripts, shell functions, configuration files etc.,) for supporting the data loads ETL model designed.
• Coordinated migration and SIT UAT testing activities of the project ensuring the requirements are met

Confidential, Charlotte, NC

Technical Lead / Software Engineer

Technologies/Architecture/Tools: Informatica Power Center, Oracle, SQL/PL-SQL, Data warehouse Concepts, UNIX, Autosys, Microstrategy, MS-SQL

Responsibilities:

• Lead the project team in onshore-offshore model for the BI & DataWarehouse components maintenance using Informatica, Microstrategy and Oracle.
• Interacted with business partners to gather, interpret, analyze the requirements, do the feasibility study and implement the fitting technology solutions within the boundaries defined by the LoB
• Worked with the Architects and Different Technology and Business Teams in designing the technology solutions for expanding the Warehouse with increasing data integration needs of the LoB.
• Worked on power center tools to build workflows, deploy them across the environments and scheduling the data load jobs in Autosys Scheduler.
• Coordinated migration and SIT UAT testing activities of the project ensuring the required standards are met

Confidential, Charlotte, NC

Technical Lead / Software Engineer

Technologies/Architecture/Tools: Informatica Power Center, Oracle, SQL/PL-SQL, Data warehouse

Responsibilities:

• Lead the project team in onshore-offshore model for the BI & DataWarehouse components maintenance using Informatica, Microstrategy and Oracle.
• Interacted with business partners to gather, interpret, analyze the requirements, do the feasibility study and implement the fitting technology solutions within the boundaries defined by the LoB
• Worked with the Architects and Different Technology and Business Teams in designing the technology solutions for expanding the Warehouse with increasing data integration needs of the LoB.
• Worked on power center tools to build workflows, deploy them across the environments and scheduling the data load jobs in Autosys Scheduler.
• Coordinated migration and SIT UAT testing activities of the project ensuring the required standards are met
• Prepared test cases for subjecting the application code to necessary and effective testing on Integration and Performance levels based on the need and scale of the development components.

Confidential, Charlotte, NC

Technical Lead / Software Engineer

Technologies/Architecture/Tools: Informatica Power Center, Oracle, SQL/PL-SQL, Data warehouse Concepts, UNIX, Autosys, Microstrategy

Responsibilities:

• Lead the project team in onshore-offshore model for the BI & DataWarehouse components maintenance using Informatica, Microstrategy and Oracle, MS SQL server.
• Interacted with business partners to gather, interpret, analyze the requirements, do the feasibility study and implement the fitting technology solutions within the boundaries defined by the LoB
• Worked with the Architects and Different Technology and Business Teams in designing the technology solutions for expanding the Warehouse with increasing data integration needs of the LoB.
• Worked on power center tools to build workflows, deploy them across the environments and scheduling the data load jobs in Autosys Scheduler.
• Participated in the various upgrade & migration activities of the project ensuring the Confidential regulatory and compliance standards are met
• Prepared test cases for subjecting the application code to necessary and effective testing on Integration and Performance levels based on the need and scale of the development components

Confidential, Charlotte, NC

Technical Lead / Software Engineer

Technologies/Architecture/Tools: Informatica Power Center, Oracle, SQL/PL-SQL, Data warehouse Concepts, UNIX, Autosys, Maestro, Microstrategy, MS SQL Server

Responsibilities:

• Lead the project team in onshore-offshore model for the BI & DataWarehouse components maintenance using Informatica, Microstrategy and Oracle, MS SQL server.
• Interacted with business partners to gather, interpret, analyze the requirements, do the feasibility study and implement the fitting technology solutions within the boundaries defined by the LoB
• Worked with the Architects and Different Technology and Business Teams in designing the technology solutions for expanding the Warehouse with increasing data integration needs of the LoB.
• Worked on all power center tools to build workflows, deploy them across the environments and scheduling the data load jobs in Autosys Scheduler.
• Participated in the various upgrade & migration activities of the project ensuring the Confidential regulatory and compliance standards are met
• Prepared test cases for subjecting the application code to necessary and effective testing on Integration and Performance levels based on the need and scale of the development components

Confidential

Software Developer

Technologies/Architecture/Tools: Java, J2EE, WebSphere, WSAD, AS/400, SQL, MVC, Struts, Hibernate

Responsibilities:

• Worked on the project team in GDC model for application development using Java technologies
• Worked on WSAD tool and WebSphere admin console as part of the application code development With a good understanding on MVC architecture and Struts-Hibernate solutions
• Written Java scripts for the front end validations on a needed scale basis.
• Worked with a good understanding on data involved in the project to resolve defects in the process
• Performed java unit testing activities using JUNIT and also Prepared various test cases for subjecting the application code to necessary and effective testing

Confidential

Java Developer

Technologies: Java, J2EE, Oracle, SQL, /PL-SQL, Batch Scripting, AWK Programming

Responsibilities:

• Worked as a java developer, was involved in design, development and deploy of in-house java tools and web portals. Gathered requirements and implemented the technology solutions using Java/J2EE
• Worked on a dedicated java team that transformed and re-developed a standalone application from a different technology (PowerBuilder).
• Designed and developed a web portal product for realtors. Involved in the designing and creation of the database in line with the application development model
• Gained expertise in deployment activities of java application in app servers and open source web servers