We provide IT Staff Augmentation Services!

Lead Systems/data Analyst Resume

0/5 (Submit Your Rating)

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.

We'd love your feedback!