PROFESSIONAL SUMMARY

• Over 7 years of IT experience in the field of Data/ Business analysis, ETL Development, Data Modeling, and Project Management.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Governance, Data Integration and Metadata Management Services and Configuration Management.
• Over 2 years of experience in Data Modeling with expertise in creating Star Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin and Embarcadero.
• Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
• Knowledge in Business Intelligence tools like Business Objects, Cognos and OBIEE.
• Experience with Teradata as the target for the data marts, worked with BTEQ, Fast Load and MultiLoad.
• Strong experience in interacting with stakeholders/customers, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools.
• Extensive experience in visualizing the design of the system by UML, Class diagrams, ER Diagrams and web page mock-ups.
• Experience in providing a central contact for user questions/inquiries relating to stewarded data within the domain of stewardship.
• Experience in various phases of Software Development life cycle Analysis, Requirements gathering, Designing with expertise in documenting various requirement specifications, functional specifications, Test Plans, Source to Target mappings, SQL Joins.
• Experience in conducting Joint Application Development JAD sessions for requirements gathering, analysis, design and Rapid Application Development RAD sessions to converge early toward a design acceptable to the customer and feasible for the developers and to limit a project's exposure to the forces of change.
• Experience in coding SQL/PL SQL using Procedures, Triggers and Packages.
• Good understanding of Relational Database Design, Data Warehouse/OLAP concepts and methodologies.
• Worked on different platforms such as Windows 95/windows/98/NT and UNIX, Sun Solaris, AIX, HP
• Experience in Working with different industries like Financial, Media, Retail and Banking.
• Implemented Optimization techniques for better performance on the ETL side and also on the database side.
• Experience in creating functional/technical specifications, data design documents based on the requirements.
• Excellent Communication, interpersonal, analytical skills and strong ability to perform in a team as well as individually.

TECHNICAL SKILLS

• Data Modeling Tools : UML, Rational Rose, MS Visio
• Reporting Tools : SQL Server 2005/2008 Reporting Services, Oracle Reports, Business Objects, Micro Strategy
• Project Management : MS Office Suite, MS Project, Clarity
• Databases Tools : Oracle, MySql, SQL Server, DB2, Aginity, Erwin
• Methodologies : Agile, Scrum, Rational Unified process, Waterfall
• ETL Tools : SQL Server 2005/2008 Integration Services
• Languages : SQL, PL/SQL, Visual Basic
• Operating Systems : MS-DOS, Linux, Windows 2000, NT, XP, VISTA, 7, 8
• Others : Rational Requisite Pro, MS Office, HP Quality Center, Pulse, Clear Case

PROFESSIONAL EXPERIENCE

Confidential

Role: Sr. Data Analyst

Responsibilities

• Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.
• Transformation of requirements into data structures which can be used to efficiently store, manipulate and retrieve information
• Collaborate with data modelers, ETL developers in the creating the Data Functional Design documents.
• Ensure that models conform to established best practices including normalization rules and accommodate change in a cost-effective and timely manner.
• Build data model around data entity Assemble and consolidate business information about the data entity and interpret into a data model that accurately reflects the data entity for the steward's domain of influence.
• Responsible in Generating Weekly ad-hoc Reports
• Planned, coordinated, and monitored project levels of performance and activities to ensure project completion in time.
• Created Complex Teradata scripts to generate ad-hoc reports that supported and monitored Day to Day
• Automated and scheduled recurring reporting processes using UNIX shell scripting and Teradata utilities such as MLOAD, BTEQ and Fast Load
• Involved in Building a specific data-mart as part of a Business Objects Universe which replaced the existing system of reporting that was based on exporting data sets from Teradata to Excel spreadsheets
• Migrated three critical reporting systems to Business Objects and Web Intelligence on a Teradata platform.
• Used SAS procedures to achieve the required data analysis and for data transformations.
• Create various Data Mapping Repository documents as part of Metadata services EMR .
• Provide inputs to development team in performing extraction, transformation and load for data marts and data warehouses.
• Document data quality and traceability documents for each source interface
• Designed and implemented data integration modules for Extract/Transform/Load ETL functions
• Involved in data warehouse design
• Experience with various ETL, data warehousing tools and concepts
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Good Experience with Mainframe enterprise billing systems Involved in defining the business/transformation rules applied for sales and service data.

Environment

Windows, MS Office MS Word, MS Excel, MS PowerPoint, MS SharePoint, MS Access, MS Visio , Informatica, Oracle, IBM Mainframes, RUP, UML, SQL, Quality Center

CONFIDENTIAL

Role: Sr. Data Analyst

Responsibilities

• Defining appropriate security roles related to data Define roles associated with securing, provisioning and auditing security of the data within the domain of stewardship and define named individuals for each required role.
• Closely worked with business analysts in the process of requirements gathering for various application specific databases.
• Involved in creation of use cases using UML and managed the entire functional requirements life cycle using Rational Unified Process.
• Used Graphical Entity-Relationship Diagramming to create new database design via easy to use, graphical interface.
• Conducted GAP analysis and data mapping to derive requirements for existing systems enhancements.
• Designing and customizing data models for Data warehouse supporting data from multiple sources on real time.
• Applied data cleansing/data scrubbing techniques to ensure consistency amongst data sets.
• Developed the logical data models and physical data models that capture current state/future state data elements and data flows using ERwin 7.2.
• Ensured that the logical model is compliant with the conceptual model and all the high-level business rules and integrated and document.
• Defined the Primary Keys PKs and Foreign Keys FKs for the Entities, created dimensions model star and snowflake schemas using Kimball methodology and designed them using ERwin 7.2.
• Facilitated JAR/JAD sessions to determine data definitions and business rules governing the data, and facilitated review sessions with subject matter experts SMEs on the logical and physical data models.
• Applied data naming standards, created the data dictionary and documented data model translation decisions and also maintained DW metadata.
• Additional duties included heavy interaction with the offshore Indian development team.
• Used data profiling tools and techniques to ensure data quality for data requirements.
• Extensively used SQL for performance tuning.
• Collaborated with the QA team to work on SIT and UAT both, maintained quality procedures, and ensured that appropriate documentation is in place.
• Developed and executed queries in SQL for reporting.

Environment

ERwin Data Modeler 7.2, SQL, TOAD, SQL Server 2008, Oracle 10g, IBM DB2, Informatica, Business Objects XI R1, IBM Rational Rose.

CONFIDENTIAL

Role: Sr. Business/Data Analyst

Responsibilities

• Worked with business analyst to gather information on requirements
• Documented Technical Business User Requirements during requirements gathering sessions.
• Analyzed conceptual into logical data and had JAD sessions and also communicated data related issues and standards.
• Involved in modeling business processes through UML diagrams.
• Created entity process association matrices, functional decomposition diagrams and data flow diagrams from business requirements documents.
• Conducted model walkthroughs and validation sessions.
• Used Sybase Power Designer tool for relational database and dimensional data warehouse designs.
• Participated in the tasks of data migration from legacy to new database system
• Worked on Metadata exchange among various proprietary systems using XML
• Handled performance requirements for databases in OLTP and OLAP models.
• Developed Cleansing and data migration rules for the Integration Architecture OLTP, ODS, DW
• Developed data mapping documents between Legacy, Production, and User Interface Systems.
• Used Crystal Reports to generate Ad-Hoc Reports

Environment

Java, Teradata, SQL Assistant, UNIX Shell Scripts, SAS, MS Excel, PowerPoint

CONFIDENTIAL

Role: Business Analyst

Responsibilities

• Participated in meetings with stakeholders, business managers, users to understand and document business requirements and functional specifications for the Workflow.
• Ability to learn, deliver and teach clients teammates and partners the Pegasystems Smart BPM PEGA Scrum Methodology.
• Documented detail Business Process Design and created Use Cases.
• Extensively used MS SharePoint for version control. Uploaded files and maintained folders in Share Point.
• Created Business Rules Spread Sheet BRS as needed and Requirement Traceability Matrix RTM to track the requirements and link it to the test cases.
• Responsible to determine the GAP Analysis between the As-Is / To-Be Business Process Flows.
• As a Project Team Defect Coordinator, responsible for Managing the Defect process for the project and ensuring Traceability to Requirements and Test Cases.
• Defect coordination involved working with the Project Managers, Development, System and UAT testing teams to ensure defects are addressed, managed and closed as appropriate.
• Conducted meeting between the business, development and testing teams to resolve defects in Triage.
• Update defects real-time in Defect Action board meetings
• Work with testing team on submitting defects in HP Quality Center.
• Provided first-level Test Tool support for Quality Center and perform additional duties processing Change Requests, and other tasks as required.

Environment

Windows XP, JAVA, J2EE, JSP, MS Visio, Clear Quest, Requisite Pro, SharePoint SQL, HTML, XML.

CONFIDENTIAL

Role: Business System Analyst

Responsibilities

• Interacted with the stakeholders to get a better understanding of client business processes and gather business requirements.
• Identified Use cases from the requirements and wrote Use Case Specifications.
• Worked with corporate and field executives to manage the expectations of the project and put out fires as changes and new business requirements came up.
• Incorporated best industry practices and worked with the project manager on getting deliverables out under budget and ahead of schedule.
• Created business process workflow diagrams Activity diagrams in Rational Rose.
• Linked business processes to organizational objectives, perform critical path analysis, and identify opportunities for business process improvement.
• Created Use-Cases and Business Use-Case Model after accessing the status and scope of the project and understanding the business processes.
• Created test plan and test cases for user acceptance testing.
• Conducted informal Sessions to develop an architectural solution that the application meets the business requirements, resolve open issues, and change requests.
• Used the Unified Change Management from Rational to track changes to multiple artifacts by versioning artifacts, associating requirements to specific change request/defects to streamline the defect/change tracking process.
• Performed Feasibility and Risk Analysis on tools provided by vendor/third party.
• Assured that there is compliance between Artifacts and corporate SDLC policies.
• Conducted user interviews and tracked client expectations.

Environment

JSP, Web Sphere, Oracle 8i, SQL., Rational Requisite pro, Crystal Reports, MS Word, MS Power point.