Sr Developer & Analyst
Resume:
Ponmalar Mani
************@*****.***
Visa Status: EAD
OBJECTIVE
To pursue a challenging career in BI and Data Warehousing design and development where my problem solving skills, expertise and application knowledge can be put in for the betterment of the organization.
PROFESSIONAL SUMMARY
• 4 years of comprehensive software development experience in all phases of a project/product development, requirements gathering & analysis, system architecture, implementation, testing and deployment.
• Worked extensively in MSBI (SSIS, SSAS, and SSRS), SQL Server, and Oracle 8i/10g.
• Expertise in Integration Services (SSIS) to populate the data store and skilled at development of mappings according to the ETL Specifications.
• Experienced in developing and maintaining the Cube through SSAS.
• Experienced in creating reports using SQL Reporting Services 2008.Fetching data from SSAS using MDX and also fetching data from data warehouse using SQL.
• Extensively Used Microsoft Office SharePoint Server 2007(MOSS) and Microsoft Windows SharePoint Services (WSS) 3.0 for Portal Management, Configuration, Application and Development.
• Strong in Data warehouse and RDBMS Concepts.
• Experienced in Physical and Logical Data Modeling.
• Good in writing Stored Procedures, Triggers, Views on MS SQL Server 2008 and Oracle 8i/10g.
• Excellent communication, analytical and presentation skills. Flexible to work on different technologies and domains.
EDUCATION
Bachelor of Engineering (Computer Science and Engineering)
Bharathiyar University, Coimbatore, India.
TECHNICAL SKILLS
ETL Tools SSIS 2008
OLAP/ Reporting Tool SSAS 2008, SSRS 2008, Crystal Reports
Languages Java, SQL, PL/SQL, T-SQL
Web Technologies WSS 3.0, MOSS 2007/2010, HTML, JavaScript
Database SQL Server 2008, Oracle 8i/10g.
Middleware/Libraries COM, ODBC
Operating systems Windows NT 4.0/95/98, Windows 2000
Version Control Visual Source Safe
Modeling Tools Erwin
WORK EXPERIENCE
D&B, NJ Jan 2011 - Aug 2011
Project: The Finance Data Mart Consolidation
Project Description: This project was targeted to consolidate the Canadian Finance systems to an existing US system and as well as to move the Canadian history data to the US system. This included changing all the reporting systems to show the Canadian billing information and as well to make changes in the upstream and downstream applications. This project aimed in removing the cost to the client in terms of maintenance of servers, sales force for the Canada region.
Responsibilities:
• Understand the existing Canada Data Mart and Data Load process.
• Involved in HLD and Detailed design document preparation.
• Created mockup reports based on the design.
• Design and development of the dimensional model.
• Involved in performance tuning by optimized query and SSIS packages.
• Creation of SSRS reports fetching data from Data Mart and by using cube.
• Performed Unit testing and supported QA, UAT phases.
• Getting Customer Feedback during Project Milestone and ensuring Customer Satisfaction.
• Created user manuals.
Environment:
SQL Server 2008 (SSIS, SSAS, SSRS), Oracle 10g.
D&B, NJ Oct 2009 - Nov 2010
Project: Decision Support System for Revenue Analysis
Project Description: This Data Mart is responsible for fulfilling all reporting requirements for Revenue Analysis. The Data Mart is populated on daily basis from underlying OLTP Application using scheduled ETL Packages. This application is used to analyze products ranking based on the Net Revenue, Sales, and Qty & Gross Margin. The cube data was with MS Excel Pivot tables’ services for reporting. Dynamic ad-hoc reports were also built to analysis the current and past trends and thus to provide desired information to the Top Management to make more informed decisions.
Responsibilities:
• Understanding base data, Analyze and Design Project requirement
• Involved in the data extraction from data mart into EXCEL spreadsheets for analysis
• Involved in HLD and Detailed design document.
• Design and development of the dimensional model.
• Developed T-SQL procedures for SSIS packages.
• Developed Cubes and storage from the OLAP data for the multidimensional analysis
• Responsible for developing different types of SSRS reports i.e. drilldown reports, sub reports, reports with groupings etc
• Involved in Unit testing.
Environment:
SQL Server 2008 (SSIS, SSAS, SSRS), Oracle 10g, WSS 3.0
D&B, NJ August 2008 - Sep 2009
Project: The Sales Data Warehouse
Project Description: This project was targeted to create a Sales data warehouse which helps the sales force to develop strategies on improving the product sales based on the reports. The sales warehouse contains data related to the company’s sales metrics like no. of units sold, dollar amount of sales, and the number of unique customers in a segment and as well as to prepare reports based on the products, product category/class, brand, store location (city, state, region and country) customer demographics, and also by individual promotions and promotion categories.
Responsibilities:
• Created packages for data transformations using look up, merge join, conditional split, derived column components and adjusted the buffer limit to optimize the performance.
• Created mockup reports based on the design.
• Responsible for developing different types of SSRS reports i.e. drilldown reports, sub reports, reports with groupings etc.
• Perform peer review on the reports and ensure it complies with client standards.
• Perform Unit testing and provide support to QA and UAT phase.
• Support the QA team during Test case documentation.
• Conduct training sessions for the users and create user manuals on reports.
• Get Customer Feedback during Project Milestone and ensuring Customer Satisfaction.
Environment:
SQL Server 2008 (SSIS,SSAS, SSRS), Oracle 10g, MOSS 2007.
Kinship Technologies Ltd, Chennai June 2004 – August 2005
Project: Round the Clock (Product)
Project Description: Round The Clock is a powerful evaluation system for the corporate sectors with the Objective focused towards PERFORMANCE, INNOVATION and LEARNING (PIL). RTC System has various modules to its credit apart from Evaluation such as Knowledge Management and Take a Break. RTC System is a module based and the system can be broken into various components and installed based on the customer needs. Round the Clock evaluates the performance of the whole organization based on Corporate Objective and Business Objective as well as Specific Individual Objectives. Performance Goal Setting is evaluated by using this product. From the top level or Bottom up strategy the performance is evaluated based on their requirements.
Responsibilities:
• Involved in database design.
• Involved in writing PL/SQL program, JSP and Servlets.
• Involved in Unit and Integration testing of the batch programs.
• Managed the integrity constraint for all tables in the database.
• Interacted with the client to discuss the requirements.
• Used JDBC to establish the connectivity between webpage and database.
• Generate the reports for viewing performance report of every individual in the organization by using the Crystal Clear tool.
• Interacted with customers to ensure the reports should satisfy their need.
Environment:
Jbuilder7.0 EE, JBoss 3.0.2, Oracle 8i, Inet Crystal Clear
Contact this candidate