PROFESSIONAL SUMMARY:

• 8+ years of total IT experience in Business Intelligence tools like - Informatica, Cognos and Business Objects working with Confidential
• 8+ Years of Strong experience to design and develop end to end ETL Solutions - Informatica Power Center, Cognos Data Manager.
• 5+ Years of experience in Dimensional Modelling, Data Modelling, Star and Snowflake Schemas using Erwin tool .
• 4+ Years of experience in SAP Business Object Reporting, Universe Design, Webi, Desktop Intellegence Report and Crystal Reporting.
• 3+ Years of working experience of B2B tools - Informatica B2B Data Exchange 9.5.1/10.0, Informatica Data Transformation.
• Extensively worked with XML files as the Source and Target, used transformations like XML Generator and XML Parser to transform XML files, used Oracle XMLTYPE data type to store XML files.
• Exposure to Informatica B2B Data Exchange, Managed File Transfer that allows to support the expanding diversity of customers and partners and their data with capabilities that surpass the usual B2B solutions.
• Used major components like Serializers, Parsers, Mappers and Streamers in Data Transformation Studio for conversion of XML files to other formats.
• Worked with the B2B Operation console to create the partners, configure the Partner management, Event Monitors and the Events.
• Designed and developed efficient Error handling methods and implement throughout the mappings in various projects.
• Defined JMS queues managed by ActiveMQ which is pipe-line for the data between DX and PowerCenter.
• Used the Data Transformation Studio to create scripts that convert complex data formats (i.e. HL7, EDI File Formats), into standard ones and then integrate to Informatica's Power Center platform, using the UDT transformation.
• Strong experience to Understand business requirement and convert them into technical requirement.
• Estimated various large Projects using Top Down and Bottom Up approach.
• Extensive experience of performance optimization of ETL Solution using various techniqes - Partitioning, Push Down Optimization, Grid Implementation, Web & Application server tuning and load balancing.
• Worked with various relational databases and file system- Oracle, SQL Server, DB2, Flat File, XML Files and Cobol Mainframe system.
• Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as Development, Testing, Code Migration, Administration, Security management and Production support on various platforms like Linux, Windows etc.
• Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.
• Strong Implementation Experience to very large Data warehouse (15+ TB) environment.
• Delivered multiple Projects under Agile Methodology and Waterfall model.
• Extensive experience in Retail, Telecomm and HealthCare domain.
• Developed effective working relationships with client team to understand support requirements, develop tactical and strategic plans to implement technology solutions and effectively manage client expectations.
• Have a good conceptual understanding of Big Data Map/Reduce concepts, No Sql, Hive and Impala.
• Worked in multiple countries like India, Canada and USA . Currently in USA with holding H1B visa. Green Card I-140 Approved.

TECHNICAL SKILLS:

ETL Tool: Informatica Power Center 8.1/9.1/9.5, B2B Data Exchange 9.5, MFT 4.5.1, Data Transformation

Secondary Skills : OLAP Tools Business Objects 3.1/XIR2, Crystal Reporting, Info View, Xcelsius

Operating Systems: Windows NT/XP/2003, MS DOS and UNIX

Databases: Oracle 9i/10g/11g, MS SQL Server, Teradata, GreenPlum

Others: Autosys, Control-M, Microstrategy 7,Cognos 8 Data Manager(ETL), Erwin

PROFESSIONAL EXPERIENCE:

Confidential, Michigan

EDI File Mover - Lead Designed & Developer

Responsibilities:

• Developed a real time B2B DX File Mover Framework to replace legacy File Mover Perl daemon.
• Develop a framework to consume the Trading Partner EDI Files into a real time basis.
• Develop a File Scan Stability Process to pick up the file from Remote Trading Partner server.
• Expertise in creating DX Partners, Account, Profiles, Workflows, Event Monitors and End Points.
• Created SSH FTP end points into MFT console and configure the scheduling of mailbox action along with PGP/SSH encryption-decryption.
• Create generic process to load the various format file data into relational database on a real time basis using UDT configuring services Confidential dynamic mode.
• Hands On expertise in creating a Parser project to convert the Fixed Width, CSV and other industry standard format into XML.
• Hands On expertise in creating a Serializer Projects to convert XML format to Flat File format.
• Expertise in creating a generic streamer project to split the large input file into small -2 chunks and in process them in multiple iterations.
• Prepare a High Level Design and data flow document.
• Creating Unit test cases and plan for Unit testing approach.
• Participating in Code Review meetings.

Confidential, Chicago

DLAQM - Technical Service Delivery Manager

Responsibilities:

• Primary responsibilities are Requirement Gathering, design the ETL end to End solution, UAT and Deployment Manager
• Interact with business users / Business Analysts, ACSI PM and LPM to gather requirements and understand the timelines
• Review and understand the Project Solution Definition document, Application Interface document and HLD to finalize the data layer audit requirement.
• Participate in Data modeling discussions, exchange thoughts to come up with a best model to efficiently serve both ETL teams and reporting teams
• Involved in data analysis and Analyzing the data for defects and fixing the defects
• Prepare an ETL Design Prototype and an ETL solution to set up a data layer audit between various source and target system.
• Converting business rules into ETL technical specifications
• Prepare the High Level design flow and data model
• Generate the BO Mock Up reports as per the design
• Develop the Design Package and provide the Design Walkthrough to Solution Architect
• Proactive Code Reviews with developers during development phase.
• Develop a Unix script to connect with LDAP source for Data audit
• Creating Unit test cases and plan for Unit testing approach
• Handling the team of 15 members Confidential offshore and 1 member Confidential onshore

Confidential, Florida

AMI DW Support Lead

Responsibilities:

• Developing the proper support model with industry standards and best practices.
• Attending the Vendor transition and building the offshore and onsite teams in terms of Functional and Technical aspects.
• Leading the team of 8 members Confidential offshore and 1 member Confidential onshore and providing them technical and functional guidance.
• Working on Change Requests and developing the HLD and LLD and also reviews the design against business requirements.
• Reviews the designs and include the best industry practices and standards.
• Daily maintenance of Datawarehouse and Data Marts.
• Daily Maintenance of Informatica mappings, workflows and troubleshooting the batches in case of failure in production environment.
• Handling business critical issues during business hours and providing them proper application support.
• Working on UNIX shell scripts to create SFTP jobs.
• Working as a Gatekeeper for all the production deployment and ensure the SDLC and proper code migration.
• Review the Implementation, Back up, Roll Back and Validation Plan.
• Scheduling of Informatica and SFTP jobs under Control - M tool.

Confidential, Minneapolis

EBI Analyst 

Responsibilities:

• Handling business critical issues during business hours and providing them proper application support.
• Providing bug fixes and code change based on request comes from user.
• Representing the team of 6 members Confidential offshore and providing them technical expertise for 24*7 business applications support.
• Daily maintenance of Datawarehouse and Data Marts.
• Daily Maintenance of Informatica mappings, workflows and troubleshooting the batches in case of failure in production environment.
• Estimations of business change requests, High Level designing and development of the new Informatica jobs and modification in existing Informatica jobs with the help of offshore team.
• Performance tuning of Informatica jobs which includes mappings and workflows and database level performance tuning to improve the SLA’s delivery.
• Maintenance of Business Object Reporting, maintain User and Group security metrics. Report Migration using Import Wizard. Installation of Business Objects XI R2 and Crystal Reports XI R2.
• Manage Production, Test and Dev environments including installation of patches, security administration and access controls.
• Administer and supervise the BO environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports and implement Row and object level restrictions.
• Provided daily maintenance of business critical batches and real time store reporting.
• Supporting BI Tools: Informatica 9.1, Cognos 8 (ETL), Crystal Report 2008 and Business Object XI R2, Infoview and CMC.
• Created the Ad-hoc reports for Business users for quick analysis.
• Maintaining the security access management by creating users/groups and folders.

Environment: Informatica Power Center 9.1 , Business Objects XI r2/3.1, Crystal Reports XIR2/2008, COGNOS 8 (Data Manager), Oracle 11g, Linux and Windows.

Confidential, Vancouver

MCCP

Responsibilities:

• As per the new Business requirements, modified the existing High Level and detailed technical design documents.
• Enhanced the existing Informatica mappings, mapplets and workflows as per the new business requirements.
• Build the new jobs in Informatica ETL as per the technical design documents and schedule these jobs with Autosys scheduler tool.
• Created source, target, transformations, sessions, batches and defined schedules for the sessions.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and modularity.Involved in Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Modified the XML transformation as per the new XSD provided by the business and moved the data into message queue.
• Build the new crystal reports as per the user requirements for Web/Store Inventory data by identifying the required tables and by writing the SQL and Formulae.
• Worked with the Quality Assurance Team to resolve bugs with a very less turnaround time.  
• Extensively worked on reports that contained several Static and Dynamic prompts.

Environment: Informatica Power Center 8.1 , Business Objects XI R2, Crystal Reports XIR2, Infoview, Oracle 11g, and Windows 2003.

Confidential

Merchandising Data Mart 

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Build the detailed technical design document and High Level design document as per the finalized business requirements.
• Build the new jobs in Informatica ETL as per the technical design documents and schedule these jobs with Autosys scheduler tool.
• Created source, target, transformations, sessions, batches and defined schedules for the sessions.
• Performed incremental aggregation to load incremental data into aggregate tables.
• Involved in Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Source, Target, Mapplets, and Transformation objects.
• Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
• Build the new Crystal Report as per the user requirements by identifying the required tables from Data mart and by writing the SQL and Formulae.
• Used sub reports for different parameter and call them based on parameter values, added feature of French and English header in report.
• Created reports containing all the information regarding the publishers, distributors and retailers using crystal reports xiR2.
• Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements.
• Implemented Security Features of Business Objects
• Provided the security access management by creating users/groups and folders.
• Developed universe user documentation guide for the end users reference.
• Fixed the defects and deployed the changes to production.

Environment: Informatica Power Center 8.1 , Crystal Reports XIR2, Oracle 11g, and Windows.

Confidential

TALS Reporting

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Build the detailed technical design document and High Level design document as per the finalized business requirements.
• Build the TALS data mart in Informatica ETL as per the technical design documents and schedule these jobs with Autosys scheduler tool.
• Created source, target, transformations, sessions, batches and defined schedules for the sessions.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Created Universes by defining connections and retrieving data from database.
• Created Mapplets and worklets and used them in different Mappings and workflows to avoid the rework the parameterized the flow.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings .
• Created Webi-reports on top of TALS Universe.
• Scheduled the Web Intelligence report from CMC as per Users requirements.
• Provided the security access management by creating users/groups and folders.

Environment: Informatica Power Center 8.1, Business Objects XI R2, Designer, Web Intelligence, CMS, Oracle 11g, and Windows.