| Candidate Information | | Title | On-Site Architecture Design | | Target Location | US-VA-Ashburn |
| | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateAround 16+ years of total IT experience in the Design, Development, Implementation and Testing of Client/Server Applications using Object Oriented Analysis, Design and Methodologies.Worked in getting project approval by getting MOU and DSA signed. Involved in architecture design and project deadlines.Aligned the project dead line as per Agile frame work.Extensively worked on project planning with teams and stake holders.Involved in decision making for pricing for buying any new tools.Strong Data Warehousing experience using Informatica PowerCenter (10.x/9.x/8.x/7.x) (Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet, Transformations), ETL, Netezza, Oracle, SQL Server.Excellent experience in Managing the Metadata associated with the ETL processes used to populate the data warehouse. of experience in analysis, designing, development, testing, debugging, documentation and maintenance of business Applications with seven years of experience in Data Warehousing Informatica ETL (Power Center, Power Exchange)Strong experience in creating slowly changing dimensional model, Error handling and creating SDLC documents.Proficient in transforming data from various sources ( flat files, XML, MSMQ, Oracle) to Data warehouse using ETL tools.Expertise in ETL data migration to different environments and creating Production migration ticketsEducation: MS in Computer ApplicationsCertificate: Certificate of Achievement Power Center 8.5+ AdministratorAchievements:In Nomura, started my career as a senior developer and became a lead.Always delivered projects by the given dead line.Always took care of documents, which saved money and resources, and delivered things on-time.Given successful demonstrations to other teams and convinced them to use it.Great team playerFrequently worked with Business Users and team to make business processes more efficient.Learned SAS programming to convert the SAS code to ETL and SQL Server.Used Java to convert BLOB data from Oracle to Flat files using ETL.Reduce the long running job time by converting outgoing XML files to CSV.Reduced the job processing time by changing the job to load data in multiple parallel threads which saved time and was able to complete the job in the given window.Worked as Primary Production Support person. Responsible for resolving production issues and giving updates to all the stake holders.Worked as a Data Analyst and getting DSA signed for sharing data for all agencies.Analyzing Intelligent Data Management Cloud(IDMC) to convert current board processes.Reading data from AWS Aurora MySQL.Professional Experience:Federal Reserve Board, D.CIT Specialist Mar14 May 24The Federal Reserve System is the central bank of the united states. It was founded by Congress in 1913 to provide the nation with a safer, more flexible, and more stable monetary and financial system. It is the federal system, composed of a central, governmental agency The Board of Governors in Washington, DC, and the twelve regional Federal Reserve Banks. The Board and the Reserve Banks share responsibility for supervising and regulating certain financial institution and activity, for providing banking services to depository institution and the federal government, and for ensuring that consumers receive adequate information and fair treatment in their business with the banking system.Worked in a project called NIC System, where we read data from SQL server, Mainframes and Oracle transformed into XML/CSV files send it to the agencies( OCC, FDIC, SEC, NCUA..) and vice versa we get files from agencies and load into Board database. We also get data from all 12 FRB Banks.Key Responsibility:Migrated data into Azure cloud by using data pipelines.Extensively used python, Databricks script.Worked as a Admin and development of ETL pipelines.Worked in creating workflows in IICS.Migrated few workflows from on- prem to IICS.Used ETL to load data from SQL server, Mainframe and Oracle database to warehouse and send out in the form of XML files.Worked on ETL-Informatica transformation like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer to Extract Sources, Transform Data and load into Target.Migrated Informatica development code from Dev to Test and Test To Production.Worked on all the transformations like Connected and Unconnected Lookup, Aggregator, Expression, Filter, Router, Update Strategy, Connected and Remote Stored Procedure and Sequence Generator, Sorter and JAVA.Expertise in improving the session performance by making enhancements to the existing Mappings /Sessions / Database tables in ETL Informatica application.Involved in creating Data pipelines using Azure.Involved in troubleshooting the mapping and workflows/Worklets.Expertise in improving the job runtime because of huge data.Expertise in Unit testing and User Acceptance Testing (UAT) for ETL Informatica application.Expertise in troubleshooting various production issues.Worked with Curam for data model.Environment: Power Center 10.x, Windows, SQL Server Management, Oracle, Mainframe, Informatica Scheduler, In-House Scheduling tool, SQL Server, Connect Direct, Altova Spy, Change Control Management, Microsoft Office, DB2, SAS, Python, AWS Aurora MySQL, Postgres, IICS, Azure Data pipelines, Databricks, IDMC, Curam.Bank of America, NY Oct 09 Apr 11 VP, IT SpecialistBank of America is one the worlds largest bank. Worked as a VP. Managed people on-site and off shore., worked independently and communicate to various stake holders about on going and upcoming projects. Worked in Sales and reporting group.Key Responsibility:Extensively worked as BA in creating Functional and Business documents that were given to the developer.Worked with the data modeler in creating Star schema model.Used ETL to load data from Oracle database, Flat files, XML, to Netezza Data warehouse.Extensively worked on ETL-informatica transformation like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer to Extract Sources, Transform Data and load into Target.Worked as Informatica Admin.Installed Informatica Power Center 8.6 in Solaris machineUpgraded and Migrated Informatica Repository from one version to another.Troubleshooted various production issues.Worked on all the transformations like Connected and Unconnected Lookup, Aggregator, Expression, Filter, Router, Update Strategy, Connected and Remote Stored Procedure and Sequence Generator, Sorter.Expertise in improving the session performance by making enhancements to the existing Mappings /Sessions / Database tables in ETL Informatica application.Involved in troubleshooting the mapping and workflows/Worklets.Involved in unit testing and integrated system testing for ETL Informatica application.Expertise in Unit testing and User Acceptance Testing (UAT) for ETL Informatica application.Involved in Migration of folders from Development to Test and Test to Production Environment.Loaded messages using MQ series.In-charge of the nightly critical loads to meet our SLAs .Worked as a key person in monitoring reducing warehouse load time.Involved in working with off-shore and on-shore sub-contacting team.Experience in upgrading Informatica from 8.6.1 to 9.1.Experience in configuring Power Center domain, nodes, Grids and Create Different services in the Domain.Experience in applying Hotfixs, Configure OS-profiles and LDAP security.Experience in Informatica backup and restore.Experience in Assisting Developers with any issues related to ETL code.Experience in Creating Users, Groups, Roles and grant privileges to the users. Create folders, Relational and Application connections and configure the ODBC connectivity.Experience in Registering Plug-ins to connect to Applications.Environment: ETL -Power Center 7.x/8.x/9.x, Power Center B2B, Solaris 5.8, Windows XP Professional, Oracle10g, PL/SQL, TOAD 9.0, Unix Shell Scripting, Quality Center, Perforce, Autosys,Netezza4.8,Squirrel, MS project, MS office Tools.Nomura Securities Intl, NY Jan 05 Mar 08Sr. Informatica DeveloperNomura Securities Co., Ltd (NSC) provides individual clients with asset-building services that meet their particular needs over the long term. Nomura Group provides solutions through the capital markets that address the continually changing business environment and match the increasingly diverse range of client needs. With far-reaching expertise and management resources throughout the Group, we are able to respond efficiently and flexibly to offer our clients high value-added products and services.I was involved in Nomura Central Data Infrastructure (NCDI) project as a ETL Leads. NCDI Project will provide a Enterprise Data Management Infrastructure for Nomura, allowing access to integrated data that is high quality. I was involved in number of projects in Nomura as Pricing, Customer account management, Trading. Pricing were the Intraday file that used to come from NYSE.Environment: ETL -PowerCenter 7.x/8.x, PowerExchange- MSMQ, Super Glue, Linux 5.8, Windows XP Professional, Oracle10g, PL/SQL, TOAD 8.0, Unix Shell Scripting, Rational Clear Quest, WinCvs 1.3, Control-M.Merrill Lynch, NY Jun 04 Nov 04Informatica ConsultantThe broader global human resource (GHR) Re-engineering project replaces existing PeopleSoft HR system with an Oracle HRMS system as the HR system of record.The goal of the project is to design of HRMS(Human Resource Management System) Common View designed to meet the data requirements for various HR interfaces, HR data provisioning. The datamart follows Snowflake schema methodology. Datamart has divided into two CoreHR and Benefit. CoreHR consists dimensional tables like Person, Location, Organization, Headcount History, Time and Assignment is a Fact Table. Then it has level of all Sub-dimensional tables like job, EITs. Benefit consists dimensional tables like Beneficiary dependent, Plan beneficiary, Plan option, Benefit balance, HMO remittance, Plan dependent, and Plan enrollment is a Fact table. I worked as a ETL-Informatica Consultant and as a Analyst, capacity to design and develop CoreHR and Benefit. All data provisioning requirements currently supported by ML_EMPLOYEESEnvironment: ETL -PowerCenter 6.2, Sun Solaris Version 5.8, Windows 2000 Professional, Oracle9i, PeopleSoft, DB2, PL/SQL, Cognos, TOAD 7.6, ERWIN 4.x, Unix Shell Scripting, Test Director 7.x.Technical Skills:Data Warehousing:Informatica Power Center 10.x/9.x, Business Objects 5.1, Power Analyzer 4.5, Web Intelligence, Broadcast Agent, SQL *Plus, SQL *Loader, PL/SQL Developer, SQL Navigator, Erwin 3.5/4.1, Autosys, Developer 2000, Toad 8.0. IICM, IICS, AWS Aurara,MY SQL, MySQL Work Bench.Databases:Oracle, UDB DB2 7.2 (Mainframes), MS Access 7.0/97/2000, MS SQL Server, and Netezza.Web Technologies:HTML, JavaScript, VBScript, ASP, ASP.Net, VB.Net, JDBC, Applets, Servlets, Swing.Reporting Tools:Business Object 5.1, Seagate Crystal Reports 8.0/7.x/6.x, Cognos 6.0/6.5 Power Play, Brio, Data Reports, S-Designer 5.1 Case tool, Micro Strategy 7.x/6.x, SQR 3.0, S-Designer 5.1 Case tool and Microstage.Prog. Languages:C, C++, DHTML, XML, XSL, DTD, PL/SQL, Cobol, Java, Visual Basic6.0, VB.Net, Developer/2000, Perl, Unix.Testing Tools:WinRunner, LoadRunner .Environment:Sun Solaris 8.0/7.0, Windows 10, UNIX (AIX, UX).Scheduling ToolConnect Direct, In-house tool. |
