Arnab

Web Producer / Web Developer Online Brands Inc. / Critical Media LLC. | Glendale, Arizona Contract web programming using open source tools such as PHP, PostgreSQL, MySQL, Apache, Linux and others (often referred to as LAMP development). Database design, application design, site architecture design, CSS, Javascript and HTML programming to meet validation requirements. Search Engine Optimization and consulting. Technical writing and web systems administration work. Apply a wide breadth of technical skills, Internet knowledge, and experience across the spectrum of online development in the service of building and improving online properties. Web Developer / Web Master / System Administrator Arizona Internet Developers Inc. | Mesa, Arizona Served as the primary web developer on company's main web site [login to view URL]. Designed and developed a number of back end processes aimed at improving the sites overall performance, general effectiveness, usability, and search engine rankings. Worked with management to strategically plan and program applications that collected business minded intelligence and helped to better manage the site. Was responsible for maintaining the 24/7 high volume and availability demands using open source tools such as Linux, Apache, PHP, and MySQL. Converted a number of the sites applications from Cold Fusion to PHP. Normalized database tables. Cleaned up and rewrote much of the front end HTML to meet validation requirements. Wrote promotional copy and technical documentation. Worked closely with management on both online and offline marketing initiatives. Helped build the site to be one of the most popular vacation home rental web sites on the Internet until it was acquired in the summer of 2005. Web Developer The Arizona Republic. | Phoenix, Arizona Conversion of web applications written in Cold Fusion to PHP. Extensive SQL query optimization, database conversion, and custom PHP application scripting. Reprogrammed the NFL Cardinals football team website ([login to view URL]). Wrote custom JavaScript functions for statistical reporting application and assisted technically in supporting and implementing business directives concerning the Arizona Republic's flagship website ([login to view URL]). Web Developer Insight Inc. | Phoenix, Arizona Worked with a team of developers to program a temporary Internet gateway to tie together two e-commerce systems using PHP for a major Internet retailer. In addition to coding, maintained project documentation and assisted in application design. Web Developer / Project Manager Hollywood101 Productions LLC. | Atwater, California. Web Development / Design Web site design and programming using PHP, MySQL, HTML, DHTML, CSS, JavaScript, and Perl. Software used included Macromedia Dreamweaver, Fireworks and Flash, to Microsoft Front Page and Notepad to run on both UNIX and Linux as well as Microsoft IIS based server platforms. Product and Business Development Secure new business and work with clients to help plan, design and direct web projects. Assist in domain name registration, site planning and architecture, logo design, identity development, marketing, online promotion and launch. Web System Administration Set up and administration of RedHat Linux RAID server with Apache, MySQL, PHP, Sendmail and Qmail. Setup and administration of server software such as SSL, SSH, and performed basic system administration tasks. Designer / Project Manager NCS (Network Communications Solutions). | Modesto, California Project Management Coordinate and manage web development projects between design and programming staff through web development process. Team Lead Led a team in the development of an e-commerce project through first phase of development. Helped to create graphic imagery and corporate identity that was consistent with business plan and objectives. Web Design Design and implementation of web projects using HTML and ASP. Design graphics, navigation, site architecture and functionality. # Client: AIG, Parsipanny, NJ Position: Cognos Developer Environment: Cognos 8.2/8.3, ReportNet 1.1, Cognos SDK, Analysis Studio, Report Studio, ReportNet1.1, PowerPlay, Transformer, Reports, Oracle 9i, PL/SQL, SQL*Plus, TOAD 9.01.8 Description: The client had over 50 HR reports to be developed related to New Hire, Payroll, Terminations, Salary Review reports which had to be developed in Cognos. At the same time, there were performance issues with existing ReportNet 1.1 reports. Also, in the later part of the project migration from ReportNet 1.1 to Cognos 8.3 was undertaken. # Client: Time Warner Cable, Charlotte, NC Position: Cognos Developer Environment: Ascential DataStage 7.5, Parallel Extender, Cognos 8.2/8.3, ReportNet 1.1, Cognos SDK, Analysis Studio, Report Studio, ReportNet1.1, PowerPlay, Transformer, Reports, Oracle 9i, PL/SQL, SQL*Plus, TOAD 9.01.8, Windows NT 4.0, UNIX, Teradata 12.0 Description: Time Warner Cable provides services of Video on Demand to its customers. This product enables the customer to view the desired program at any time. This Project was developed to maintain the data of viewing history and related reports to viewed movies. The data comes from different divisions daily in Data Mart. Weekly and Monthly reports are given to the business users according to their requirements. Process includes providing Summary level reports to the users. Requirement was to automate the whole process of pulling data from Source, processing it through DataStage, separate the good and error records maintain incremental history and produce different reports required by management of the good data and send the error records reports back to division for correction process. # Client: Novartis, NJ Position: Cognos Developer Environment: Cognos 8 BI Series, Cognos ReportNet 1.1 (Cognos Connection, Framework Manager, Query Studio and Report Studio), Windows NT, IIS and Oracle 10gi ,PL SQL Developer, Cognos SDK, Ascential DataStage 6.0 Description: Novartis is a world leader in offering medicines to protect health, cure disease and improve well-being. The Contracts, Pricing, and Chargeback Component (CPCC) is designed to supports all health care contracts and services for pharmaceutical, medical/surgical supplies, over-the-counter (OTC), and diagnostic industries. It supports sales and marketing incentives with hospital buying groups and group members, third party administrators, drug benefit managers, and all varieties of managed care organizations. External communications with trading partners are fully automated through industry-standard electronic data interchange (EDI) formats My Job responsibilities: • Interacted with users for gathering requirements • Worked on views, stored procedures, functions in oracle using toad • Created HR reports for administrative purposes. • Prepared & Analyzed HR/Payroll metrics on recruitment, turnover, employee satisfaction, EEO, compensation, benefits, and payroll. • Planned & implemented new job coding and pay grade system • Created & maintained HR Payroll Forecast for CFO and CAO. • Evaluated & analyzed compensation data including pay equity and market competitiveness, and was responsible for calculating and tracking bonus payout amounts for all bonus eligible employees (approximately 210 corporate employees and 60 field employees) • Generated monthly medical, dental, vision, life insurance and disability billing reports, as well as track claims costs associated with companys benefit plans and coordinate with Benefits Manager on projecting insurance increases, industry trends, and actual costs. Also responsible for generating and sending data to insurance, FSA, and 401(k) carriers. • Assisted with migration of HRIS systems, including conversion of recruitment software from BrassRing Enterprise system to Virtual Edge E*Track system and conversion of Ceridian Source 550 to Ceridian HR/Payroll Web 2.0. • Created Models in Framework manager • Worked on query subjects , relation ships within query subjects,iqd’s for cubes, importing views,tables,stored procedure in Frame work Manager • Established Package security and published packages to Cognos portal • Created Complex reports using Multiple Drill through, Conditional Layout • Features, simple list reports in Cognos report studio for various departments mainly HR,Payroll and Accounts Receivable • Created Hierarchy reports using JavaScript • Created user security in access manager, scheduled reports for users to receive timely. • Deployed reports to multiple servers and tested. • Deployed reports from oracle to SQl server 2005 and converted views ,procedures ,function, in SQl server , tested reports in Cognos report studio, query studio, Power play • Prepared Test Scripts for users as to verify the reports. • Fixed the production issues, Involved in maintenance of reports in ReportNet and PowerPlay cubes • Involved in PowerPlay transformer mapping and creating security in PowerPlay cube # Client: Abbott Laboratories Position: Sr. Cognos Consultant Project: MAO System Migration Environment: Cognos 7 series(PowerPlay, ReportNet, Impromptu) , Informatica Power Center 7.1. Oracle 9i, Erwin 3.5, Cognos SDK, business Object , pmcmd scripting, Shell Scripting, PL/SQL , UNIX, Windows 2000. Description: Abbott Laboratories is one of the largest pharmacy companies in US. The objective of SCM is to streamline the flow of information through the supply chain to achieve several marketing and sales goals such as develop focused rep training programs, understand and minimize ineffective data gathering for data critical to Sales, Track competitive product sales through vendor pharmacies, Analyze and develop effective marketing to increase product sales etc. To support the above, a data warehouse was developed to generate some critical reports which aided all levels of management. The company business decisions were based on the reports produced using this data warehouse. Working under North America Sales Director in a BI group called PPD, my project include understanding requirement and suggest the model to full fill all the reporting requirements, create different reports, so that the Business managers can do effective competitive analysis, market segmentation and critical fact based decision making through report generation using my data. My Job responsibilities: • Source system evaluation, standardizing received data format, understanding business/data transformation rules, business structure and hierarchy, relationships, data transformation through mapping development, validation and testing of mappings. • Assisted in data modeling using Erwin. • Created various reports viz. List, Cross-tab and drill through as per the requirement. • Set User profiles to grant user permissions for querying. • Designed models in Framework Manager and worked with parameter maps. • Created and published packages for different functional areas and assigned security rules to them. • Worked with Complex reports in Report Studio using master-detail relationship, drill throughs, drill up and drill down, burst options, PROMPTS. • Came up with Transformer model and cubes that were used in PowerPlay analysis and also these cubes were used in various Analysis Studio reports. • Derived various complex calculations as per the report specification. • Scheduled reports using Cognos scheduler as needed. • Configured Event Studio to enable users to be notified of key operational or performance related events that may affect business. • Created scorecards using Metric Studio to reflect the strategic goals of the project. • Created dashboards for a managerial overview with drill up and drill down capabilities. • Loaded data from the load tables to the staging tables using SQL* loader. • Trained End users to operate the reports. # Client: Sprint Communications, Overland Park, KS Position: Data warehouse consultant/Informatica Administrator Project: Environment: Informatica Power Center 7.1, Impromptu, PowerPlay, ReportNet1.1 (Report Studio, Query Studio), Cognos Impromptu (V7.0, Oracle 9i, PL/SQL, SQL*Plus, SQL*Loader Erwin 3.5, Windows NT 4.0. Description: Sprint is a leading global integrated communications provider serving more than 26 million customers in over 70 countries with nearly $27 billion in annual revenues. This project involved the development and implementation of customer billing data mart according to defined business rules for strategic business analysis using extensive reporting . # Client: E-Core Technologies, Mumbai, India Position: Oracle Developer/Informatica Developer Project: Environment:,Informatica Power Center 6.1, SQL*Plus, SQL*Loader, ERwin 3.5, Oracle , TOAD, HTML, MS-Access, MS- Excel, Unix, Windows 2K, Cognos Impromptu, Impromptu Web reports, Report Net 1.1 Description: E-Core Technologies is a consulting firm providing Technology solutions to clients according to their needs. For the Fax Gateway project, we designed a fax gateway manager for Linux based platforms. We Changed the platform from Windows NT to Linux, and also created a front end for the application using DreamWeaver. @EAS, Feb 2008 – Present, One Beacon Insurance, VA This project is mainly to convert the existing VB application to JSF. IBM’s VB to JSF conversion tool is used to generate the pseudo code on which customization is done to produce working application. This is an initiative taken to remove all the Microsoft technologies application with Java/J2EE. This project has got few framework developed in house like Applet grid framework. It involved lot of custom JSF component development and dynamic component generation and rendering. Environment – Applet, IBM JSF, JSP, Servlet, Websphere Application Server, RAD, MS SQL Server 2005 Program Trader – July 2006- Feb 2008, NV Automated broking software which interacts with interactive broker application using their APIs to order stocks depending on the criteria filled on the PT screen. This involves multiple threads to deal with interactive broker to display different values on the screen. I was responsible for finalizing the client requirement. After the gather the client requirement, I handled the entire development and bug fixing phase. Environment – Swing, Java Threads, Interactive Brokers API Lottosoft – July 2004 - June 2006, White Tech Group, FL This project is to supplement the existing web based online lottery ticket purchasing system with a Java swing based client. A user can login using this client after registering himself and will provide his bank/credit card account information to play different types of lottery games like Mega-Million, Multi-match, Bonus –match, Scratch-off, Keno etc. This is a cashless process and the winning amount will be directly credited to his account and vice-versa. . I was involved for development of the entire Swing based client. I also worked in the business layer implementing business logics using EJB. Environment - Swing, EJB(CMP), MS SQL Server 2005, Weblogic 8.1 JSide – Aug 2005 – Aug 2006, Open Source Community Jside short for JavaScript Integrated Development Environment is a simple yet efficient JavaScript IDE. JavaScript has been a part of the web for long but with the advent of Ajax has become an integral one. So, Jside provides an easy to use JavaScript IDE with following features: Syntax Highlighting, Brace Matching , JavaScript Functions Outline, Syntax Check, Undo/Redo, Print Code This is an open source project. [login to view URL] I handled the print/find module entirely. I created custom file search components which were being used by this project. The component is readily available for download and use. Environment – Swing Content Distribution System – May 2004 – June 2005, WWE, CT This software is being used by WWE Corporation to distribute contents to different affiliates. It has got schedulers, query creator, transformer and publisher. There are different types of transformers which are used to convert the contents based on the affiliate’s criteria. The architecture is called as Syndication architecture. I handled different enhancement tasks which involves analyzing the existing system and proposing the best solution and after acceptance, implementing it. The critical task were, finding out memory issue there by doing memory optimization, code optimization, changing existing code to use more ajax, improvements in existing architecture. Environment - JSF, Ajax4JSF, MeadiaSurface, Hibernate, HSQLDB CashEdge Financial Product, India This project has been developed by Cash Edge and is not sold directly to the different customers. Cash Edge acts as ASP (Application service provider).Different customers include HSBC, Citibank, Bank of America, etc. They want their clients to have a facility to transfer money online from one bank to another. The product is a generic one and has been made by keeping three points in mind and has been sub-divided into three sub-modules – called Aggregation, money transfer, online account opening. I was part of the Money Transfer module, which is basically a payment gateway module. Environment - JSP, EJB(BMP), Oracle 8, Weblogic 8.1, Ant Account Receivable and Invoicing System – Jan 2002 – April 2004, Computer Sciences Corporation, India This project is meant for creating a MIS for different Healthcare Service Providers in the US Market by which they can keep records of transactions, maintain accounts created internally or by other external systems and generate invoice, late payment notifications, etc. I was responsible for following acitivities: *Integrating front end work with the back end. *Establishing CMR relationships in the Code Model *Service and Business Entities Creation *Bug Fixing *Standardizing Codes according to the company standards Environment - Portlets, EJB(CMP), DB2, WebShpere Application Server, WebSphere Portal Server, WebSphere Application Developer Suite, MQSeries, Ant Mall-CX, June 2001 – Dec 2001, CA Admin interface created to handle the internal store management of a city mall. Handles pagination, image/icon loading for different items and the store. This is a centralized system where information related to different could be stored and it will retrieve by different store owners. I completed the entire front end project myself. The front end development was done independently from the back-end development. Environment - JSP, Servlet Riottt Incorporation, June 2001 – Dec 2001, CA A rich user interface Blog site. It involved major changes in their site where it was critical not to disturb the existing work flow but to incorporate all the changes. The major changes were in the UI flow where few changes required me to alter the back-end logic/controllers. Environment - JSP, Servlet, Struts, Hibernate