SUMMARY

• 7+ years of professional experience as Senior Business / Data Analyst in Finance, Insurance and Banking Domain.
• Possess strong knowledge and skills in Software testing and Quality Assurance processes, methodology and tools.
• Strong understanding of Software Development Life Cycle (SDLC).
• Proven experience with Manual and Automated Testing Tools such as Mercury Quality Center, Test Director.
• Strong in Analyzing Business Requirements and Developed Test Plans, Test Scripts and Test Cases and Execute them.
• Experienced in ManualTestingwith focus on FunctionalTesting(predominantly Black Box),UI Testing, and RegressionTesting.
• Wrote BRD, FRD, use cases, test scenarios, test cases for testing the functional and non - functional aspects of both ETL jobs and Reporting jobs.
• Experience in using Pentaho report Designer to create pixel-perfect reports of data in PDF, Excel, HTML, Text, Rich-Text-File, XML and CSV.
• Strong background in the areas of Business Analysis, System Analysis, Data Modeling, Data Warehousing, RDBMS, and Business Intelligence - DSS with complete Software Development Life-Cycle experience.
• Experience with data migration (ETL development), document data manipulation processes and scripts
• Experience in performing Black Box Testing, White Box Testing, Functionality Testing, Integration Testing, System Testing, Regression Testing, Performance Testing, User Acceptance Testing, End-to-End Testing, Load Testing and Database Testing using SQL.
• Expert in MS SQL Server suite of products like SSRS, SSAS and SSIS of MS SQL Server 2005.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Experience in writing SQL queries and optimizing the queries in Sybase, Oracle and SQL Server.
• Extensive experience in Unit, Functional, Integration, Regression, User Acceptance, System, GUI, Load, Stress, Performance Testing and black Box Testing.
• Proficient in Manual and Automated testing tools. Expertise in using testing tools such as QTP and Test Director
• Extensive experience in Manual Testing, preparing System Test Plans and defining Test Cases.
• Experience in testing Online Transactional and Analytical Processing systems.
• Experience in back-end testing with SQL queries
• Experience in coordinating the team with Offshore.
• Extensive experience in analyzing business and system requirements.
• Experience in Robust Defect tracking and reporting.
• Extensively used MS Office for project documentation.
• Effective inter-personal and communication skills, team player and can manage multi-tasking.

TECHNICAL SKILLS

Big Data Tools: Hadoop, Cloudera, Hortonworks, LexisNexis HPCC

ETL: Pig, Hive, Pentaho Kettle, Informatica

Data Ingestion Tools: Flume, Sqoop, Spark, Apache Storm, Kafka, Splunk

CRM/ERP: Siebel (Marketing), SAP (S&OP Forecasting)

OLAP/Reporting: OBIEE, BI Apps 7.x, Hyperion Essbase, Tableau 8.x

NoSQL: HDFS, HBase, Mongo DB

Statistical Tool: R 3.0, R Studio 0.9x, Mahout, Python

Databases: Oracle 11g/10g, Teradata 13.x

Data Modeling Tools: CA Erwin R, Microsoft Visio

PROFESSIONAL EXPERIENCE

Confidential, Whitehouse Station, NJ

Sr. Business / Data Analyst

Responsibilities:

• Performed Data Analysis and Data Profiling using complex SQL on various source system including Oracle and Teradata.
• Analysing the ETL process created in Informatica, developed SQL queries and tables which replicated the ETL, and compared the SQL results with the Informatica tables.
• Implemented metadata standards, data governance and stewardship, master data management, ETL, ODS, data warehouse, data marts, reporting, dashboard, analytics, segmentation, and predictive modeling.
• Worked in all stages of Software Development Life Cycles including design, development, testing and implementation of complex ETL services using Informatica, SQL, PL/ SQL, and UNIX.
• Reviewed all aspects of a company's operations, including meeting with company officials to gain a better insight into the organization's management.
• Performed data mining using SQL, PL/SQL, Unix, Perl and proprietary tools.
• Adhoc Data Analysis and Creation of Complex metrics using SQL and Unix Scripting
• Analyzed the business requirements and framing the Business Logic for the ETL Process and maintained the ETL process using Informatica Power Center and also Profiled source data using Informatica Developer IDQ.
• Developed metrics, filters, and reports and also created advanced chart types and complex calculations to manipulate the data.
• Performed Data Conversion/Data migration using Informatica PowerCenter.
• Created and maintain data model/architecture standards, including master data management (MDM)
• Worked with ETL teams to deliver the reporting layer composed of the highly tuned and aggregated tables designed from the base tables.
• Extensively involved in Performance Tuning for ETL process at source, target, Informatica Mappings, Sessions and at database level for optimum performance.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements.
• Wrote hundreds of DDL scripts to create tables and views in the company Data Warehouse.
• Proficient in importing/exporting large amounts of data from files to Oracle/Teradata and vice versa.
• Highly experienced in Performance Tuning and Optimization for increasing the efficiency of the scripts.
• Designed and developed Ad-hoc reports as per business analyst, operation analyst, and project manager data requests.
• Developed and designed different SAS programs to analyze financial data.
• Created daily and monthly reports using SQL and UNIX for Business Analysis.
• Expertise in generating graphs using MS Excel Pivot tables.
• Developed Ad-hoc reports using Sql on Oracle database, Assemble and summarise data to structure sophisticated reports on financial status and risks.
• Reports generated for various departments like Tele Marketing, Mailing, and New Accounts by using SQL, MS Access, and UNIX.
• Extracted data from existing data source, Developing and executing departmental reports for performance and response purposes by using oracle SQL, MS Excel.

Environment: Informatica 9.x/8.x, Tableau Desktop 9.2/9.0, Teradata, SAS, SQL, PL/SQL, UNIX, TOAD, SQL Server, Oracle 11g Data Governance, Data Modelling, PERL, MS Office Suite, DOORS, SQL DATA MODELER, Unix, Linux, Shell Scripts, Data Lineage, Data Mapping, Erwin, Power Designer, Data Quality

Confidential, NY

Business / Data Analyst

Responsibilities:

• Facilitated Joint Requirement Planning (JRP) sessions with SME’s in understanding the Requirements pertaining to Loan Origination to Loan Processing.
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational RequisitePro.
• Reviewed Design Documents, Requirements Analysis Specifications with Project Lead, Business Owners and the Technical Lead.
• Testing of Pentaho Reports against the Microstrategy environment and Netezza Database extracts.
• Worked on Fixed Income, Bonds and Bond Trading Cycle, Equities and Equity Trade Cycle, Derivatives (Options and Futures), Portfolio Management, Wealth Management, and Sales and Marketing.
• Extensively involved with the trading activities of Credit Derivatives, Interest Rate Derivatives, FX Derivatives, Equity Derivatives and Commodity Derivatives; and Futures including Commodity Futures Contracts and Financial Futures.
• Design document preparation by referring the existing pentaho Environment
• Responsible for creating Systems Requirement Specifications, to capture functionalities at all E-Commercetouchpoints.
• Extensive work experience with Portfolio Managers, Experienced Traders, and Compliance Manager to configure the rule-based scenarios for capturing market and credit risk, general multi-factor sensitivity analyses, and PnL.
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
• Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Expertise in C# scripting to configure Script Task and Send Mail tasks.
• Migrating Pentaho Reports between Dev and Production environments.
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Pentaho Installation and configuration
• Migrating the Microstrategy Report to Pentaho Reporting Environment
• Developed and managed Project Plans and Schedules. Managed resolution of Project issues and conflicts.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Pentaho Administration (User creation, Roles Creation, BA server performance monitoring)
• Analyzing the ETL process created in Informatica, developed SQL queries and tables which replicated the ETL, and compared the SQL results with the Informatica tables.
• Worked as a User/Customer advocate and negotiated with user as well as with developers and management staff to resolve any requirement conflict to bridge the Gaps between IT and Business.
• Various versions of the documents generated during the project were maintained and managed using Rational ClearCase and performed defect tracking using Rational ClearQuest.

Environment: Rational Clear Case,Doors, Scripting, IBM WebSphere, XML, Java, J2EE, JSP, RUP, UNIX, Oracle, MS Visio, DB2, Sybase, SQL Server Reports, WinRunner, LoadRunner, Quick TestPro

Confidential, Albany,NY

Business / Data Analyst

Responsibilities:

• Committed to continuous improvement of quality, processes, system, analysis, data, reports, design, specs, changes and user support / training.
• Processed data in Access/Excel and creating macros in Excel and writing SQL queries/VB code in Access.
• Managed complex spreadsheets, charts and analysis reports. Generated/produced queries, modules and reports.
• Used Pentaho Data Integration in Hortonworks environment to move the data from different web services and REST API (JSON/XML) into Hadoop Data Lake.
• Validated data integrity/accuracy and used data manipulation, data cleaning and data mining.
• Gathered data/information from different sources and convert/transform them into reports/analytical results.
• Developed Siperian Configurations like creating landing tables, staging tables and bae objects, Data Management and Hierarchies.
• Designed code tables, functional tables and hierarchies in Informatica MDM (formerly known as Siperian) tool which is need for the project.
• Used windows Scripting and Scheduled PMCMD to interact with Informatica Server from command mode.
• Involved in Analysis and ETL testing of various Enterprise Data Warehouse and Business Intelligence
• Created ETL Test plans and Detailed Test cases based on business requirements.
• Created a design document which states & provides an understanding of design aspects to be pursued as part of this project. It serves as a reference for all development & testing activities.
• Supported the UAT for reports, ETL and MDM access.
• Creating the Pentaho reports and models ( PME, PRD, Mondrian)
• The MDM Deployment Team representative for Navy ERP. Responsible for defining ETL requirements, cost benefit analysis, case study, and price and functionality comparison and vendor/tool software selection.
• Modify and develop new ETL transformations, summary tables, data staging areas based upon redesign activities with Informatica ETL tool.
• Extracted data from different databases (Teradata/MS SQL/Oracle) using SAS/SQL.
• Establish documentation for agile methodology for implementation with a very water-fall-centric development team.
• Assured that all Artifacts are in compliance with corporate AGILE Policies and guidelines.
• Designed conceptual and logical data models of Data Warehouse and tables.
• Using Shared Containers and creating reusable components for local and shared use in the ETL process.
• Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
• Prepared system Test Plan and scenarios for Test Scripts.
• Worked in Oracle by creating procedure which runs the properties of Siperian tables.
• Analyzed, designed, developed and maintained programs in Access/SQL. Handled large volume of data.
• Gathered/processed data in Access/Excel and creating macros in Excel and writing numerous SQL queries.

Environment: Windows, MS Office (MS Word, MS, Scripting, Excel, MS PowerPoint), Business Objects, Java/J2EE, SOA, SAS, MS SQL, Quality Center, SharePoint, Hogan Mainframe, Agile

Confidential, Boston, MA

Business Analyst

Responsibilities:

• Responsible for logical and physical data modeling, database design, star schema, snow flake schema design, data analysis, documentation, implementation and support.
• Involved in requirement gathering and database design and implementation of star-schema, snowflake schema/dimensional data warehouse using ERwin.
• Initiated Use Case Analysis using UML, which provided the framework for potential use case deliverables and their inter-relationships.
• Performed Unit Testing on PL/SQL Stored Procedures, Functions, Triggers and Packages.
• Involved in the study of the business logic and understanding the physical system and the terms and condition for sales datamart.
• ETL Design, Development & End to End Testing of Informatica Mapping, Tasks, Workflow and Worklet.
• Designed new database tables to meet business information needs. Designed Mapping document, which is a guideline to ETL Coding.
• Instrumental in helping create the Netezza universe for Business Objects reports.
• Striking a balance between scope of the project and user requirements by ensuring that it covered minimum user requirements without making it too complex to handle.
• Requirement gathering from the users. A series of meetings were conducted with the business system users to gather the requirements for reporting.
• Requirement analysis was done to determine how the proposed enhancements would affect the current system. Performed Unit Testing and User Acceptance Testing and documented detailed defects.
• Developed UNIX Shell Scripts to load the data and implemented cron jobs to execute scripts automatically.
• Modify existing Informatica mappings to utilize Power Exchange sources and Oracle andNetezzatargets.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting data.
• Design and developments of the changes and enhancements. The existing submission and refining programs were enhanced to in corporate the new calculations.
• Interacted with end users to identify key dimensions and measures that were relevant quantitative.
• Involved in logical and physical designs and transforms logical models into physical implementations.
• Utilized ERwin’s reverse engineering and target database schema conversion process.
• Involved in different team review meetings.
• Did unit testing and tuned for better performance.

Environment: Oracle, DB2, SSIS, SSAS, SQL Server, UNIX Shell Scripts, Scripting, Netezza, PL/SQL, Teradata, Erwin, TOAD, Crystal Reports, Rational Rose, Informatica, Rational Requisite Pro, Win NT/2000