Lead Systems/data Analyst Resume
Hartford, CT
SUMMARY
- Around fifteen years of diverse IT experience in requirement analysis, design, implementation and quality assurance.
- Experience in analyzing business and systems requirements, solving design problems by creating architectural solutions and executing strategy based on enterprise needs.
- Experience determining solution paths for data integration and data transmissions to enable linking systems and applications by leveraging EDI standards and updating technologies.
- Expertise in designing, developing, coding, debugging, testing and implementing multi - tier Web portal and client-server applications.
- Possess management skills, experienced in leading teams towards accomplishing projects goals.
- Expertise in client/ server, Web based and intranet applications and extensive experience in analyzing data models, UML, BPMN and Object Oriented analysis and design.
- Extensive work experience performing queries with SQL.
- Experience and knowledge of Middleware technology and data warehousing concepts.
- Extensive experience interacting with external vendors, domestic and offshore clients and partners using Web live meeting and conference calls.
TECHNICAL SKILLS
Development Technologies: C, C++, Siebel escript UML, XML Schema, XML, Siebel CRM, SOAP
Web/Application Servers: Siebel
Web Presentation: JavaScript, HTML, XML
Operating Systems: UNIX SUN SOLARIS 5.8, MS Windows 95/98/NT/2000/XP/8
Databases: Oracle, IBM DB2, SQLServer
Tools: CRM Tool (Siebel), Requisite Pro, Test Director, QlikView, PowerShell
PROFESSIONAL EXPERIENCE
Lead Systems/Data Analyst
Confidential, Hartford, CT
Responsibilities:
- Designed a one-view application for the purpose of producing Analytic reports on data usage such as virtual storage and user device optimization, across all lines of business as a part of the infrastructure efficiency and effectiveness program.
- Lead a team of analysts and developers in building an analytics and reporting tool.
- Worked with the ETL teams by analyzing the Meta data extract to support the usage of key data elements.
- Managed the data dictionary and performed data mapping for multiple systems.
- Multiple project experience in data flow analysis, data analysis, reviews, process flow analysis and coming up with system design.
- Gathered requirements from business and technical SME’s across business units.
- Translated requirements into functional requirement specification (FRS) documentation from EBNs (Expanded Business Needs).
- Documented requirements as use cases, screen mockups, data mapping, screen definition documents and functional requirement specification.
- Assisted in the preparation of technical specification documentation.
- Worked on preparing service requests and aided in the preparation of project change requests.
- Designed process oriented, use case and activity diagrams to define the system process.
- Traced requirements from the initiation to the testing phase of the SDLC process.
- Facilitated the weekly project status meetings and effectively coordinated the status reports to the respective management and project stakeholders.
Environment: Agile Methodology, Android, Java, MS Visio, SQLite, SQL Server, MS Office Suite, SharePoint, QlikView, Powershell.
Research Assistant
Confidential, Commerce, TX
Responsibilities:
- Maintained the eLearning Portal, which facilitated students to access course materials through unique credentials.
- Analyzed existing portal capabilities and created an architecture based on functional requirements.
- Conducted JAD sessions with stakeholders and identified functional capabilities and requirements.
- Captured requirements and designed architecture via workflow and component diagrams.
- Enabled development team through coding of the application.
- Coordinated the technical team through unit testing.
- Provided guidance to the testing team through their testing efforts.
- Provided status of project to the project stakeholders on a timely basis.
Environment: Waterfall Methodology, Java, MS Visio, SQL, MS Office Suite, DB2, SharePoint.
Solutions Architect/Technical Lead
Confidential
Responsibilities:
- End to end solutioning and the designing of the retail promotional planning and field force management used the Siebel CRM platform.
- Conducted JAD sessions and elicited requirements through brain-storming sessions including the business users and business area experts.
- Conducted workshops with the business stakeholders in order to finalize the design of the prototype before the development phase.
- Technical lead in redesigning the existing database design and configuration to support the globalization and localization of the existing CRM application.
- Closely worked with subject matter expertise, analyzed user problems, including automated and manual business processes and defined and documented the business processes.
- Configured and developed Siebel applications using Siebel Scripting (server and browser), workflow processes, workflow policies and runtime events and business services.
- Conducted workflow, process diagram and gap analyses to derive the requirements for existing systems enhancements.
- Worked with the development teams in designing/enhancing applications to meet refined requirements.
- Actively involved in the review and comment on technical design specifications and to resolve technical issues.
- Queried and performed research and analysis of data from multiple data sources to understand the existing systems and data.
- Lead a team of analysts and architects by mentoring and leading the team.
- Actively involved in data analysis and extraction for generating reports to the downstream applications.
- Provided and recommended efficient, cost effective solutions which supported client business processes and functional requirements.
- Designed the solution architecture of the BSS Transformation Program using the Siebel CRM platform.
Environment: Waterfall Methodology, Siebel, MS Visio, Clear Case, SQL, Oracle 8i, MS Office Suite, MS Project.
IT Consultant
Confidential, Durham, NC
Responsibilities:
- Successfully lead multiple projects from the project initiation stage to the deployment.
- Served as a tool to communicate business requirements to data management vendors to assure consistency across clinical trial projects.
- Ensured that programming and testing procedures are addressed and that all scheduling aspects of projects are monitored.
- Reviewed business requirement documents and the technical specifications.
- Interviewed the business users to understand their business and functional requirements, gathering their future needs and transforming them to functional specifications.
- Developed documents to apply to any clinical trial (pre and post-approval) or registry that uses electronic data capture technology for capturing data onto case report forms (CRF) and product service report.
- Prepared business process models that depicted modeling of all the activities of the business from the conceptual to procedural level
- Used prototypes to demonstrate and verify the behavior of the system.
- Designed Data Flow Diagrams (DFD’s), Entity Relationship Diagrams (ERD’s) and Web page mock ups using modeling tools.
- Provided technical and procedural support for User Acceptance Testing (UAT).
- Strong knowledge in Siebel Architecture and data model and extensive experience in providing techno-functional CRM solutions.
- Extensive experience in system design and development using scripting and EAI (Integration Workflows, Web services and Integration Objects).
- Conducted the requirements and design walkthroughs with designers, developers and management staff.
- Maintained and tracked the stakeholders requested enhancements and changes.
- Maintained different builds of the application with description about all changes and versions.
- Conducted interviews with the various stakeholders to develop the architecture of the application.
- Re-engineered the process to achieve compliance with current methodology, improve process time and reduce customer complaints, increase efficiency of operations and minimize risks in transaction processing.
- Conducted test plan walkthroughs for review in accordance to the portfolio release plan.
- Created test strategy and coordinated with the project manager to ensure testing all modules as per the project plan.
- Worked with internal and external teams to understand business and functional requirements to create test plans and test strategies.
- Performed User acceptance, regression testing and system integration testing through manual and automated testing.
- Logged and addressed defects and resolved test defects to closure.
Environment: Waterfall Methodology, Siebel, Clear Quest, SQL, Oracle 8i, IBM Db2, MS Office Suite, MS Project, Test Director, WinRunner.