Professional Summary: • Master of Technology from IIT and Bachelor of Engineering with Over 15 years of professional IT experience in Software Engineering. Managed all phases of Software Development Life Cycle that includes Requirements, Design, Development, Testing, Implementation and Support. • Experienced in various domains including UNIX Internals, Brokerage, Trading, Wireless Telecom, Accounting in Public sector, International Trade and Supply Chain Management. • Solid experience in using Business Objects XIR2/R3.1. • Significant experience in ETL technologies using Pervasive Data Integrator (very similar to Informatica). • Solid experience in using BusinessObjects XIR3.x/XIR2 (Designer, Web Intelligence, Desktop intelligence, InfoView & CMC), Business Objects SDK (Java & .NET). • Hands on experience in designing and developing Universe, BusinessObjects Enterprise administration and thorough knowledge on BusinessObjects Enterprise Architecture. • Knowledge of Data Warehousing concepts like Fact and Dimension design using Star Schema and Snow flake Schema. • Hands on experience in developing Business Objects out of the ERPs like SAP R/3, ECC, SAP BW/BI etc. • Extensive experience in using databases like Oracle and DB2. • Extensive experience in writing Stored procedures, Materialized Views, Triggers, Complex Queries, Sub Queries etc. using both PL/SQL and Transact-SQL. • Extensive knowledge in various languages like Java, J2EE, C, C++, C#.NET, JCL,COBOL, Java Script, VB Script, Advanced PL/SQL, Transact-SQL, Perl and Shell scripting. • Applied Agile/Extreme Programming (XP) development methodologies in several projects. • Knowledge on BusinessObjects XI 4.0. • Capable of working on both UNIX and Windows environments. • Experienced in working with Business Managers, Architects, End users and all the stake holders in documenting requirements, providing estimates, creating High and Detail Level design specifications. • Hands on project management experience involving estimating, scheduling, planning and monitoring resources. • Experience in coordinating with offshore team for code deliveries and other activities. • Experienced in interacting with business users to analyze the business process and requirements and transforming requirements into screens, designing, documenting and rolling out the deliverable. • Knowledge of CMM level 5 quality process. • Excellent analytical, problem solving, communication, trouble-shooting skills and interpersonal skills, with ability to interact with individuals/teams at all levels. Technical Skills:
Business Intelligence Business Objects XI4.0/XIR3.1/XIR3/XIR2 ( Business Objects Designer, Web Intelligence, Desktop Intelligence, Central Management Console, InfoView), SAP Query Builder. RDBMS Oracle 11g/10g/9i and IBM DB2 UDB. IDE Toad, PL/SQL Developer, SQL Developer, SQL*Plus. Programming Languages PL/SQL, Transact-SQL, Unix Shell Scripting, Perl, Java, J2EE, Advanced C, C++, COBOL, C# .NET. Debugging Tools dbx, kdbx, lldb and iadb Web Technologies XML, XSLT, Java Script, .NET Framework 4.0/3.5/2.0, Eclipse, HTML. Operating Systems Windows NT, Windows 95/98/2000/XP, Linux, IBM AIX, Unix, MS DOS.
US IPOD Business Unit, NY OCT 2006 � PRESENT CGI Technologies & Services (Formerly CGI-AMS) Senior Business Objects Developer/Admin
Trade360 Project: • Presently working with Proponix team performing Business Objects(BO) XI R3.1 upgrade from R2. This includes administrator activities such as installations, migrations and configuring the new software for Both Object Trade Line (OTL) and Trade Portal customers. • Work with SAP support to resolve any BO related tickets/issues. • Modify/Create new BO Deski/Webi reports and Universes. • Designed new Access Control Lists (ACL) feature in BOXI R3.1 to implement user, application and folder level security on Central Management Console (CMC). • Specified the Joins, checked the cardinalities and resolved loops by either using Aliases or Contexts. • Implemented Security Features of Business Objects like row level, object level and report level security. • Create and Build new Java applications using BO Software Development API�s. • Modify and Build C# DLL and make sure it communicates with OTL Power Builder application.
Citywide Query and Reporting Project: • Presently working with Query & Reporting team to analyze, design and construct reports from data warehouse using Business Objects XI. Pervasive Data Integrator (PDI � very similar to Informatica) is used to populate data from OLTP application database to data warehouse. • Designed and developed Universes using Business Objects Universe Designer. • Designed and created WEBI reports using Web Intelligence Rich Client and InfoView. • Created reports involving table/section breaks, multiple data providers and derived tables. • Coordinated with offshore team for report deliveries. • Converted about 120 DESKI reports to WEBI using BO Conversion tool. These processes also involved analyzing the SQLs more closely and modify the prompts and objects in WEBI reports. • Used Import Wizard Tool to create BIAR files and assisted CM team to deploy them onto Integration environment. • Used Rational Clearcase for version control of report wid and BIAR files.
Citywide Interfaces Project: • Implemented extraction/transformation/load (ETL) interfaces to facilitate transitioning from old legacy mainframe systems to Oracle systems. • Created complex transformation maps using PDI Map Designer for encapsulating data in XML format. With the help of shell scripts, this data is then loaded & submitted onto AMS advantage database. Acted as Subject Matter Expert (SME) in guiding offshore team to create few transformation maps. • Designed more than 50 interfaces as per client requirements and had continuous meetings with them to ensure they are concurred. • Developed various shell scripts using Korn shell to extract, transform and load the agency data. • Designed Interface Manager framework which involved creating new tables, use cases and mockups of application screens. These screens were then built using IBM WebSphere Versata software. • Designed Open Items Extract (OIE) processor to extract data from Oracle tables and created pipe delimited files. This data was then sent to other City agencies for further processing. OIE processor was implemented fully as standalone J2EE application. • Developed few COBOL programs to load data from flat files to IBM DB2 tables. Coded JCLs to invoke these COBOL programs and other DB2 utilities. • Worked very closely with offshore team to deliver all the interfaces before the deadline. • Worked extensively with Integration and System testing teams to ensure all Interfaces were ready to be deployed on Production servers before go-live. • Functioned as UNIX SME to review all the shell scripts developed by the entire team and provide technical guidance on UNIX related activities. • Used Rational Clearcase for version control. • Used Rational ClearQuest for accessing defects. Technologies: PDI (ETL) maps, Korn Shell scripting, SQL, PL/SQL, BOXI R2 and R3.1, WEBI and DESKI, XML, COBOL, JCL, DB2, J2EE, Oracle, Weblogic installation and configurations, and AIX 5.3.
Verizon Wireless, NY APR. 2006 � OCT.2006 Orangeburg, NY Senior System Software Engineer
Responsibilities involved maintaining & enhancing a Pro*C/C FraudPlus telecom application. • FraudPlus is a cloning and subscription fraud detection tool used by Verizon Wireless. It proactively detects fraud by analyzing cellular call activity and other data. These applications collect real-time cellular call activity from all home switches and roam switches connected to the RoamEx network and daily CIBER file. • Work also included designing and prototyping for rewriting the entire FraudPlus application using C/C++, Oracle 10g, & MQSeries. Technologies: C, C++, Pro*C, SQL, Shell Scripting, Perforce, Oracle and Solaris, IBM MQSERIES.
BANK OF NEWYORK Aug.2001-Apr.2006 Senior Software Engineer/Lead
IBM Oct. 2000-July 2001 Austin, TX Software Engineer
• Provided technical support to IBM OEM/IHV for Native Device Driver Interfaces & Uniform Driver Interface (more commonly known as UDI) on AIX5L for IA64 operating system (previously known as Monterey/64). • Worked as an interface between the hardware vendors and device driver team. • Was involved preparing a common device driver kit (DDK) for Both Power and IA platform for technologies like storage (SCSI & Fiber channel), graphics, and network, TTY. This included writing makefiles, making sure that the drivers build outside the AIX development environment (ADE) on the respective platforms and packaging these drivers in installp format. Kernel debugger was used to debug the problems reported by the vendors. Development was done in C.
IBM Global Services July 1997 � Oct.2000 Bangalore, India &Poughkeepsie, NY Software Engineer
• Performed Functional Verification and Testing (FVT) of Data Management Application Programming Interfaces (DMAPI) for General Parallel File System (GPFS) on Scalable Power Parallel (SP) nodes. Coding was done mainly in C and shell. • Functioned as coordinator for IBM India GPFS FVT team. This team was focused on enhancing Auto test Scripts to include Quotas/ACLs functionality. Auto test is a tool used by GPFS FVT and System testers at IBM, Poughkeepsie. • Implemented enhancements for AIX RAS. RAS is abbreviated term for Reliability/Availability/Serviceability. The main object of the project was to incorporate Compression algorithm for compressing the system dump. Standard LZW algorithm was used for achieving the same. Some utilities related to system dump like crash etc., were also updated to cater to the new feature. The scope of the project also included Unit testing, FVT, CMVC, & three-week support period for the enhanced code. • Provided level 3 technical support to AIX customers worldwide.
Education: Master of Technology (Instrumentation) from IIT, Kharagpur, India. Bachelor of Engineering (Electronics & Power Engineering) from Vishveshvaraya Regional College of Engineering, Nagpur, India.