SUMMARY

• Diversified work experience with over 6 years of experience in variety of IT Business Analyst / Data Analyst roles in IT industry on all phases of a SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experienced in Data Warehousing solutions by identifying business requirements and quickly turning business requirement into technical design. Experienced in renewable energy data acquisition process for both Operational and Revenue data for different reporting needs.
• Lean Six Sigma Yellow Belt Certified
• Experience working on Agile and Waterfall methodologies.
• Lead Team of 6 personnel (onsite) and (2 offsite)
• Expertise in creating all necessary documentation such as Business Requirements Document (BRD), Functional Requirements Document (FRD), Use Case Document (UCD), System Requirements Specifications (SRS) and supporting documentation
• Expertise in conducting “AS IS” - “TO BE” GAP Analysis and eliciting high-level business requirements. Also involved in defining Scope, Project plan, Impact Analysis, and Requirement Traceability Matrix (RTM) on the on-going projects.
• Worked extensively with QA Team in creation of test plans, test scripts, test cases and performed Black Box testing including system testing, integration testing, end-to-end testing, regression testing and User Acceptance Testing (UAT).
• Experienced in Lean Business, Process Map, SIPOC, Pareto Analysis,FishboneDiagram
• Experienced in Gathering Requirement and writing Functional and Technical Specifications.
• Analyze, model and organize information in order to document software requirements for development efforts in adherence to PMO and System Lifecycle (SLC) standards. Help develop documentation to support software development efforts (including use cases, requirements, process maps, and desk procedures).
• Experienced in RDBMS & Data Warehousing, experience in design, development, testing, implementation and support
• Experienced with Data Flows, Data Architecture and Data Dictionary.
• Strong understanding of data modeling in data warehouse environment such as star schema and snow flake schema.
• Experience with Business Process Design/Analysis/Modeling/Re-engineering, Requirements analysis/Traceability/Management, Use Case Analysis, System Analysis and Design, Configuration/Release Management, Change/Defect/Risk Management.
• Experienced in writing SQL queries and testing scripts for data validation
• Experienced in Disaster Recovery process and procedures.
• Experienced in reading and understanding Java / C# / Python code for Business and Data Analysis

TECHNICAL SKILLS

Methodologies: Agile, Waterfall, JAD, Kanban

Requirement/Project Management Tools: MS-Word, MS-Excel, MS-PowerPoint, MS-Project, Confluence

Content Management Tools: MS-SharePoint 2010, Confluence 6.3

Business Modeling Tools: MS-Visio, Gliffy, ERWIN

Databases: MS SQL Server 2008/2012/2014 , Oracle 11G, Process Book(PI), Cassandra, PostgreSQL

Programming Language: Python 2.7, 3.6, C#, HTML, CSS

Reporting: Power Pivot, Power View, Power BI

CRM tool: Salesforce.Com

AWS Cloud Technology: S3 Buckets, PostgreSQL, Redshift, Amazon Glacier

Data Science Tools: Python 2.7, Anaconda Python 3.6, Python Library - numpy, pandas, dataframe, cx Oracle, plotly, matplotlib

PROFESSIONAL EXPERIENCE

Confidential, Juno Beach, FL

IT Business Data Analyst / Systems Analyst

Responsibilities:

• Work with multiple stakeholders to understand business needs and develop business cases and elicit business requirements using a variety of techniques and translate them into detailed functional requirements for complex IT technical projects.
• Communicate effectively, including facilitation, negotiation, priorities and conflict resolution, with a wide variety of technical and business experts and stakeholders in both individual and group settings.
• Act as a liaison between technical and business teams to help enable successful implementation of technology projects.
• Preparing BRD's (BusinessRequirement documents), FRD (Functional Requirement Document's), SRS (System Requirement documents) and User stories etc.
• Complete documentation for project development efforts (including use cases, requirements, test plans, process maps, and desk procedures) and work closely with development team and business teams to help enable successful implementation.
• Create Wireframe, write user stories, personas and develop business process diagrams
• Create and maintain necessary documents for the projects.
• Experience creating process diagrams, workflow diagrams, UI, UML using Visio.
• Created User Acceptance Testing(UAT) plans and several other types of test cases for each project to ensure that the system runs smoothly after the proposed enhancements.
• Experience working on JIRA for Project requirements, time line and backlogs
• Experienced using Jira for Product Backlog, Sprint Planning, User Stories, Epics, and for bug tracking.
• Created documents such as Project Charter, Project Scope, Business Requirement Document (BRD), Test scripts, Test cases, Test Plans for User Acceptance Testing (UAT).
• Created Business Process Flows, Data Modeling, Design & Analysis, Requirement Traceability Matrix, and As-Is to To-Be processes for various Projects
• Conduct JAD sessions to solve the different issues occurred during the project development.
• Execute SQL queries, PL/SQL stored procedures, and triggers on back end as a part of data analysis and data validation.
• Conducted Proof of Concept experiment in Cassandra (Big Data) to demonstrate capabilities and suitability for a project.
• Conduct Data analysis from Python by utilizing various python libraries for data analysis. Utilized numpy, data frames, panda libraries extensively for Data Analysis
• Experienced in Data Analysis using various Python libraries (plotly, matplotlib, scipy, python-twitter, data frame, cx Oracle)
• Configure Amazon Web Services EC2 Instance, and used Python to write data from Oracle to S3 Buckets.
• Experience and good understanding of Amazon Web Services, AWS EC2, AWS S3, Cloud watch, Amazon Redshift etc.
• Write and Built API’s requirements during the design phase in order to make the software efficient and programmer friendly.
• Troubleshoot and debug connectivity issues at solar sites in process of data acquisition
• Analyze different data source, coordinate and build relational model with Data Warehouse team.
• Provide ETL mapping documents to development team with the location of the table in database, conversion rules and business rules
• Created logical and physical data model design for Data Warehouse using ERWIN
• Identify Operational and Revenue data and separate into different relational tables for reporting purposes.
• Performed Data alignment and Data cleansing
• Designed and created data reports using various reporting tools such as Toad.
• Experience writing analytical SQL queries to perform data analysis and data validation and quality check.
• Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models used for reporting purpose
• Experience in rapidly changing business and technological environment and take lead in unstructured situations.
• Carries data architecture ownership to develop data models, metadata solution which meet the needs of the organization's information systems, manages data dictionary and the flow of information leveraging variety of data platforms
• Maintains data integrity by working to eliminate redundancy. Participates in Data Governance meetings and engages with cross functional teams to stay informed of the ways the organization uses its data and understands its potential impact to delivery of specific initiatives
• Track progress of the product development and reports to the IT and business stakeholders on delivery status of the data management capabilities, functionality and applications
• Drive efficiency and process improvement, utilizing leadership skills, data analysis and strong understanding of the business strategies.

Environment: AWS, S3 Buckets, Redshift, Python 2, 7 / 3.6, Oracle 11g / 12c, Informatica 9.6, SQL Server 2012/2014, Java, Scala, .Net, Confluence, Bitbucket, Visio, Gliffy, MS-Office Suite, ERWIN, Power Pivot, PowerBI, JIRA, ApiGee

Confidential, Irving, TX

IT Systems Analyst / Business Analyst

Responsibilities:

• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Facilitated Joint Application Design (JAD) by bringing in all the users, stakeholder and development team to convert requirements into specific technical needs. Also conducted one on one interviews as a part of the elicitation technique.
• Worked extensively with SME’s in understanding, extracting, refining and documenting the User and Business Requirements pertaining to reporting.
• Researched existing documentation and conducted GAP Analysis in order to determine the as-Is and to-Be state of the company.
• Conducted Impact Analysis to determine the effects of the changes being proposed on the existing system.
• Authored the Business Requirements Document and Functional Requirement document (BRD, FRD) with project teams. Extracted, discussed, and refined business requirements from business users and team members.
• Drafted Test Scenarios and Test Cases to make sure all requirements are addressed at the test case level.
• Foster the refinement, understanding and enhanced utilization of process measures and benchmarking.
• Provide analytical support of business operations - develop solutions to data requests, maintain operational and financial reports, prepare queries for data gathering, conduct analyses of work processes, and perform statistical and ad hoc reporting.
• Monitor business controls, verify, maintain, and report operational results, scorecard targets, and initiatives.
• Review/create reports, presentations, and databases to support operations and identify opportunities for efficiencies
• Documenting project details for future reference.

Confidential, MO

IT Systems Analyst / Business Analyst

Responsibilities:

• Designed, implemented and deployed custom objects, page layouts, custom tabs and components to suit to the needs to the applications
• Defined lookup and master detail relationship on the objects and created junction objects to establish connectivity among objects
• Used various sandbox environment for testing migrated code
• Used Apex Data Loader for insert, update, and bulk import data from and into Salesforce.com platform
• Experienced in various activities of the project, information gathering, analyzing the information, documenting the functional and non-functional requirements.
• Responsible for scheduling/conducting meetings, JAD sessions, analysis development, test inspections, and other project meetings throughout project life cycle.
• Worked on various Salesforce.com standard objects like Accounts, Contacts, Leads, Campaigns, Reports and Opportunities.
• Implemented the requirements on Salesforce.com platform and Force.com IDE Plug-in using Eclipse.
• Experience in Salesforce.com application setup activities and customized the apps to match the functional needs of the organization.
• Worked in field & page layout customization for the standard objects like Account, Contact, and Leads.
• Experienced in creating and customizing Email template and configuring them to the email alert within the workflow rule for a standard/custom object.
• Developed various Custom objects, Tabs, Entity-Relationship data model, validation rules, workflow, and approval processes.
• Implemented Security access to the user profiles by creating Object level security, field level security and record level security.
• Developed Apex Triggers, Apex Classes and Test Methods.
• Used Data Loader for insert, update, and bulk import or export of data from Salesforce.com Objects. Used it to read, extract, and load data from comma separated values (CSV) files.

IT Systems Analysts (Consultant)

Confidential, TX

Responsibilities:

• Developed a Database for Small Business Entrepreneurs Conference ( Confidential ) at Texas A&M University Commerce.
• Extensively used SDLC (Software Development Life Cycle) methodology and Project Life Cycle in undergoing the project.
• Worked Extensively in MS-SQL Server 2008, and MS-Visio.
• Created Use Cases, Use Case Scenarios, Activity Diagrams and Data Flow Diagrams.
• Performed operations such as Stored Procedures, Queries for database objects
• Created Detailed Use cases, User Stories, Story boards, Customer Journeys, Test Cases including identified exceptions and alternate paths based upon analysis of the existing application
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Facilitated Joint Application Design (JAD) by bringing in all the users, stakeholder and development team to convert requirements into specific technical needs. Also conducted one on one interviews as a part of the elicitation technique.
• Designed data and source-to-target mapping work.
• Worked on mapping and modeling of the data.
• Checking and validating data in the Mapping document running the queries.
• Documented and maintained RTM (Requirement Traceability Matrix) to ensure that all requirements are traceable from top to bottom, hence provide a basis for test plan.
• Modified the existing mapping template to a more clear and easy to understand template.
• Developed ETL mappings, testing, correction and enhancement and resolved data integrity issues.

Environment: Informatica, Windows XP, Windows 2003 Server, Excel Macros, OLAP, MS VB, MS Office, UML, and Power designer.