SUMMARY OF EXPERTISE:

• Over three years experience in IT domain and performed business data modeling, software requirement
• analysis, process modeling and quality assurance analysis.
• Gathered project requirements on interaction with stakeholders/end users/customers/project managers/
• senior management/clients and translated them into Business Requirements Document (BRD), Functional
• Requirements Document (FRD) and System Design Specification (SDS) to create test cases.
• Played key role in developing the “As-Is” and “To-Be” business process, data flow diagrams for new
• projects.
• Experienced in System Development Life Cycle (SDLC) process, involved in Agile/Scrum development
• methodologies for requirements gathering, business case development, data process flow, work flow and
• defined strategic solutions for support and maintenance of the system.
• Run ad hoc data queries from multiple database types to resolve data inconsistencies and assisted in database
• design, ERP implementation, report generation and maintenance of databases.
• Experienced in installation and configuration of Cognos BI suite(8.1, 8.2, 8.3 & 8.4 versions), Cognos
• Transformer, Cognos Power Play
• Created business models and generated reports using Cognos Framework manager
• Implemented data security privileges for Object level access , data access and Package access for users
• Efficient with Report Studio, Query Studio and Analysis Studio and built Framework Manager Models, and
• Data cubes based on business requirements
• Worked on ETL Tools: IBM Datastage Manager, Designer, Administrator, and Director.
• Implemented various strategies for Extraction, Transformation, Loading processes.
• Designed Server jobs, Job Sequencers, Batch Jobs and Parallel jobs using Datastage ETL tool.
• Designed Parallel jobs using various stages like join, merge, lookup, remove duplicates, filter, dataset,
• lookup file set, modify and aggregator.
• Experienced in integration of various data sources (IBM DB2, SQL Server, Oracle 9i/10g, and MS-Access)
• into data staging area.
• Developed PL/SQL packages and stored procedures to load data from data sources to data ware house
• Experienced in developing multidimensional models and Power Cubes for distribution using PowerPlayTransformer

TECHNICAL SKILLS:

Operating System: Windows 95/98/NT/XP/Vista/7, UNIX, Linux, DOS
Databases: Microsoft Access 2007, MS SQL Server 2005, Oracle 9i/10g, IBM DB2
Languages: C, C++, SQL, HTML, XML, PL/SQL
Software Packages: Microsoft Visio, Microsoft Office Suite, Microsoft Project, Adobe Photoshop, SQL*Plus
tool, Microsoft Visual Studio 2008, Toad 4.1
ETL Tools: IBM Datastage, Informatica Power Center
Business Intelligence tools: Cognos 8.4

CERTIFICATIONS:

• Oracle PL/SQL Developer Certified Associate (OCA) September 2009
• Oracle 9i Database Administrator Certified Professional (OCP) October 2009
• Oracle 10g Database Administrator Certified Professional (OCP) October 2009

WORK EXPERIENCES:

B.I Developer – Brite Systems, Confidential,Dec 2010- Current

• Interacted with stakeholders/clients to gather business requirements for developing reports for applicants in the State of Indiana who require Food stamps, Medicaid and TANF.
• Evaluated the alignment of Cognos reports with end users.
• Scheduled and published daily reports, monthly reports and quarterly reports to the end users.
• Responsible for designing ETL process to structure the data warehouse as per the business requirements
• Modified packages to suit the business needs and improved the performance of the reports by defining filters
• and adding calculations.
• Coordinated with source system owners, day-to-day ETL progress monitoring using Datastage tools such as
• Datastage Administrator, Manager and Designer.
• Experienced in designing Server/parallel Jobs using DataStage 8.0 to populate tables in Data warehouse and
• Data marts.
• Extperienced in PL/SQL, T-SQL, Stored Procedures, Database Triggers and SQL * Loader
• Incorporated various data sources such as Oracle, MS SQL Server, DB2, XML ,flat files into the staging area.
• Worked on Framework manager to import metadata from multiple data sources.
• Developed complex reports such as - list, cross tab, repeater, Drill through, master-detail, chart and complex
• reports which involved multiple prompts, filters, reports against multiple databases using Report Studio
• Scheduled reports through Event studio schedule management in Cognos Connection.
• Created and published packages using framework manager to generate Cognos reports and worked on Power
• play Enterprise server for cube deployment.
• Performed Unit testing and Functional testing for all the developed reports and migrated reports using
• functional build document.
• Attended daily and weekly meetings with end users/clients and involved in code reviews, technical reviews
• with database team.
• Provided 24/7 User Support and end user training.

I.T Engineer – Confidential,Phoenix, AZ Dec 2009- Nov 2010

• Managed IT department operational and strategic planning, analyzed business requirements and allocated
• resources. Developed financial strategies to be aligned with IT and end results.
• Designed and maintained SQL Server 2005 database to optimize inventory management and also experienced
• in performance tuning, SQL tuning, SQL Trace, TKPROF to improve database performance.
• Implemented wireless scanners for daily paper roll counts that were automatically synchronized with MAS
• 500 (ERP). Ensured availability of real time data eliminated manual data entry errors and reduced shipping
• time by 25%.
• Installed applications such as Quick books 10.0 (accounting software) and MAS 500 (ERP) software
• applications on Terminal server( Windows server 2008)
• Administrator for Windows Exchange Server 2003 managed Group policy, user accounts, access controls,
• and domain structure. Experienced with Active Directory, DNS, DHCP and maintenance.
• Responsible for IT systems management and provided technical support & troubleshooting for two sister
• companies located in Arizona.

Data analyst Intern - Confidential,Chennai, India Jan 2009-Sept 2009

• Maintained 1TB electronic sales database using Oracle 9i on Linux OS and developed disaster recovery plan,
• change management, business continuity to support project requirements and inventory functions.
• Experienced in RDBMS, Data warehouse, ETL, Business Intelligent reporting, backup & restoration
• procedures, export/import of data, capacity planning, performance tuning and SQL tuning.
• Served as liaison between Data Architects and Managers by translating business requirements into technical
• design and communicated changes to financial analysts, web development team and system analysts.
• Managed enterprise backup systems, database backup and disaster recovery, specialized in RMAN backup,
• restoration procedures, export/import of data, SQL*Loader.
• Performed Data modeling using MS Visio and ERwin tools.

Database Developer Intern- Confidential,Syracuse, NY Aug 2008-Dec 2008

• Designed “Volunteer database” for Salvation Army data management program using MS Sql Server 2005.
• Implemented methods to expedite data intake in the system and automated database update functions such as
• volunteer’s daily schedule, wages/hour, amount collected as donations and other events in the database.
• Created use case specifications, business flow diagrams, activity/state diagrams , sequence diagram, data
• flow diagram and entity relationship modeling using MS Visio.
• Assisted IT Manager in defining the scope of the project, work schedules, budgeting and resource allocation.

Project Engineer Intern, Confidential,India Dec 2005 – May 2006

• Engineered and implemented a bit synchronizer system to decode data received from satellites.
• Devised simulation, analysis and synthesis of the above system using MATLAB and digital signal
• processors.
• Analyzed business requirements for secured transmission of confidential data and demonstrated team work,
• problem solving, time management and presentation skills.
• Resulted in launch of this system as a new product and reduced production time by 25%.

EDUCATION:

Master’s in Information Management Aug 2006-Sept 2009
Confidential,University, NY 
Bachelor of Engineering in Electrical & Electronics Engineering June 2002-May 2006
Confidential,College of Engineering, Confidential,University

ACADEMIC PROJECTS:

Project management & Risk management

• Prepared business plan, project charter, Work Break Down (WBS) structure, critical success factors, SWOT
• analysis, budget analysis and created reports using MS Project based on PMI standards for many
• organizations.
• Interacted with stakeholders to gather project requirements, developed Gannt charts, cash flow analysis and
• evaluated the alignment of IT and business strategies.
• Developed risk management strategies, GAP analysis, cost benefit analysis, credit & operational risk analysis
• and used SAS software to identify potential risks associated with projects.

Database management system

• Conceptualized an innovative database management system using Oracle10g that enabled staff to improve the
• academic activity of students and possess strong expertise in forms, reports, queries, stored procedures.
• Performed data normalization, database modeling, strategic ERP (Enterprise Resource Planning)
• implementation resulting in improved performance and effective space management of the database.
• Modeled unstructured data from disparate sources into a standardized model using MS Visio and MS Access

Strategic management of information resources & Scenario planning analysis

• Examined and presented critical business strategies (past and present) adopted for different organizational
• settings and evaluated success criteria based on throughput, revenue growth of organizations.
• Worked on case studies as System analyst and developed new systems based on SDLC methodology and
• demonstrated UML diagrams to substantiate feasibility of innovative projects.

Web architecture: content management for Internet services

• Executed critical analysis of web design based on CRM and transformed static website to XML website.
• Customized interactive websites and presented strategies based on industry specific metrics, internet privacy,
• information security, Information architecture framework, customer satisfaction and Ecommerce.

MANAGEMENT /LEADERSHIP ACTIVITIES:

• Co-founded ISA (Indian Student Association) at Syracuse University acquired sponsorships and managed
• various cultural programs.
• Presented research on IT driven business issues like internal controls, regulations like SOX, GLB, HIPPA.
• Worked as an IEEE member and streamlined diverse workflows in organizing academic events in college.