Professional Summary:

• Senior analyst with 9 years of IT experience in Telecom, Finance / Banking, Energy/Manufacturing Services, Government and Insurance business thorough understanding of functional areas complex projects and the ability to identify and quantify process improvements along with data integrity and business modeling.
• Experience in engaging with senior business leaders for deploying data solutions quickly and iteratively, with your strong business acumen and in depth knowledge of technology.
• Successful in rapid deployment of analytical solutions that are of high business impact.
• Collaborate closely with customers on a consultative approach to understand business and objectives in order to recommend best practices and ensure implementation success and a high level of customer satisfaction.
• Facilitate enterprise level process improvements with strategy development through cross-team engagement and creation of artifacts that promote business effectiveness and efficiency while striving for innovation, flexibility, and integrate modernized technologies within product development lifecycle.
• Experience in organizational change management and hands on with IT Service Management processes Incident, Problem, Change, Release, SLM, Service Catalog, Configuration Management Database, Asset Management understanding of enterprise IT architecture and working knowledge of relational databases.
• Excellent business judgment, analytical and problem solving skills, and experience applying these skills to analyze large, complex, multi-dimensional data sets.
• Good understanding of methods used in data requirement definition and analysis to support the business.
• Experience in facilitating requirements and testing sessions and supervise onshore/offshore teams.
• Strong analytical and problem solving skills, multitasking abilities, with proven experience in utilizing people and process knowledge to assist team in critical decisions and manage multiple projects at a time.
• Experience in dealing with multiple projects and cross-functional teams, and ability to coordinate across teams in a large matrix organization environment in an Agile software development lifecycle SDLC .
• Hands on expertise and experience in ITSM ticketing tools, Active Directory, Windows and Unix platforms.
• Extensive experience in gathering business requirements in working with business user community and SMEs.
• Hands on experience with Reporting outputs in the form of Ad-hoc reports, Custom Reports, Dashboards, self-Service/Web-Service and Data Feeds and Product Support.
• Hands on experience with Service Oriented Concepts: Web Services, Service Oriented Architectures SOA , Enterprise Service Bus ESB , Cloud Computing technologies.
• Self-motivated, team player, effective communicator with excellent leadership skills in business presentations, documentation, business reports and technical specification, with flexibility to learn new technologies.
• Extensive SQL use for data sampling, data verification and backend testing.
• Member of the District of Columbia Chapter - Association of Information Technology Professionals AITP .

Technical Hands-on

Professional Experience:

Confidential

Business Intelligence Operations Analyst

Responsibilities:

• Collecting requirements from the development and service assurance team and formalize information in to template for standard operations.
• Lead, design and develop Operations Service Procedural guides and Support Manual to enable business partners to manage BI and DI Operations effectively.
• Refining existing metrics or creating new metrics.
• Partner and support business units on the day-to-day execution of analytics, projects and initiatives.
• Partnering with business units to understand their processes, define KPI's, and provide actionable analysis and insights to drive constant improvements.
• Develop metrics, dashboards and analysis that are customer focused and can drive positive changes to business processes.
• Identify data sources, and aggregate data into digestive format to provide meaningful insights to business teams.
• Create information management roadmaps to ensure ongoing effective data management operating support, which includes analytical training and transparency in enterprise wide data management and procedures.
• Maintain business glossary and the data catalog for the business and project teams to refer and follow standards.

Environment: PeopleSoft HR , COTS, BMC Remedy, Oracle11G, OBIEE, Visio 2010,Project 2010, MS office 2010, Informatica- Power Center, SharePoint, Oracle E-Business Suite, Cognos Reporting, Sales Analytics.

Confidential

Business Analyst/ User Acceptance Data Analyst

Responsibilities:

• Reconcile Single Class and Multi Class data sets associated with the Risk Based Capital Securities process
• Conduct data testing and analysis, participate in data transformation logic and data derivation testing, create and analyze ad-hoc reports and support escalation/resolution of project risks and issues.
• Data handling large count of loans, capturing /processing data run business rules and recognize data patterns.
• Create/update production procedures with SME presentation and signoff.
• Formulates test strategy for testing through analysis of data requirements develop and maintains manual and test plans and detailed test cases that are repeatable and execute automated test scripts as designed.
• Manipulate complex data tables via queries and other logical applications to extract and present facts, trends, counts, quality, inconsistency and other revealing contents provided by the data.
• Data validations and Reconciling data errors by identify any issues that exist within the data.
• Gathered Data / Business requirements for the Multi-Family Relational Data Warehouse MF-RDW used to develop and deploy a new system that enables the submission of Acquisition and servicing data to FHFA.
• Analyze and Research data items and generate data for downstream systems. Conduct periodic Data dictionary to Data requirements sync up and researched the discrepancies.
• Created test cases and test sets in the Test plan and Test Lab segment of the Quality Center tool and maintained traceability between the created test cases and business requirements.
• Co-Authored the Source to Target mapping document after coordinating with the development and the SME's for the Relational Accounting Data Warehouses RDW and ADW .
• Created SQL queries using TOAD to enhance and validate automation queries and conduct acceptance testing.
• Providing the daily testing status and raising defects for the RDW Simplification efforts.
• Research on defects raised and provides resolution strategies and in depth analysis of transformation logic requirements and derivation, scheduled to retest the raised defects and provide UAT exit summary.

Environment: SAS-BASE Clear Quest, COTS, BMC Remedy, TOAD, Oracle 10G, HQ- Quality Centre, Adobe, MS office 2007, EPF, Business Objects, DOORS, SharePoint, Enterprise Metadata Repository, Bloomberg Terminal.

Confidential

Lead Business Analyst

Responsibilities:

• Develop solutions to configuring COTS and developing automated processes, keeping in mind scope limitation and the impact of other services, set up standard reports, ad hoc analyses, and provide access to key data.
• Performing requirements analysis and implementation of ITSM tool develop documentation and maintain SLA.
• Lead the planning, implementation, and support of Service Now Service Desk and associated cloud-based solutions for State Agencies, documents perform ad hoc and iterative technical reviews
• Develop artifacts process flow, transition state diagrams, etc. as they pertain to enterprise level processes spanning multiple projects and/or functional areas.
• Create detailed work-stream proposals which include, functional data business requirements, process flows, use cases, information needs, test scenarios, and obtain associated functional design specification approvals.
• business requirements into technical requirements
• Closely work with end users, management, and developers discuss document and baseline on application designs
• Provide COTS configuration and customization assistance including to screen tailoring, workflow administration, report setup, data imports, LDAP integration, custom scripting and third party software integrations.
• Implement new functionality design, configure and customize new applications and modules assist in release management and troubleshooting patch support technical and application configuration user issues
• Documentation review over business requirement document BRD , gap analysis, use cases, business process modeling diagrams, activity diagrams, and wireframe prototyping.
• Work closely with DBA to ensure that database objects meet data and performance objectives.
• Systems mapping and business analysis of the integration dependent systems.
• Managed and mentored a team of 4 Business Analysts. Communicate schedule, updates and issues to business.
• Creating and updating documentation on Subject Matter Information within Share-Point.

Environment: MAXIMO, Service Now, AMS Advantage, QTP, QC, Info Advantage ,COTS, MS SQL Server Management Studio, Web Report Crystal Reports Business Objects, VSS, SSRS., Beyond and Compare.

Confidential

Business and Data Analyst

Responsibilities:

• Gather and document requirements, design and develop solutions, and lead those efforts to completion.
• Work with internal clients and other team members to understand and define reporting requirements. Designing and producing client-ready reports and data visualizations using relational/aggregate databases.
• Maintain continuous communication with customer and team members and promote a team environment.
• Use advanced data visualization tools to contextualize information in a manner suitable to key business user audiences document reporting requirements and define report templates and dashboard specifications
• Identify key business metrics measurements and develop methods to represent data in support of the measurements. Provide guidance and insight on data visualization and reporting/dash-boarding best practices
• Extensively perform data analysis in excel with pivot tables, macros, v-lookups and using external data sources.
• Build dashboards, automated and report templates using SQL build custom datasets for reporting and analysis
• Work directly with end users to ensure results meet their needs conduct interviews and requirement workshops to ensure that business detailed requirements are captured and documented.
• Translating Business Requirements into Systems Requirements with defined ranges to be used by Development.
• Perform Data analysis and reporting task within the data mining team with strong understanding of relational databases, extraction techniques, proficient with analytical tools and interpreting the mined data.
• Develop detail requirements for approved complex projects and enhancements to existing large-scale projects.
• Ensure sign-off of all artifacts. Develop requirements trace-ability matrix, which is charted and documented through each phase of the project life-cycle and develop System Requirement Specification SRS .
• Interface with Business Stakeholders and IT Infrastructure teams. Assist with identifying and estimating the cost of projects that are submitted through the strategic planning process.
• Used MS Visio to carry out the business modeling, data modeling, and object modeling efforts to develop the business architecture for rapid and controlled application development.
• Define, test and audit the execution of custom Metric logic that lives in ETL code, develop and Maintain build, testing and documentation standards, including automated testing efforts.
• Extract data corresponding systems and mapped data values and tabular, scrubbed and consolidated data, and performed Data validations and verified data values to meet the requirements. Worked to create Data Mapping documents and worked with business to write transformation rules.
• Perform data analysis on multiple data sources, data cleansing to detect and correct corrupt data and was responsible for creating and maintain end-to-end data mapping and data conversion spreadsheet.
• Documented step by step process of data extracting cleansing consolidating and validating.

Environment: MS Office Suite, Java, J2EE, Web Services, XML, HTML, UML, MS Visio, Oracle e-business Suites 11i, Maximo, RoboHelp v8, EMAC, Micro strategy, JD Edwards, Petro man, Ceridian, Excalibur, AS400, RVI.