SUMMARY

• Over Seven years of extensive experience as a business data analyst.
• Experienced in complete Software Development Life Cycle (SDLC) covering Requirements Management, designing data flow diagram, process flow diagram and business and functional requirement documents.
• Data Analysis, Data Modeling, System Analysis, Architecture and Design, Development, Testing and Deployment of business applications.
• Experience in providing reporting analytical thinking, process improvements, problem solving, time management, decision making and issue resolution.
• Strong Data Modeling experience using ER diagram, Dimensional/Hierarchical data modeling, Star Schema modeling, Snow - flake modeling using tools like Erwin, ERStudio.
• Proficient in Dimensional/Hierarchical data modeling, Star Schema modeling, Snow-flake modeling using tools like Informatica.
• Extensive experience in gathering business requirements, implementing business processes, identifying risks, impact analysis, UML modeling, sequence and activity diagrams and using Rational Rose.
• Good experience with RUP (Rational Unified Process) to configure and develop processes, standards, and procedures.
• Extensive knowledge of Data Warehousing using Informatica, Project Planning and Requirements and Data Warehouse Deployment.
• Full understanding of the ETL (Extract, Transform and Load) solution concepts and functional knowledge and extensive experience of Informatica.
• Well versed with various software development methodologies (SDLC, Agile Methodology, Extreme Programming, and MSF).
• Good working knowledge of Web Intelligence and Desktop Intelligence and able to access reports from InfoView to create ad hoc reports, specify filters, modify and publish reports in different formats.
• Strong understanding of Oracle Databases and SQL Servers and able to perform basic functions, generated queries, usage of different PL/SQL Operators and data manipulations.
• Experienced in using PL/SQL & SQL queries to validate data in Oracle and SQL Server.
• Proficient in Data Modeling concepts and usage of ERWIN and Informatica tools.
• Proficient in MS Excel Functionalities. (Pivoting and other BI).
• Strong Documentation skills in conducted data modeling review sessions for different user groups, participated in requirement sessions to identify requirement feasibility.
• Goal and team oriented work independently and good peer mentor.
• Exceptional ability to maintain and build client relationships, able to comfortably converse with all facets in the client’s organization for gathering requirements and validation.

TECHNICAL SKILLS

Operating Systems: Windows7/Vista/ XP/2000, UNIX

Databases: Oracle, SQL Server, Microsoft Access

Statistical: Microsoft Excel, SAS

Business Intelligence Tools: Informatica, Business Objects, Infoview, Web Intelligence, Desktop Intelligence

Data Modeling Tool: ERWIN, ERStudio, Schema (conceptual, logical and physical)

Computer Skills: Microsoft Excel (Data Functions, Pivot Tables etc.), Microsoft Access and Microsoft SQL ServerAnalysis Services, SAS, PL/SQL, Microsoft Visio, PowerPoint.

PROFESSIONAL EXPERIENCE

Confidential, Manhattan, NY.

Business/Data Analyst

Responsibilities:

• Responsible for complete life cycle implementation that encompassed Business Requirement gathering, analyzing their source systems and then building a new data mart in order to provide functionality for their reporting purposes.
• Understand and articulate business requirements from user interviews and then convert requirements into technical specifications Documents.
• Experienced in creating UML and Business and Functional Requirements Documents
• Responsible to investigate data discrepancies between the existing reporting system and a new data warehouse system.
• Navigated table relationships through both a 3NF system and a star schema.
• Implementing source procedures to the existing logic to help identify whether the new data warehouse matches that logic.
• Used profile data to understand potential weak points in the reporting data.
• Documented Database Issues and Send to Information Technology for Correction.
• Communicated with Informatica (ETL) developers in order to figure out where and why a data discrepancy exists.
• Involved in Report writing using Business Objects.
• Created and Maintained Oracle Databases, using Modules, Reports, Queries and PL/SQL, for Call Center.
• Recommended System Changes and Enhancements.
• Involved in troubleshoot data issues using Query Analyzer, and Enterprise Manager Tools.
• Created Custom Reports and PL/SQL Queries using Inner and Outer Joins.
• Performed Sales analysis and projections using Access and Excel.
• Created, published, scheduled and maintained Business Objects, InfoView reports publisher, Business Objects Console Management.
• Performed routine functions in Informatica like loading data from a flat source file into a target and apply transformations for the data according to the requirements.
• Generated data models using basic concepts of ERWIN.
• Extensively implemented and governed the corporate naming standards according to the company-specified standards.
• Identified all the conformed dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
• Interacted with SME accumulate knowledge about business processes and documented those for future purposes.
• Involved all design reviews of mapping according to High level design Mapping Documentation and standards followed for project.
• Collaborate with QA team for Defect tracking and resolved Data Modeling defects.

Environment: Oracle, Informatica, Business Objects, InfoView, ERWIN, MS Access and MS Excel.

Confidential, Bloomington, IL

Data Analyst

Responsibilities:

• Responsible to play a key role in day-to-day support of Business Intelligence tools, Decisional and Reporting solutions, Business Objects, and underlying ETL framework.
• Responsible to gather detailed business and technical requirements and participate in the definitions of business rules and data standards.
• Responsible to create Data Stage jobs to extract transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Provide application support to ensure availability and reliability of the shared Business Objects XI reporting environment, including administration and maintenance of user groups, users, folders, events, schedules and security.
• Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
• Developed and maintained reports using in MS Excel queries, SQL in Teradata, and MS Access.
• Prepared Logical Data Models using ERWIN that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Participated in monitoring of Enterprise server performance and stability, and perform required support and maintenance to improve where necessary.
• Provided technical support (including upgrades and patching) of existing Production environment.
• Responsible to Test and deploy new Business Object universes to meet business needs.
• Conducted analysis of alternatives and provide recommendations for support issue resolution.
• Worked with project team to plan a support strategy for solutions and/or enhancements to existing systems to meet current and future needs.
• Performed peer reviews on all BO universes, reports and dashboards.
• Engaged in user facing and communication tasks while interacting with support teams, Business users and Super Users, vendors, and quality assurance team.
• Work with IT quality assurance and software delivery teams regarding code tuning efforts, project phase, post-implementation phase, and performance analysis, as matters are observed in the production environment.
• Documented monthly status reports for enhancement and modification requests for the development team to assist them in efficient tracking and monitoring of open issues of the project.

Environment: RUP, UML, SQL Server, Informatica, Business Objects-Web Intelligence and Desktop Intelligence, MS Office Suite (Word, Excel, Access and PowerPoint).

Confidential, Montville, NJ.

Business Analyst/Data Analyst

Responsibilities:

• Acted as liaison among business units primarily between the stake holders, Project Manager, IT Specialist (Developers), Administrators and Testers.
• Understood the project scope, objectives, and timelines with MS Project and help explain them to various teams and prepared the “As is” and “Will be” document to help identify the benefits and project requirements.
• Converted User Requirement into Technical Requirement so it is easy for technical team to understand.
• Worked in accordance to the methodology laid down by the RUP for various phases of the business and created business vision, business architecture documents and mock reports.
• Facilitated JAD in order to identify business rules and requirements and then documented them in a format that can be reviewed and understood by both business people and technical people.
• Organized requirements into groupings of essential business processes, business rules, and information needs, and insured that critical requirements are not missed.
• Implemented business modeling, data modeling using MS Visio, UML and Rational Rose.
• Documented system specifications in Rational RequisitePro in order to track and analyze the requirements matrix as linked to code.
• Use data warehousing tools like ETL (Extraction, Transform and Load), to collect the data from different department and make it available for management department to quick response. Also use Online Transaction Process (OLTP) and Online Analytical Process (OLAP) for day to day basis operation and analysis.
• Identify data elements from the source systems, performed data analysis to come up with data cleansing and integration rules for the ETL process.
• Performed ETL (Informatica) tool evaluations. Involved in normalized and multi-dimensional modeling and building of metadata repository
• Used Client/Server, Multi-Tier and Web-Based Architectures by applying Top-Down, Bottom-Up and both approaches in data modeling.
• Used SAS/ACCESS to extract data and analyzed clinical research data using SAS/STAT and used SAS/GRAPH to display results as graphs.
• Created the ad hoc reports using SAS reporting tool Interacted with business managers, ETL Developers, and Technical development teams to analyze and document user requirements.
• Performed risk analysis with technical team to identify the key business risks areas for the project and prioritized the application development and testing.
• Coordinated project scheduling with the software development manager.

Environment: ETL, OLAP, OLTP, RUP, UML, Requisite Pro, Rational Rose, Clear Quest, Oracle, SAS, MS Visio, MS Office

Confidential, Thousand Oaks, CA.

Data Analyst

Responsibilities:

• Participated in gathering Business Requirements and designed the project according to the Business requirement specifications.
• Built the Forms for application using various form modules and windows.
• Designed the data flow diagrams using VISIO.
• Involved in preparing Business test cases, test design, test Cases, and Strategies.
• Reviewed the test cases and bug reports.
• Created stored procedures, triggers using PL/SQL.
• Wrote SQL queries to perform database Validations.
• Used SQL*Plus for updating the database and for data retrieval.
• Did unit testing, manual testing of the processes to check the integrity.
• Involved in the implementation, testing and maintenance of the system.
• Design and develop a custom database (Tables, Views, Functions, Procedures and Packages).
• Run batch jobs for loading database tables from flat files using SQL*Loader.
• Developed UNIX Shell scripts to automate repetitive database processes.
• Executed System and data quality testing to ensure all development deliverables are production ready.
• Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.

Environment: SQL, SQL Server 2008 R2, PL/SQL, XML, XSLT, Java and UNIX.

Confidential

Data Analyst

Responsibilities:

• Involved in analyzing the reporting needs of the Business Users and Reviewed Software requirements Specifications.
• Conducted source-system data analysis to understand current state, quality and availability of existing data.
• Executed and scheduled tasks; batch processing, metadata management and data mapping.
• Responsible for physical/logical data modeling; metadata documentation; user documentation; and production specs using Rational Rose.
• Created Logical Data Model as a blended configuration of Conceptual Model elements along with material deemed essential and/or useful from the source-system analysis.
• Worked closely with Business user in Understanding designing and documenting the Functional testing plan and then Writing, executing, documenting the results and Logging defects.
• Responsible for setting timelines and reaching deliverables.
• Facilitated meetings with business users, Project Managers, and IT personnel.
• Reviewed specifications for feasibility of customer list pull criteria and commit date.
• Created waterfall reports to show total lead pull, number of records dropped as result of each suppression or set of suppressions.
• Provided output by segments for each Direct mail files.
• Created output counts report and sample records for customer approval/satisfaction.
• Delivered file in various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.)

Environment: Informatica, Erwin, SQL Server, MS Excel, PL/SQL, Oracle, Windows 2000, Rational Rose.

Confidential

Jr. Data Analyst

Responsibilities:

• Responsible for data analysis, compilation and development of analysis tools and reports for substation maintenance data as a member of the project team.
• Involved in Development of queries against corporate databases to extract, compile and associate records from maintenance system.
• Involved in analysis and cleansing of data.
• Developed data analysis models and tools in Excel or Access.
• Developed reporting tools for use by other Transmission staff.
• Involved in development of data requirements, data definitions and specifications for data collection procedures.
• Involved in Ongoing Maintenance and support of Business Objects environment.

Environment: Oracle, SQL Server 2000 and MS Office Suite.