SUMMARY:

• Seasoned Business / Data Analyst with broad knowledge including business and data analysis, business process design, application system analysis, and project management in various domains.
• Strong knowledge of Software Development Life Cycle (SDLC) including Waterfall, Agile Methodology, RUP with understanding of various phases like Requirement, Analysis /Design, Deployment and Testing.
• Good knowledge of Financial Analysis (NPV analysis, Stocks/bonds valuation, Real/financial options pricing, and DCF analysis), Corporate Actions Analysis, Root Cause Analysis, Feasibility study and Risk assessment, GAP analysis, User Acceptance Testing (UAT), SWOT analysis and Cost benefit including ROI and Financial Justification.
• Experience in Investment arena including Macroeconomics analysis, capital markets and Equity research.
• Strong exposure to data warehouse ETL environment like Informatica. Areas of testing included cardinality (number of rows) and data transformation (Business rules) testing.
• Extensive experience in configuring Interactive Dashboards/Reports with drill - down capabilities using global and local filters, Guided Analytics, Alerts, Security Setup (groups, access privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Professional experience in the IT Industry using advanced SQL coding, over varied platforms like Teradata, Oracle.
• MySQL, DB2 and SQL server for data mining and report generation.
• Good knowledge of Data Modeling using Erwin, Visio, ETL tools, OLTP, OLAP tools, Star Schema, Snowflake Schema, and Entity-Relationship Diagrams.
• Strong SQL querying skills for data extraction and back-end testing.
• Prepared Logical Process and Data Models that contained 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.
• Designed Big Data solution using a combination of MS SQL Server, DB2, oracle, Hadoop and Teradata.
• Expertise in debugging and optimizing the Oracle BI Dashboards / Reports and Informatica Mappings / Workflows.
• Proficient in tuning SQL queries using Explain Plan, Trace (TKPROF, SQL TRACE)
• Good understanding of OLAP Data Warehousing technology.
• Expertise in SQL PL SQL programming, stored packages/procedures/functions/triggers
• Worked on OBIEE consisting of three layers (Physical Layer, Business Model and Presentation Layer).
• Extensively used Excel for data manipulation, financial statements modeling (VLOOKUP, NESTED conditions and for creating Macros)

TECHNICAL SKILLS:

Project Methodologies: Rational Unified Process (RUP), Software Development Life Cycle, Agile

Business Modeling: Rational Requisite Pro, MS Visio, MS Project

Reporting Tools: Siebel Analytics 7.8.x/7.7.x/7.5.x, OBIEE 10.1.3.x, Oracle BI Apps, Spot fire, Cognos

Test Automation Tools: Quality Center (9.0/10.0), HP Quick TEST Professional (9.2/10.0), Load Runner

Testing Management Tools: TOAD (8.6/9.0), SQL Developer (1.5), Reedit SQL, Test Director, TIBCO BW, Soup UI, XML, API

Languages: Visual Basic, VB.NET, JAVA, SQL, XML, HTML

Databases: Oracle 10g/9i/8i, DB2, Sybase, RDBM, MS SQL Server, MS Access, MySQL, Tera Data, Hadoop, Nateeza,, SAS

Operating Systems: Mac OS, Window 7/Vista/XP/2000, Linux,UNIX, MS DOS

ETL Tools: Informatica 7.1, Data stage.

Web Technologies: RDBMS, UML, XML, XML Spy, Fiddler, SOAPUI

BI Tool: COGNOS, Micro Strategy, Soptfire

PROFESSIONAL EXPERIENCE:

Confidential, Union, NJ

Technical Project Manager / System Analyst

Responsibilities:

• Developed project plans, schedule and work breakdown structure for projects.
• Communicated project status, progress on deliverables, and risks/issues to stakeholders and leadership in a timely manner. Successfully lead all phases of diverse technology projects.
• Provided Agile project management controls, project plans, timeline schedules, facilitate RAD sessions, and review software defects .
• Facilitate sprint planning, daily scrums, retrospectives, stakeholder meetings, and software demonstrations.
• Created project work plans for assigned tasks to ensure milestones are met.
• Document requirements for Marketing Database to support the analytics and reporting activities.
• Created Use Cases, Test Cases, Test Plans, Sequence Diagrams and Activity Diagrams using MS Visio
• Assist in the timely preparation and execution of multiple email/Mobile campaign projects.
• Created Data flows and mappings to support the SAS for marketing campaigns creation and reporting needs.
• Manage the monthly and ancillary e-mail campaigns.
• Worked closely with marketing team to provide data quality assurance through routine check-ups. Interact with third party vendors to ensure all campaigns are executed in a timely manner.
• Responsible for conducting detailed analysis Google Analytics and making actionable recommendation according to the data.
• Provided data and helped design marketing campaigns to promote Deposit products and track web data using Google Analytics.
• Using Google Analytics; conducting SEO to enhance the existing web portal by re-engineering search, sort, list, shopping cart, cancellation, payment processor and payment gateways.
• Analyze the performance of client's website using Google Analytics.
• Analyzed ecommerce conversions, engaged visitors and bounce rates using google analytics.
• Facilitated regular stand-up meetings across the project team
• Identified and recorded the problem with all relevant data. Classified the problems based on the criticality of the impacted business process. Resolved the problem and provided the root cause analysis report.
• Managed multiple teams & stakeholders for end to end project execution.
• Excessively worked on Jira software extensively to write User Stories, assign tasks to individual team members and maintain Jira tickets to track and log all until deployment period.
• Work with developer, test and site production teams to ensure accurate data integration implementation and to improve data quality.
• Performed extensive testing on the mappings and wrote queries in SQL to check if the data was loading to the dimension tables and fact tables properly.
• Used Data Warehouse Architecture and Design - Star or Snowflake Schema, FACT and Dimensional Tables, Physical/Logical Data Modeling and data flow diagrams.

Environment: MS Office, MS Visio, Teradata, Neteeza, Oracle, MS word, JIRA, SQL, SAS, Scrum

Confidential, Durham, NC

Business System analyst

Responsibilities:

• Assisted in developing and implementing service delivery processes during company centralization.
• Documented the process and trained the contractor team on utilizing and maintaining the system.
• Participate in the planning, development, maintenance and configuration of system.
• Performs detailed analysis, data cleansing and identifying manual data process.
• Involved in the daily Agile/SCRUM meeting to update the task status at hand to the overall team.
• Continuously monitor the master data processes for improvement opportunities, provide recommendations and assist with implementing changes that increase the efficiency of the master data process.
• Acted as a primary SME liaison between business users/BAs and IT project team
• Conducted User Acceptance Testing (UAT) for final product evaluation and roll out, Worked in Agile development environment in a scrum fashion. Worked with the scrum manager to develop stories.
• Involved in preparing Software Requirement Specification Documents.
• Created screen mock ups, wireframes, user experience requirements and workflows.
• Developing and maintaining all project activity plans for account as well as presenting project plans to client.
• Responsible for requirement analysis by gathering functional and non-functional requirement based on interaction with the process owner & stake holders and conduct document analysis.
• Involved in data and gap analysis, documentation, process flow diagrams, develops source-to-target documents, source transformation rule and system specific rules.
• Worked on fixed income and mutual fund securities trading, settlement, operational processes and portfolio management.
• Perform ad-hoc analysis and ad-hoc reporting.
• Conducted current state vs. target state analysis, gap fitment, scope management.
• Daily operational processing monitoring and support.
• Providing status reports on projects and deliverables.
• Application/system development including querying multiple databases for the development of reports utilized by the institution.
• Involved in ETL, Data Integration and Migration.
• Responsible for ad-hoc and scheduled catalog reports using MS SQL Server Report Builder.
• Run & validate weekly report on SQL server which used by higher management
• Develops system documentation and educational materials for end users and system support staff.
• Data Validation between the source (Netezza, Oracle & SQL Server) and Target system (Teradata).
• Analysis of the Enterprise Data Warehouse in Teradata to create accurate fact and dimension tables so that it can be queried by OBIEE

Environment: Oracle 11g, IBM RTC, Toad, MS Word, MS Visio, SOAPUI, SOAtest, SharePoint, REST service, SQL

Confidential, Somerset, NJ

Systems Analyst / Data Analyst

Responsibilities:

• Performed analytical role on information technology projects according to current methodology
• Development of application specifications with the facilitation of design, documentation, and development of detailed specifications. Facilitates and documents design sessions.
• Primarily responsible for all aspects of User Template building and maintenance.
• Facilitate design and requirement session with internal and external clients.
• Researches, defines, and coordinates implementation of best practices (processes and methodologies)
• Models and documents processes and technical designs at levels of detail required for varied audiences, e.g. business stakeholders, developers, other technical staff
• Planned work, developed schedules, maintained documentation, led cross-functional, project teams, and collaborated with other departments.
• Day to Day Support and troubleshooting SharePoint applications issues.
• Validate transaction records using SQL queries.
• Performed all mapping and data dictionary work required for the development of new application products.
• Interprets business requirements from the user community and translates them into functional and technical specifications
• Provides support to and/or administers one or more production systems
• Develops use cases and use case diagrams
• Performs bug tracking and quality assurance tasks
• Perform User Accepting Test (UAT) and UNIT test for all developed application before deploying to QA environment.
• Prepares canned and Ad-hoc reports.

Environment: Microsoft SQL, IBM Neteeza, Toad, MS Word, MS Visio, SVN, JIRA, BI Query SharePoint.

Confidential, Rockville, MD

Business Intelligence Analyst

Responsibilities:

• Assisted the business in identifying, assessing, and documenting business requirements
• Involved in analyzing different source systems and assist the BA and technical team to understand the systems and data
• Responsible for data modeling - creating logical and physical model.
• Involved in data and gap analysis, involved in documentation of ER (Entity Relationship) diagrams, data dictionaries, develops source-to-target documents while indicating, sources, transformation, cleansing rules, and metadata for loading into the data warehouse, data marts, and operational data stores; accountable for all project documentations and maintained the SharePoint.
• Perform analysis and gather requirements in environments with diverse data sources.
• Create analysis, dashboards, and reports for various departments (SQL and Tableau).
• Monitor performance and integrity of reporting and data management systems.
• Provide subject matter expertise for machine learning applications and tools.
• Provide training and documentation for reporting and data systems.
• Participated in analyzing business requirements, Data Model Design, Data flow from various Sources to Target
• Functioned at varying times as data analyst/data modeler and business analyst, involved in project management communicating overall project status to all stakeholders.
• Integrating Big Data tools into traditional enterprise architectures
• Reviewed new system functionality and patched to determine what is applicable and what should be presented to the business for prioritization.
• Provided in depth and detail reporting and analyses for different patterns for functional and project side of the business.
• Working with the Digital Analytics time at the Consumer Financial Protection Bureau assisting in Search Engine Optimization and a digital Analytics project.
• Formulated and executed search marketing strategies.
• Conducted Google trend analysis for business implications.
• Prepared and documented specifications for business intelligence reports.
• Developed use cases to explain / demonstrate business requirements / specifications to IT team.
• Worked with Quality Assurance Testing team to facilitate comprehensive Quality Assurance Verification to ensure minimal post-implementation defects.
• Coordinated UAT for customer approvals on final deliverables.
• Worked with Release management to ensure a smooth turnover to operations and production support.
• Validate transaction records using SQL queries.
• Intensive use of SQL within the Teradata platform.
• Move data from different sources in to Hadoop and define detailed technical processes for data acquisition
• Extracted data from Teradata and Oracle and created pivot tables in Excel
• Developed new reports using Business Objects/Crystal Enterprises on SQL Server, Oracle and Teradata databases utilizing T-SQL and DTS, focusing on data verification and query performance.
• Performed data profiling to determine how well data matches metadata, supports stated business rules, and relates to other data. This involved working very closely with business SME's and Data Stewards solid understanding of the data source(s) and how the business utilized the data.
• Provide support to the business in researching data issues, specifically how to find and use the data needed, investigate and resolve data quality issues.

Environment: GreenPlum, SQL, Oracle(11g), IBM Neteeza, Hadoop, Toad, MS Word, MS Visio, Teradata, Oracle 11g, TSVN, JIRA, BI Query.

Confidential, Freeport, ME

Data Analyst / SQL Developer

Responsibilities:

• Involved in conventional, logical and physical design for data mart.
• Made sure that the new updated system did not affect the performance of the existing system.
• Performed Validation analysis.
• Provided written, technical feedback on product and ensured that product fit and construction aligned with Confidential ’s requirements.
• Managed marketing related projects and analysis as well as other initiatives to facilitate sales and operations.
• Used Data Mining extensively to analyze data from different perspectives and summarize it into useful information.
• Analyzed access patterns and implemented the best combination of indexes, constraints, foreign keys, etc.
• Developed complex SQL queries to create OLAP cubes inside the data warehouse.
• Executed numerous highly tuned SQL statements like Explain, Statistics, Cast and Format.
• Developed Data marts to support reminder campaign and other promotional activities.
• Performed numerous data extraction requests using SQL scripts to prepare ad hoc reports.
• Extensively created fact tables, fact less fact tables, multi-dimensional table to use as a source to design a data warehouse.
• Executed queries using multiple aggregate and OLAP/OLTP functions and joins.
• Planned work, developed schedules, maintained documentation, led cross-functional, project teams, and collaborated with other departments.
• Resolved multiple high priority production issues and problem tickets while actively involved in development of new applications.
• Followed/Documentation process of CR (Change Request) for ticket handling
• Created reports and schedule for monitoring.
• Participated in logical model development for sales promotion platform.
• Created physical, conceptual and logical data models for clear understanding of the requirements.
• Provided the impact analysis for the enhancement of sales platform.
• Responsible for importing, cleaning, transforming, or making conclusions from the data for validating or modeling data with the purpose of understanding decision making.
• Made and implemented recommendations for product refinements
• Participated in various meetings and discussed Enhancement and Modification Request issues.
• Used internal tracking system, analyze and document defects.
• Developed UNIX Shell Scripts for automating logs, checking daily logs for automating backup procedures along with communication procedures, using send mail
• Created numerous views that derived many columns so as to facilitate the programmers and front-end applications.
• Wrote Views, PL/SQL procedures and function for processing business logic in the database.
• Fixed bugs according to the software change requirement. Involved in Testing (Both Unit and Integration Level) and Implementation.
• Code development as per the requirement document using FastLoad , MultiLoad, and BTEQ SQL
• Involved in taking Hot and Cold backups periodically.
• Wrote SQL queries for validating data. Any broken SQL query would be tuned using a data cleaning/ data scrubbing software.
• Helped design and maintain application.

Environment: Squirrel SQL, Oracle 11g, DB2, Toad, MS Word, MS Visio, UNIX Shell Scripting, JIRA, BI Query

Confidential, Edgewood, NY

Business Intelligence Consultant / Data analyst

Responsibilities:

• Worked with management professionals, analysts as well as other business teams on requirement gathering.
• Identified Facts and Dimensions according to the design specification.
• Implemented complex requirements like dimension hierarchies, time comparisons and share measures along with rank measures.
• Effectively managed ODBC connections and imported the physical tables, keys and foreign keys.
• Utilized session variables, repository variables and initialization blocks in the repository building and modification procedures.
• Created, modified, and administered analytics intelligence dashboards with links to web sites; links to documents; and embedded content, such as images, text, charts, and tables.
• Extensively used DAC, to configure, monitor and schedule ETL routines.
• Involved in data and gap analysis, involved in documentation of ER (Entity Relationship) diagrams, data dictionaries, developed source-to-target documents while indicating sources, transformation, cleansing rules, and metadata for loading into the data warehouse, data marts, and operational data stores; accountable for all project documentations and maintained the SharePoint.
• Involved in Business Users Meetings, JAD sessions to understand client requirements to migrate their legacy system in Hadoop cluster
• Identified and defined various business critical transactions related to core banking process which includes Check Scanning, Check Imaging, Check Transformation, Data Encryption, Customer Management, Application and Loan Processing, Job Scheduling, Application Compatibility, Access and Identity Management, Simulating Fraud Alerts, etc.
• Worked extensively on Date Profiling to assess the Data Quality and formulate the Data Cleansing strategy.
• Loading flat files from external vendors/partners into Oracle tables, using SQL Loader.
• Made sure the business requirements were met in cost effective manner. Performed budgeting and valuation analysis to gauge the project’s efficiency.
• Load and transform large sets of structured, semi structured and unstructured data using Hadoop/Big Data concepts.
• Coordinated demo workshops to Business Managers, Business Users and demonstrated the entire functionality of the product.
• Worked closely with project stakeholders to formulate a strategy for UAT.
• Participated in the walkthrough sessions on the screen mock-ups of the proposed product with Business Managers and Business Owners.

Environment: OBIEE 10.1.3.4, Oracle BI Applications 7.9.5(Financial analytics, HR Analytics), DAC, Oracle 10g,, Java, Microsoft Share Point, MS Word, MS Excel, MS Power Point, MS Access, MS Visio, Quality Center, SAS

Confidential, Oldsmar, FL

Business Intelligence Analyst / Data Analyst

Responsibilities:

• Collected the requirements for the enhancement to the application which measures changes in subscriber behavior patterns.
• Did extensive data analysis, data profiling , data validation and data reconciliation. Analyzed the data to find out data anomalies (missing records, erroneous data elements) in the source systems.
• Lead Technical discussions on the business rules applied or used for the current production cycle and clarified the questions (File missing, incorrect format, spike in data and other data issues) raised by Operations team during their BizQC meetings or data processing stages.
• Identified the roadblocks which could arise during deployment due to reference data issues, code unavailability, incomplete business scenarios, and reported this status to leadership.
• Analysis of reference data (shared by downstream applications) and validation of the consistency for each and every product.
• Analyzed consumer surveys and gave technical input in business meetings.
• Documented all the issues regarding Data Integrity.
• Facilitated the customer in defining the high-level functional requirements and needs.
• Involved in data cleansing, De-duplication, Data Enhancement activities to enrich the Master and Transactional Data Analyzed; revised and created Test Plans according to business requirements.
• Developed Process Model and detailed Business Policies and modified the business requirement document.
• Created and debugged SQL procedures and PERL/Shell scripts used as part of production cycle run.
• Used SQL*Loader to load data from flat files to Staging Tables.
• Used derived tables, sub-queries, correlated sub-queries to fetch data from different tables Teradata databases
• Monitored the common queue in CCM.Net tool and routed it to the respective product team
• Documented all PL/SQL procedures and user guide for different processes followed.
• Worked extensively on TIBCO BW palettes like Parse, General Activities, JDBC, JMS, Mail, and Policy.
• Troubleshooting for any monitoring alert scripts by coordinating with Command center or monitoring tools team
• 24/7 Support of the production environment and resolving any support tickets within defined SLA.
• Invoking shell scripts to execute BTEQ, FastLoad, multiload utilities.

Environment: MS Visio, MS Project, SQL Server 2008, Perforce version control, Quality Center 10, CCM.net, Rational Requisite Pro, MS Project, MS Office, SQL, Teradata, IBM Netezza, Test Director, Tableau