SUMMARY:

• Skilled Senior Siebel Analyst with extensive experience in business information systems, focused on Requirements Analysis, Functional Analysis, Data Analysis, Data Modeling, Master Data Management High - level Design, Testing and Release Management
• Extensive experience in Requirements Engineering/Functional Specifications for large ERP projects
• Experience in large, full-life cycle projects and conversant with popular SDLC methodologies viz., CMM, RUP
• Proficient in Business Process Modeling for documenting as-is and to-be processes
• Expertise in Conceptual and Logical Data Modeling
• Good domain expertise in the areas of CRM, Analytical CRM(Campaign Management), Data Warehousing, CDI(Customer Data Integration), Master Data Management, ERP(Enterprise Resource Planning)
• Very good knowledge of full life cycle development for building a Data Warehouse
• Exposure to ITIL processes and Data Model
• Extensive working experience in Epiphany Analytical CRM suite-Campaign Management, Lists Generation, ETL (Epichannel)
• Extensive working experience in Siebel CRM-Sales Force Automation, Campaign Management, Contracting, Interfaces
• Extensive experience in EDM(Enterprise Dimension Manager), a Master Data Management Platform recently acquired by Confidential
• Lead and oversaw the Analysis/Development/Test activities within Sustenance Program for five fully functional and large Data Marts in GMP(Global Marketing Platform) for Confidential in the period between
• Key contributor in many major releases of US, Confidential, Confidential, Confidential Datamarts in GMP (Global Marketing Platform) for Confidential in the period between
• Significant experience in delivering varied projects in Confidential IT)
• Key contributor in many major releases of Confidential &T(Mobility) BASE Application Group (Siebel CRM)
• Excellent Project Management experience in medium-sized projects
• Significant experience in Industry verticals viz., Technology, Telecommunications, Financial Services, Airlines
• Familiar with a broad set of IT tools, methodologies, technologies, platforms and industry trends
• Excellent client-facing skills with previous experience in Sales, Pre-sales, Marketing and Communications in IT industry
• Self-starter with excellent interpersonal, written and verbal communication

TECHNICAL SKILLS:

Software: Siebel 7.7/7.8/8.0 Siebel Tools, Epiphany, EDM (Enterprise Dimension Manager), Clear Quest, MS Project, Visio, IIS Server, ErWin, Sharepoint, Axapta

Databases: MS SQL Server 2005/2003/2000 , Oracle 8i/9i/10g, MS Access

OS: Windows Family (XP, Vista, NT, 2000,98), UNIX, LINUX, DOS

Languages: MS T-SQL, Visual Basic, PL/SQL, HTML

PROFESSIONAL EXPERIENCE:

Confidential, WA

PM/Analyst

Responsibilities:

• Devised a Metrics driven approach to identify key reporting requirements
• Prioritized Metrics for FY 11 implementation by a criteria that took into account key executive priorities, monthly business review goals, shared goals across Confidential
• Consulted with SMEs to identify the data sources for prioritized Metrics ensuring primary data sources were clearly traced
• Mapped prioritized Metrics to Data Facets to Data Sources as a preliminary step towards ITW data model. Ensured compliance to the ongoing Confidential data model definitions
• Prioritized Data Sources for onboarding by a combination of Metric Density % (the % of Metrics sourced from a particular Data Source) and evaluating Data Source quality by a criteria of System of Record (SOR), stability of schema, retirement plans
• Worked closely with SMD and BIE(Business Intelligence Engineering) leadership teams to refine Vision and Scope for ITW with a clear focus on FY 11 projects
• Created a clear FY 11 Roadmap across different solution components of ITW(Data Acquisition, Data Modeling, Sandboxing, Reports/Dashboards/Scorecards) with high-level funding/resource estimates
• Created a high-level Data Acquisition schedule for prioritized Data Sources
• Delivered Vision-Scope document comprising Data Analysis, Metrics prioritization approach, Primary Data Sources info, tentative list of Reports/Dashboards/Scorecards for migration and

Confidential, IL

Siebel Functional/Data Analyst

Responsibilities:

• Conducted comprehensive analysis of existing data
• Described a horizontal approach(across entities) to handle false-positive and false-negative scenarios
• Created a rigorous criteria for defining duplicates
• Generated the duplicate record set on the full data with derived analytical attributes for quick ‘Merge’ decisions
• Created intuitive reports for prioritizing the ‘Account’ records for de-dupe by compression % vis-a-vis total duplicate count for each Account
• Established merge criteria for each of the duplicate category that will reduce the total duplicates by 90%
• Provided quick mapping doc from source(Location Databases) to Compass for one-time data migration and monthly data loads
• Provided analysis for reporting capabilities on ‘Acquisition’ assets in Compass clearly enunciating source data gaps
• Assisted in UAT, identified critical defects

Environment: Siebel 8.0, Siebel Tools, Oracle 10.203, Golden

Confidential, WA

Siebel Functional Analyst/BASE Analyst

Responsibilities:

• Produced thorough impact analysis emanating from Interfaces FRs for identifying new data elements, modifications to existing ones, creation of an entirely new API to support a new business process
• Described and documented highly useful process models for Interface areas
• Defined logical design clearly explaining the interaction amongst systems and sequence of activities
• Defined detailed business rules Confidential the process level as well as Confidential the data element level
• Delivered clear, accurate schema structure for impacted/new APIs
• Engaged internal teams and external teams for constant discussion/feedback on Interface Design
• Articulated impacts to external systems very early in the cycle
• Streamlined, improved, enhanced all the existing AIDs(Application Interface Document) and created clear, concise new AIDs where appropriate
• Engaged with Test team right from Test Scenarios development
• Provided constant feedback/inputs during test case development/reviews
• Provided inputs/explanation/resolution where necessary in all cycles of BASE test execution as well as during external systems’ testing (eg., Phoenix/Premier)
• Delivered a large number of high-quality BASE AIDs across releases(R13-17) always on time
• Delivered 8 AIDs on time in R 16 alone(SBS 3.0)
• Defined Pre-ETL data elements/structure, file formats, business rule for various external sources in Account Loader project
• Key contributor for Account Loader(Phase 1) HLD
• Defined a highly useful ready reckoner on all critical BASE interfaces capturing Interface types, type of call and direction, primary data exchanged, interacting systems
• Developed healthy and trustworthy relationship with external systems and business stakeholders
• Constantly consulted/recognized as key BASE resource by external systems for issue resolution
• Handled Remedy Analyst Queue(BASE production support) for maximum weeks in 2009
• Conducted effective/extensive Knowledge Transfer sessions on BASE interfaces for the new team
• Developed significant understanding of Confidential business landscape
• Developed intimate knowledge in Confidential Application landscape consisting large Billing, Ordering apps and many miscellaneous apps in addition to the core BASE app

Confidential, WA

Sr. Business Analyst

Responsibilities:

• Devised a creative methodology to generate workload data from the centralized Lab Pro Database
• Identified core group tables for each business transaction(dispatch, payout, collection)
• Collected db activity(inserts/updates/deletes) for every transaction hr between 2AM-PM for one full year
• Applied experience based criteria from Lab Pro SME’s to generate business transactions arrival rate accurately
• Identified Peak and Average loads across time-zones and across time-slices between 2AM-8PM(standardized for Pacific Hr)
• Identified stress zones where highest average loads and highest peak loads were converging
• Generated total system load for every transaction hr between 2AM-8PM(standardized for Pacific Hr)
• Generated workload profile with instructive charts and pivot tables
• Validated the Workload data with real data from selected branches
• Articulated & delivered non-functional Performance Requirements from the above workload analysis
• Actively participated in indentifying and separating functional from non-functional requirements
• Organized all roll-out requirements into implementation category
• Identified critical dependencies from other ‘Build’ teams where business continuity was impacted
• Identified new ‘functional requirements’ from gap analysis
• Delivered a suite of consolidated implementation requirements

Environment: .net, IIS 7.0, SQL Server 2005, VSTS, Quality Center, Windows Family

Confidential, WA

Project Lead /Sr. CRM/DW Business Analyst

Responsibilities:

• Played roles of Project Lead, Business Analyst in solutions such as Data warehousing, Analytical CRM, Campaign Management, Enterprise Resource Planning, and Master Data Management with distinction and success.
• Successfully handled deliverables in requirement collection, requirement analysis, functional analysis and release management
• Lead medium-sized teams (5-12) effectively ensuring remarkable output
• Managed client expectations in all critical releases exceptionally well
• Helped Wipro win new business from the client ( Confidential )
• Key contributor in the POC(proof of concept) executed for Finance group
• Defined and built MDM models for POC purpose
• Defined extensive business rules to implement the workflow requirements for Function Hierarchy
• Discovered and reported crucial product bugs in Security and Business Rules functions
• Defined exhaustive Business Requirements for MDM Platform
• Participated in BRD review sessions with multiple stakeholders in Confidential ; provided context, incorporated feedback
• Achieved high-level of expertise with EDM tool
• Conducted knowledge transfer sessions to Distribution team in Core Finance

Environment: Enterprise Dimension Manager V4.2, .net, IIS 7.0, SQL Server 2005, VSTS

Confidential

Data Migration Lead/Analyst

Responsibilities:

• Defined a Data Migration Approach detailing a generic process as well as focusing on all the key issues that are unique to MBS(accepted by business)
• Conducted detailed system study from a data modeling perspective to identify entities whose data management was not automated for both AOC(Americas) and EOC(European) regions
• Generated a schema from Main Functional Specifications docs for comparison with sources
• Defined and implemented a Data Mapping framework covering all sources for each logical entity until their final destination(Axapta)
• Defined a preliminary Meta Data model for implementing ETL from Sources to Staging to target system(Ax)
• Coordinated and supported definition of clear and detailed Business Rules for Data Conversion for identified Candidate entities(SKU, Invoice)-(Baselined)
• Coordinated and supported definition of clear Data Cleansing criteria for identified Candidate entities(SKU, Invoice)
• Defined Data Quality criteria for UAT
• Identified target system (Ax) constraints from a process and technology perspective and devised alternative solutions(Item number creation, Invoice posting)
• Defined a Data Migration Functional Specification structure to address all the unique requirements of MBS(accepted by business)
• Coordinated multiple interactions with critical stakeholders-Business SME’s, Program Managers, Dev leads to define Business Requirements exclusively for Data Migration
• Delivered baseline Data Migration specifications for 5 large modules(out of a total 6) scoped for R1

Environment: Confidential Dynamics Ax v4.0, .net, SQL Server 2005, VSTS

Confidential

Program Manager /Sr. Business Analyst(CRM/DW)

Responsibilities:

• Participated in many review meetings with Product Management to fine-tune the BRDs from a feasibility perspective
• Delivered Functional Specifications for both US and Worldwide regions consisting:
• Logical Data Model for both US and WW regions mapping close to 300 tables and 2500 columns to the current sources with all the necessary transformation logic/business rules explained in clear terms (A comprehensive ER diagram was never prepared in any of the previous EMMA releases dating back to 2002 )
• Logical Data Model for both US and WW regions base lined against Geneva Schema
• Gap Analysis for both US and WW regions identifying all the missing tables/columns in Geneva against the current actual data sources viz., MSO, CRMPublish(Siebel), MSSales with all necessary information as to the underlying transformation logic/business rules
• Clear demarcation on the Staging tables that need data from actual sources v/s Staging tables that have internal tables as sources and explanation of transformation logic
• A clearly articulated New Design Approach to improve the extraction performance having extensive details as to the dependencies in tables, leveraging parallelism using SSIS, optimizing Mart(Fact/Dimension) extraction by a different population logic, compressing MOM(Indexing for all Mart tables) builder step
• A concise summary on all the extraction jobs in EMMA space with a recommendation on jobs that need to point Geneva v/s the jobs that need to point to their current sources (eg., Suppression Job)
• Clearly translated scope of the requirements from BRD to clearly distinguish in-scope v/s out-of-scope explaining the underlying reasons as to the feasibility as well as brief summary on implementation aspects
• Articulated all the requirements in technical terms for engineering teams through multiple reviews, clarification sessions
• Conducted review sessions exclusively for Geneva teams to explain the Gap Analysis and the underlying business reasons for prioritization

Environment: Windows XP, Weblogic 8.1, Epiphany E.6.5.4 Platform, Siebel, VSTS, SQLServer2005

Confidential

Responsibilities:

• Participated in many review meetings with Product Management to fine-tune the BRDs as far as MSO attributes were concerned
• Delivered Functional Specifications consisting:
• Logical Data Model for all the new tables/columns as entailed by new MSO requirements with all the necessary transformation logic/business rules explained in clear terms
• A clear explanation on the need for creating new fact/dimension/degenerate dimensions
• A clearly explained design approach to implement the latest data source for an email. Developed logic to handle the scenario if the latest data sources for an email are more than one
• Impact analysis as to the potential variation in Data Counts to account for any increase in extraction time
• Articulated all the requirements in technical terms for engineering teams through multiple reviews, clarification sessions
• Worked closely with Program Management to make go, no-go decisions in Delivery cycles

Environment: Windows XP, Web logic 8.1, Epiphany E.6.5.4 Platform, VSTS, SQLServer2005

Confidential

Project Lead

Responsibilities:

• Articulated the scope and fine-tuned process methodology for Sustenance Activities
• Established clear mandate for the team and achieved rapid ramp up
• Established strong rapport, visibility with Client groups Confidential Redmond
• Established formidable reputation for delivery excellence- Delivered- 2 Service Pack Releases-Zero UAT bugs Delivered- 12 hotfixes-Zero UAT Bugs Handled over 130 issues(entire team) that entails analysis, data validation, resolution documentation to the complete satisfaction of the client.
• SE team considered as Subject Matter Experts and sought after for support/advice by other release teams and MS PgM

Environment: Windows XP, Weblogic 8.1, Epiphany E.6.5.4 Platform, VSTS, SQLServer2005

Confidential

Project Lead/Analyst

Responsibilities:

• Conducted review session with Taxonomy teams, Product Management for clarification on impact on EMMA
• Delivered US EMMA and WW EMMA Functional Specifications in absence of a BRD by keen understanding of overall Organizational Taxonomy changes and identifying the elements that affect EMMAs
• Engaged with Business to articulate the changes and impact in Industrial Vertical and Organization Segment/ Sub-segment taxonomy values
• Delivered impact analysis identifying all the reports that need to point to the new values and the potential variation in Data Counts
• Worked closely with SE developers to deliver a flawless Technical Design
• Managed the delivery of this release-Construction, Testing, Release very efficiently to deliver a ZERO UAT bug product
• Suggested modifications to Suppression Business Logic articulating the purpose of generating suppression lists. All suggestion incorporated into FSD/TDD
• Established test approach, prioritized test cases.
• Defined Data Quality criteria(acceptable variances, expected Suppression List count changes from previous to current as a result of redesigned logic)
• Successfully delivered to UAT on time

Environment: Windows XP, Web logic 8.1, Epiphany E.6.5.4 Platform, VSTS, SQLServer2005

Confidential

Project Lead

Responsibilities:

• First project to be delivered entirely from offshore(complete ownership)
• Effectively managed stringent deliveries despite numerous technical/political and schedule challenges Unicode was slated to be released in November. Took initiative to combine Unicode with Unified code builds to deliver extra functionality much ahead of the schedule
• Introduced, prototyped, established multi instance testing to compress delivery cycles significantly
• For the first time in the EMMA testing history clearly defined the scope for a full data set testing and small data set
• First project to be delivered in Onsite/Offshore model from test
• Effectively managed offshore team ramp up, onsite interactions, project planning testing approach
• Suggested improvements to DBswitch(key functionality) to handle active spids
• Successfully delivered to UAT on-time
• Met schedules for US EMMA (Siebel), Etendard (Siebel), Paddington(Siebel), EMMA Confidential (High Value and Siebel), EMMA APJ(High Value and Siebel), EMMA LATAM(High Value and Siebel)
• Prepared High Value and Siebel UI functional test cases which were extremely well received by User Support group.
• Demonstrated all High Value filter criteria testing through UI.
• Demonstrated all Siebel related missing attributes, broken reports testing through UI
• Conducted exhaustive regression to ensure that the desired attributes did not get deleted

Environment: Windows XP, Weblogic 8.1, Epiphany E.6.5.2 Platform, Product Studio SQL Server 2000

Confidential

Tester

Responsibilities:

• Met schedules (for 8 marts) as a key member of 4 person team despite randomization and heavy work load
• Learnt on the fly and made significant contributions in rapid build deployment and instantiating EpiMeta’s
• Established a template for UI testing
• Created a set of generic UI test cases that can be used across marts
• .Conducted exhaustive UI/Data validation testing and fair amount of back-end testing for all the 8 marts
• Acquired expertise in extraction troubleshooting
• Forged strong relationships with team members and stakeholders

Environment: Windows XP, Web logic 8.1, Epiphany E.6.5.2 Platform, Product Studio SQLServer2000

Confidential

Test Analyst

Responsibilities:

• Review of requirements
• Preparation of Test Strategy and Test plan
• Development of Test Scenarios
• Preparation of Test cases
• Installing the builds and executing smoke test
• Test Cases execution and defect reporting
• Defect Analysis and Tracking and in Rational Clear Quest
• Regression Testing
• Conducted 2 cycles of testing successfully for the current release
• Suggested functionality improvements in the email module
• Reported defects, when fixed will be part of the new functionality for global release

Environment: Windows XP, Web logic 6.1, Epiphany E.6 Platform, Rational Clear Quest, SQLServer2000

Confidential

Test Analyst

Responsibilities:

• Preparation of Test Strategies, Test plans, navigational flows, Test Scenarios and Test cases
• Installing the builds and executing smoke test and Regression testing
• Test Cases execution, defect reporting and Defect Analysis, Tracking and in Rational Clear Quest.
• Conducted 3(including regression testing) cycles of testing successfully for the current release
• Suggested functionality improvements in the report generation, attribute listing and navigation for campaign generation
• Developed templates for capturing topics/attributes/derived attributes and comparing Epiphany releases 5 to 6
• Reported defects on the UI side (first time in Confidential Epiphany implementations)

Environment: Windows XP, Web logic 6.1, Epiphany-AS Suite, Confidential internal testing tools, SQLServer2000

Confidential

Test Analyst

Responsibilities:

• Primarily responsible for functional specification review and preparation of test specifications
• End-to-end application and system testing
• Defect logging & Regressing testing
• Co-ordination of Test Automation

Environment: BEA Tuxedo, XML, Oracle 9i, Sun Solaris 2.8, Trillium

Confidential

Test Analyst

Responsibilities:

• Primarily responsible for functional specification review and preparation of test specifications
• End-to-end application and system testing
• Defect logging and Regression testing

Environment: ArcPlan Dynasight Server, HTML, SQL Server 200, ArcPlan insight

Confidential

Tester

Responsibilities:

• Primarily responsible for preparation of test specifications
• Assisting the test lead in constructing the test strategy
• End-to-end application and system testing
• Coordination between on-site/off-shore team

Environment: Weblogic Server 6.1, IPlanet4.5, J2EE technologies, XML, MQ Series 5.2, Oracle 8i

Confidential

Tester

Responsibilities:

• Primarily responsible for preparation of test specifications
• Assisting the test lead to construct the test strategy
• End-to-end application, system testing & Regression testing
• Coordination between on-site/off-shore team

Environment: Weblogic 6.1, IPlanet4.5, J2EE technologies, XML, MQ Series 5.2, Oracle 8.1.5, Site Minder, LDAP Rational Rose

Confidential, Aspen, Colorado

Tester

Responsibilities:

• Primarily responsible for preparation of test specifications
• End-to-end application and system testing
• Coordination between on-site - off-shore team
• Regression testing

Environment: Windows NT 4.0, Apache 1.3.14, Tomcat 3.2.1, SQL Server 7.0, JDK 1.3, Servlets and JSP,Rational Rose, Rational Clear Case 3.2, Clear Quest 2.0, ANT and JBuilder 3.5

Confidential

Sr. Business Analyst

Responsibilities:

• Developed a detailed Business Plan for the Indian entity with Mission Statement, Vision and focus areas of operation.
• Established many simple but effective systems and procedures in the day - to-day operations of the company (Project Management, HR policies etc)
• Recruited, Inducted and Trained an entire team of programmers, project leaders and marketing persons for the company’s Confidential initiative.
• Conceptualized, designed and successfully launched a Confidential portal “ Confidential .com”

Confidential

Account Manager

Responsibilities:

• Handled sales and marketing with significant successes amidst intense competition from large players. Delivered Rs. 1.2 crores in business
• Handled all the Pre-sales (Requirements gathering/mapping, Business Case preparation, Proof-of-concept development) activities very successfully
• Developed sales collaterals and handled partner development programs
• Helped build a strong technical and functional team for Confidential ERP practice
• Key participant in internal Implementation project

Confidential

Business Analyst & Marketing Consultant

Responsibilities:

• Clinched prestigious accounts like Confidential, Confidential, Confidential Ltd and Confidential and Confidential unit)
• Designed and drafted an Employee Manual for Hyderabad center explaining the center’s history, growth and activities with a clear delineation of roles and responsibilities for the employees