Software Engineer resume examples

Project : Crisis management Application (CMA)
Desc      :  Usage of the Crisis management Application (CMA) to provide a management structure and system for conducting operations. It provides the flexibility needed to rapidly activate and establish an organizational format around the functions that need to be performed. “Alert notification” with a sophisticated message sorting and distribution capability so managers can track and log multiple and varied notifications and ensure that the right information gets to the right individual.

• Modified existing software to correct errors, upgrade interfaces and improve performance.
• Wrote maintainable and extensible code in a team environment.
• Oversaw major new enhancements to existing software systems.

Project : I-TRACKER
Client   :  ICICI BANK
Desc      : In this Project, "iTrack" is ICICI Bank's official deliverable status tracking application. The deliverable status can be tracked through the iTrack link on www.icicibank.com or through iTrack option in ICICI Bank's mobile banking app iMobile.


• Understanding and analyzing the client's requirement and involved in GUI designing of the application.
• Responsible in implementing the system using Asp.Net MVC 5, Entity framework and SQL Server 2012.
• Wrote the stored procedures. Management of applications in perspective of coordination with the Infra team for change requests/enhancements.
• Worked closely with clients to establish problem specifications and system designs.

Project: Discoverer Replacement Project.
Oregon Health & Science University (OHSU) is a public university in Oregon with a main campus, including two hospitals, in Portland.

OHSU is the state's only academic health center.

It provides an uncommon array of services from providing the state's most comprehensive health care, to educating the next generation of clinicians and biomedical researchers, to achieving breakthroughs and innovations.All the existing reports of University and operations are based on Oracle Discoverer and the scope of discoverer replacement project is to convert all the existing reports into Cognos. 
Roles & Responsibilities:

• Designed solutions based on data warehousing best practices, documented and trained other developers.
• Implemented securities at data, object and package level.
• Worked on framework manager, to import metadata from data source and maintain business models, securities and publish packages to Cognos server.
• Involved in solutions at framework manager model level and report level.
• Analyzed and created usage reports based on discoverer metadata (EUL tables).
• Worked on, Drill through reports, Conditional Layout reports and extensively worked on Cognos Workspace advanced for creating adhoc reports.
• Created templates and developed complex (list, crosstab, drill through, master detail, dashboard etc.) reports using report studio.
• Implemented bursting of reports with dynamic email subject.
• Worked on conditional styles and using different variables and different Formatting types.
• Created filter, prompts, and calculations to customize the package for different report authoring.
• Implemented busting to automate report scheduling with dynamic email subject.
• Scheduling the reports according to user requirements in Cognos, implemented trigger based scheduling.
• Created usage reports using audit package and Cognos content store tables.
• Created Different types of active reports.
• Involved in the creation of Report Documents, Unit Test Cases, and Smoke tests.
• Environment: Cognos 10.2.2, Cognos 10.2.1, Oracle 11g R2, IIS, Windows 2012 Server.
  

Project: Customer Satisfaction Survey Project.
IBM India Pvt.Ltd is one of the largest providers of software tools and services in the world.IBM conducts Customer Satisfaction reviews in order to know the customers feedback on the tools. CSAT (Customer Satisfaction team) categorizes all the feedback's and designs reports which are viewed at Vice-President Level for decision making.

Roles & Responsibilities:

• Understood the existing architecture and identified few irregularities.
• Proposed a new solution to organize the reports under Geo, Brand buckets.
• Implemented the above solution with careful division of reports with a new frame work manager model.
• Designed packages for the report studio authors.
• Created Dashboard reports, implemented drill through functionalities.
• Involved in conversion of existing Excel reports into Cognos.
• Used Prompts and Prompt tokens effectively for merging many excel reports to Single Cognos report.
• Worked on Conditional formatting, Unions and Joins.
• Used Event Studio for scheduling.
• Implemented Package, Object and Data level securities.
• Worked on extensively on Date prompts for creating YTD reports.
• Created report documentation and related tech specs.
• Environment: Cognos 10.2, Cognos 10.1.1, IBM DB2, IIS, Windows 2008 Server.

Project: Sales Reporting Center Of Excellence Project 
IBM India Pvt.Ltd is one of the largest providers of software tools and services in the world.IBM is having five brands and six sectors.Previously IBM was having around 10,000 excel based reports worldwide which were used by 6000 sales people.The goal of this project is to categorize all the legacy reports into standard 10+5 buckets of reports in Cognos. 
Roles & Responsibilities:

• Involved in Sector specific reports and created Pipe line reports, GAP analysis and Top Sheet reports. These reports are used by sales managers to analyze the sales stages for each quarter and each week to improve their sales in corresponding sectors.
  
• Created dashboard reports for Sales leaders in order to easily identify the top and bottom performing Brands, Sectors.
• Unions and joins used in reports to get data from different sources, which is not joined at model level.
• Created different types of reports like List, Cross-tab and Chart.
• Created various kinds of Filters, Prompts and Cascading prompts.
• Implemented drill through functionalities for charts.
• Worked on report performance issues of existing reports.
• Used Prompts and Prompt tokens effectively for merging many excel reports to Single Cognos report.
• Developed Test Case reports for QA.
• Created report documentation and related tech specs.
• Involved in Weekly Sanity Testing.
• Involved in solving the different types issues in Model as well as in reports.
• Environment: Cognos 10.1.1, IBM DB2, Informatica, IIS, Windows 2003 Server.

Project: Sales Enterprise Data Warehouse (SEDW)
Toyota is one of the biggest manufactures of Automobile parts, ranges from Heavy Vehicle to Small Vehicle in USA, and a wide network throughout the globe.Being one of the oldest and strongest competitors in the automobile parts production more than 1000 categories of parts are supplied to the Vendors across the globe.The company set to Cognos enterprise BI solution that could provide the company as analysis and reporting to help the sales information particular area wise sales, product wise sales and generate the reports monthly, quarterly and yearly sales, this reporting helpful to improve the company product sales and the information from the distributors.

Roles and Responsibilities:

• Installation and Configuration of Cognos 8.4 client tools like Framework Manager.
• Developed metadata models (Star and Snowflake schemas, DMR's) using Framework Manager.
• Developed complex reports (crosstab, list, chart) with custom sorting, prompt validations, Drill-Through, conditional formatting, cascading prompts, Reports on OLAP Data Sources and bursting reports.
• Worked on designing multi-dimensional cubes using Cognos 8 Transformer and deployed packages for reporting.
• Analyzing the changes requested for the reports from the specification and identifying the gaps.
• Involved in preparing/Updating Low Level Design Documents for Framework Manager.
• Involved in Creating / Updating Framework Manager Models.
• Create complex reports in Report studio.
• Preparing the Test cases for the reports based on the spec.
• Create Code Export file to move the package and reports to TEST environment.
• Designed drill through reports for analyzing the business performance.
• Scheduled reports using event studio.
• Environment: Cognos 8.4, Oracle 9i/10g, Informatica, IIS, Windows 2003 Server.

Project: BHCS (Baxter Health Care System)
Baxter International Inc. (NYSE:BAX), through its subsidiaries, develops, manufactures and markets products that save and sustain the lives of people with hemophilia, immune disorders, infectious diseases, kidney disease, trauma, and other chronic and acute medical conditions.As a global, diversified healthcare company, Baxter applies a unique combination of expertise in medical devices, pharmaceuticals and biotechnology to create products that advance patient care worldwide.Baxter had sales of $12.6 billion and has approximately 49,700 employees.

• Developed relational and dimensional framework manager models.
• Interacted with ETL team and business users to gather technical specifications.
• Identified facts, dimensions, hierarchies while creating dimensional framework manager model.
• Created model query subjects, calculations, filters, determinants and conformed dimensions.
• Created regular dimensions, measure dimensions, scope relationships, hierarchies, levels and determinants.
• Designed and developed list reports, master detail reports, cross tab reports, charts, drill through reports and dashboard reports.
• Managed Cognos Connection Portal and assigned users, roles and groups for authentication and authorization.
• Performed unit testing and coordinated with end users during User acceptance testing.
• Worked on performance issues of the reports.

Project: Sales Management Reporting 

Elite Handcrafts is into wholesale business based in Brisbane, QLD.

They supply unique, high quality and very different products imported from India to various customers . They use excel based show their business status to different wholesale dealers as well as retail dealers. The goal of this project was to implement cognos and migrate all the legacy reports.

Roles & Responsibilities:

• Working closely with ETL teams during designing Summary tables/ views/ materialized views for reporting.
• Used Report Studio to develop various types of reports like List Reports, Cross tab Reports Chart Report & Master Detailed Reports as per the client requirements.
• Involved in creation of Drill -Through and Master-Detail reports.
• Prepared various reports using cascading prompts, Text box prompts and value prompts in Cognos Report Studio.
• Developed reports based on conditional formatting.
• Created reports Views and scheduled in Cognos connection.
• Environment: Cognos 8.2, Oracle 9i, SQL Loader, Apache, Linux 4.0.

Project: Zeta Mail Database Management 
Zeta Interactive leading provider of integrated interactive services, Zeta Interactive helps Today's marketers realize the full potential of the Internet to build brands, increase sales, Improve processes and reduce costs.

Roles & Responsibilities:

• Database, tablespace creation and maintenance.
• Monitoring Space (Table spaces, Extents) and allocating if needed.
• Monitoring Alert logs for any oracle errors and fixing.
• Responsible for managing users, roles and profiles.
• Cloning Production Databases for Testing Purpose Periodically.
• Database security planning and implementation and User creation and maintenance.
• Backup and recovery (Hot and Cold backups, RMAN), Archive log maintenance and clean up.
• Export /Import of whole database or selected schemas.
• Created and managed users, roles and groups and responsible for database high availability.
• Environment: Oracle 9i.