Home

srinivas Naga venkata - Sr ETL Data stage developer/Architect

[email protected]

Location: Detroit, Michigan, USA

Relocation: YES

Visa: H1B

Brief Profile 16+ years of IT experience in software Analysis, Architect, Development, Implementation and production Support of various Client/Server and Web based applications. Has strong hands-on 10+ years of experience in using ETL and BI tools like Information Server/ Infosphere DataStage 11.7.1/11.5/11.3/91/8.7/8.5/8.1/7.5.2 and Hyperion (Essbase, HFM, MDM and FDM), customer data and data modeling, data warehousing, ETL data integration, Excellent interpersonal and mentoring skills. Experience in planning, Installation and Administration of Hyperion Essbase, HFM, MDM, Planning, FDM, CIM, IBM MQSeries, and Weblogic on various platforms like UNIX, Linux, HP-Unix, Solaris, AIX and Windows NT/2000/2003. Experience in Analysis, Modeling, Design and development (Extraction, Transformation and Load (ETL)) for Data Warehousing / Data Mart Applications using IBM Information Server 8.1/8.5 & IBM WebSphere (Ascential) DataStage7.5 (Designer, Manager, Director and Administrator). Extensive experience in technical architecture, data modeling, proof of concept, requirement study, system analysis, testing and development of decision support systems. Experience in Planning, Installation and Administration of IBM MQSeries, Websphere Application server, and Weblogic on various platforms like UNIX, Redaht Linux, HP-Unix, Solaris, AIX and Windows NT/2000/2003. Experience in working with RDBMS like, DB2, TERADATA, ORACLE and SQL Server. Knowledge across all aspects of Workflow-documenting business processes, analyzing processes, recommending improvements. Strong analytical and problem-solving skills with the ability to quickly adapt to new environments and learn new technologies. TECHNICAL SKILLS BI-DW Tools IBM Infosphere suite 11.7.1/11.5/11.3/9.1/8.7/8.5/8.1/Data Stage 7.5.2 and Hyperion System 9.3.1 & 11.x (Essbase, Financial Reporting and Planning). Cloud Tools Snow flake, AWS OS Platforms RedHatLinux-9/8/7/6/Unix/Solaris/AIX/HP-Unix and Windows 2008/2003/2001/NT Server and XP/Windows 7 RDBMS SQL Server, Oracle, DB2 and MySQL Web/ Application Servers IIS, Tomcat, WebSphere, WebLogic and Apache Web Technologies PERL, PHP, HTML, DHTML and Java Script Certification Microsoft Certified Professional (MCP-WindowsXP) (MCPID-3330418). WORK EXPERIENCE STELANITS (FCA) (AUBURN HILLS, MI) Sep 2019 to till Date ETL Infrastructure Lead & Architect Stellantis is a multinational automotive manufacturing corporation formed from the merger in 2021 of the Italian American conglomerate Fiat Chrysler Automobiles and the French PSA Group. Meeting the business teams and collecting the requirements and analyze the requirements and defining the functional designing workflows and get approvals from the business and corresponding teams. Analyze the existing solution and determine the impact of the new implantations on the business process, conduct meetings and get approvals from appropriate teams. Preparing the archtestures diagrams and get approvals from the appropriate teams. Planning the installation and migration procedures. Installed WAS cluster and deployed the DataStage/Quality Stage engine and configured DataStage/Quality Stage cluster in MPP environment. The new components like Data-stage Designer flow ...etc. Designing the custom solution for automation. Working closely with IBM team, applied the required fix packs to the environment. SSO/AD enterprise level security. Meet with business teams and the development teams and explain the ETL-workflows, get appropriate approvals from each team. Examines customer data to understand its frequency, dependency, and redundancy, and to validate defined schema and definitions. Assessing sources to support or define business requirements. Designing reference tables and mappings from source to target systems. Developing and running tests to validate successful integration or migration of data into target systems. Environment: Information Server/ DataStage/Quality Stage 11.7.1, Snowflake, AWS Information Analyser, RedHat Linux, AIX, WINDOWS, Citrix, Oracle, DB2, Oracle, SQL-Server, WAS Server. HUNTINGTON BANK (COLUMBUS, OH) Sep 2018 to till Sep-2019 Infosphere-DataStage Administrator/Architect Huntington is a full-service banking provider primarily operating across a seven-state banking franchise of Ohio, Illinois, Indiana, Kentucky, Michigan, Pennsylvania, and West Virginia. Headquartered in Columbus, OH. DataStage/Quality Stage 11.7.1 , IGC, IA, FT & IMAM Analyze the existing solution and determine the impact of the new implantations on the business process, conduct meetings and get approvals from appropriate teams. As an IIS-DataStage/Quality Stage lead reviewed business requirements and designed the infrastructure architecture. Installed Database clients like, Oracle, DB2 ..etc. Installed WAS cluster and deployed the DataStage/Quality Stage engine and configured DataStage/Quality Stage cluster in MPP environment. Installed the Infosphere components, IGC, IA, IMAM & Fast track. The new components like Data-stage Designer flow ..etc. Configured DSODB and enabled WLM (Workload manager) Resolved all kind of installation issues and documented the solutions. Working closely with IBM team, applied the required fix packs to the environment. Environment: Information Server/ DataStage/Quality Stage 11.7.1 Information Analyser, RedHat Linux, AIX, WINDOWS, Citrix, Oracle, DB2, Oracle, SQL-Server, WAS Server. ALLY FINANCIAL INC -KFORCE (DETROIT, MI) Sep 2017 to Sep-2018 IIS-DataStage Lead/ETL Lead Ally Financial Inc., formerly known as GMAC Inc. until 2009, is a bank holding company headquartered in Detroit, Michigan. DataStage 11.5 GRID environment & IGC, IA, FT & IMAM Installed WAS cluster and deployed the DataStage/Quality Stage engine and configured DataStage/Quality Stage cluster in MPP environment. Installed the Infosphere components, IGC, IA, IMAM & Fast track. To improve the performance of the jobs, made few configuration changes in the environment and code. Design and development the DataStage jobs using the InfoSphere Information server DataStage Designer client, trouble shoot the errors using InfoSphere Information server DataStage Director client. Working closely with Business analyst & Data analyst understand the business process and design the Database for DataMart and Data warehouse. Understanding the business requirements and analyze the current solution. Designing the ETL-work flows using DataStage Designer, which fit into business process. Meet with business teams and the development teams and explain the ETL-workflows, get appropriate approvals from each team. Examines customer data to understand its frequency, dependency, and redundancy, and to validate defined schema and definitions. Assessing sources to support or define business requirements. Designing reference tables and mappings from source to target systems. Environment: Information Server/ DataStage 11.5 Grid environment, Information Analyser, IGC, IMAM, RedHat Linux, WINDOWS, Citrix, Oracle, DB2, Oracle, SQL-Server and WASA Server. T.J. MAX (MARLBOROUGH, MA) April 2016 to till Sep 2017 ETL Lead/Architect/Administrator T.J. Maxx is an American department store chain, selling at prices generally lower than other major similar stores. It has more than 1,000 stores, making it one of the largest clothing retailers in the United States. DataStage 11.5/8.7 IBM Information server 11.5 installation and configuration on a distributed environment. Installed DataStage, information analyzer, IMAM and IGC. Define the security AD and Unix groups and configured IIS with LDAP. Assign the roles in the IIS console. Users mapped with DSengine credentials. Responsibilities include installation and configuration of Information Server on QA, and PROD environments. Migrated jobs from 8.7 to 11.5 and resolved the issues during migration. As a part of migration, we migrated ODBC connection, Oracle, DB2, Netezza and all RDBMS connections, resolved the Database connection issues. Installed Information Server/DataStage Clients on end user desktops/laptops/Citrix and troubleshooting daily issues. Prepared Documentation for Information server suite installation and configuration, prepared documentation for DR. Also prepared SRP s for DR. Problem determination and support during testing in DR environment. (Application support and troubleshooting) and DataStage production support. Mentor the offshore teams Environment: Information Server/ DataStage 11.3/8/7 Information Analyser, IMAM, IGC, RedHat Linux, AIX, WINDOWS, Citrix, DB2, Netezza, Oracle, SQL-Server, WASA Server, and Control-M CITIZENS BANK & INFOSYS June 2015 to till April-2016 ETL Lead/Architect/Administrator Citizens Financial Group, Inc. is an American bank headquartered in Providence, Rhode Island, which operates in the states of Connecticut, Delaware, Massachusetts, Michigan, New Hampshire, New Jersey, New York, Ohio, Pennsylvania, Rhode Island and Vermont. DataStage 11.3/8.7/8.1 &7.5.1 Mostly involved in DR exercise IIS_DS81 & IIS-DS87, Citizens does DR every quarter. Preparing the servers, file system, and storage for HADR. Configure the servers, the network, and the storage device for HADR. Prepared the HADR documentation with all the required to setups to ring up the servers during DR exercise. Involved in DR exercise and bring up the environment ever Quarter. IBM Information server installation and configuration on a distributed environment. Create Data Architect technical specification documents for extraction, transformation, cleansing, and load (ETL) programs. Responsibilities include installation and configuration of Information Server on QA, and PROD environments. Installed Information Server/DataStage Clients on end user desktops/laptops/Citrix and troubleshooting daily issues. Environment: Information Server/ DataStage 11.3/8/7/8.1/7.5.1, Information Analyser, AIX, RedHat Linux, WINDOWS, Citrix, DB2, Oracle, SQL-Server, WASA Server, and AutoSys WOLESELY INC, BURLINGTON, CANADA Nov 2014 to April 2015 ETL Lead/Architect/Administrator Wolseley Canada is the country s leading national distributor of plumbing, hydronic, HVAC/R and PVF products and solutions to professional contractors, retailers, and industrial users. With a network of over 220 branches coast-to-coast , and a national team of sales and service specialist, the Wolseley team is known for their knowledge and expertise that customers have come to rely on for their ever-changing needs. Environment: DataStage 9.1, Information Analyser, WINDOWS, Citrix, DB2, WASA Server, and AutoSys CATERPILLAR INC., Peoria, IL March 2012 to Oct-2014 ETL Lead/Architect/Administrator Caterpillar is the world's leading manufacturer of construction and mining equipment, diesel and natural gas engines, industrial gas turbines and diesel-electric locomotives. The company also is a leading services provider through Caterpillar Financial Services, Caterpillar Remanufacturing Services and Progress Rail Services. Environment: DataStage 8.5, Information Analyser, RedHat Linux, Citrix, DB2, Oracle, SQL-server, MySQL, PERL, SAP, WASA Server, Tidal, MQ series and Windows 2008. GAP INC., San Francisco, CA July 2011 to March 2012 ETL Lead/Architect/Administrator Gap Inc founded 1969, with a single store in San Francisco, A leading global specialty retailer offering clothing, accessories and personal care products for men, women, children and babies. Environment: DataStage, RedHat Linux, Aix WebSphere Application server, MQ series, Oracle, SQL Server, DB2, Tivoli work scheduler and Windows 2003 CASH AMERICA INTERNATIONAL INC, Fort Worth, TX March 2010 to June 2011 ETL Lead/ Architect/Administrator Cash America International, Inc. provides specialty financial services to individuals in the United States and Mexico with over 1,000 locations. Cash America is the largest provider of secured non-recourse loans in USA. Environment: Data stage, Aix Java, WebSphere Application server, Tivoli work Scheduler and Windows 2003 Environment: Hyperion System 9 (Financial Reporting and Planning), Java (JDK 1.2, WebLogic Server, Tivoli work Scheduler, Windows 2003. RedHat Linux and UNIX/AIX. OFFICE DEPOT INC, Boca Raton, FL March 2007 to March 2010 Administrator/Developer Office Depot, Inc. is a global supplier of office products and services. The company was incorporated in 1986 with the opening of our first retail store in Fort Lauderdale, Florida. Environment: Data stage, RedHat Linux, Sun Solaris Sparc10 (64bit), Java WebSphere Application server, Tivoli and Windows. Environment: Hyperion System 9 (Financial Reporting and Planning, HFM, MDM and FDM), Java, WebLogic Server, Windows 2003 and UNIX/Solaris. Environment: BPEL PM, MQSeries, Java (JDK 1.2), XML, ilder, WebSphere Application Server and Windows 2003. WELLS FARGO BANK, Concord, CA Sep 2006 to Feb 2007 MQ/WebLogic Administrator Wells Fargo & Company (NYSE: WFC) is a diversified financial services company providing banking, insurance, investments, mortgage and consumer finance through more than 6,000 stores, the Internet and other distribution channels across North America and internationally. Wells Fargo headquartered in San Francisco. Environment: MQSeries, RedHat Linux, Java, WebSphere Application Server, Windows NT and UNIX/Solaris. TCS (TATA CONSULTANCY SERVICES) Aug 2005 to July 2006 Sr. Software Engineer Tata Consultancy Services Limited (TCS) is the world-leading information technology consulting, services, and business process outsourcing organization that envisioned and pioneered the adoption of the flexible global business practices. Clients: Microsoft- India (HYD-GDCI), BRITISH TELECOM (offshore), GE Aviation Systems Bangalore, India and UGS Inc (Offshore). Environment: Data stage, RedHat Linux, Sun Solaris Sparc10 (64bit), Java (JDK 1.2), WebLogic Server, Tivoli, Windows 2003 and UNIX/Solaris. ANSWERTHINK (INDIA) LIMITED Feb 2005 to Aug 2005 Software Engineer Answer think is a leading business and technology-consulting firm that enables companies to achieve world-class business performance. The Global Development Center is located at Hyderabad, AP, INDIA. Environment: RedHat Linux, Sun Solaris Sparc10 (64bit), WebLogic Server, Tivoli, Windows 2003 and UNIX/Solaris. SRI CHAITANYA INFOSYSTEMS LTD. June 2001 to Nov 2004 Software Engineer Sri Chaitanya is an International Call center and Software Development Company. The collocation facility for the call center is in Miami, Florida-USA. Clients: Cavalry Investments, LLC, MCI, AV wireless, Natural Health UK Limited and Tulip UK Limited. Environment: Data stage, RedHat Linux, Sun Solaris Sparc10 (64bit), Java (JDK 1.2), WebLogic Server, Tivoli, Windows 2003 and UNIX/Solaris. MAGNA INFOTECH Jan 1999 to May 2001 Software Engineer Magna Infotech is software Development Company. The head office is located in Danbury-USA, India-Hyderabad/Chennai and Bristol-UK. # MCK (Merchant connectivity kit) Installation and Maintenance. Environment: Data stage, RedHat Linux, Sun Solaris Sparc10 (64bit) Java (JDK 1.2, WebLogic Server, Tivoli, Windows 2003 and UNIX/Solaris. EDUCATION M. Sc. From Andhra University, Visakhapatnam, AP, INDIA Keywords: quality analyst message queue business intelligence active directory rlang information technology hewlett packard California Florida Illinois Iowa Massachusetts Michigan Ohio South Carolina Texas