SUMMARY:

An experienced professional with a solid background in devising IT solutions for improved business efficiency and bespoke client - facing services. A great communicator who takes great pride in finding the right solution for difficult problems. Highly motivated and currently seeking a challenging Sr. Business analyst/ DA position in the information technology sector.

KEY AREAS OF EXPERTISE:

• Exceptional communication skills feeding an ability to understand and interpret the operational needs of businesses at all levels.
• Keen attention to detail in the identification of potential glitches and threats to performance and security for new applications.
• Analyse multiple sets of data from different systems integrated across enterprise and capability to provide solutions/ outcomes based on same. Expertise in SQL queries.
• Understanding of change management and the implementation of systems within large organisations. knowledge of supplier and contract management & procurement and/or strategic sourcing and support different business initiatives.
• Demonstrated experience in system fault diagnosis, developing solutions and managing resolution. Prioritization and communications with several levels in organization.
• Proficiency in business analysis using all data points and data analytics.
• Retail, Banking and finance, Whole sale Credit Risk, Wealth, Compliance/Regulatory/FED reporting, environment health and safety (EHS), Retail - Supply chain and Energy services (Oil exploration), telecom/insurance.

TECHNICAL SKILLS:

Programming: SQL Server, MySQL, SAAS, queries inclusive of data modelling, data lineage, data mapping, data profiling. SSRS, SSIS ETL, SSAS, DW (data warehousing) and informatica, BI. ERP Microsoft Dynamics

Languages: VB6/VB.Net, Rest/SOAP, XML/ XSD, Java, HTML, JavaScript, ASP.Net, JSON, CSV Microsoft Office Suit, expertise in TFS/JIRA agile execution and MPP, data analysis, MS Dynamics, ERP, xml, data export/import uploads, templates, User stories Requirements gathering/documentation, Business process modelling, Use Cases, Visio, Interviews/surveys/JAD, FRD, HLD, LLD., Manual testing.

Product: MDM, share-point, QC, LoanIQ, AFS, SHAW, Infolease etc back end, Enterprise systems, Confidential / FSDF, QC (Quality Centre/ ALM), Test Cases, test plans and UAT with User training documentations.

EMPLOYMENT HISTORY:

Confidential, Charlotte, NC

Data Analyst

Responsibilities:

• Facilitate work sessions to define new system its data mappings, workflows/ requirements and user stories as needed, and prioritize the same work.
• Define requirements documents and functional details specifications.
• Complete data mappings for multiple downstream interfaces with detailed transformation logics and rules.
• Demonstrate strong interpersonal skills, including the ability to liaise effectively with fellow team members to anticipate technical limitations and glitches and effect smooth system deployments
• Provide written reports and give product presentations to clients to explain system solutions and potential business impacts
• Working with Business/SME to detail out requirements and define BRD/HLD.
• Business process model designing in Visio. Bottom-line of FSD/HLD and LLD/ data design.
• Data mapping, lineage, data source/ ETL and data base analysis/ modelling. SSIS packages design and data mapping.
• Define business rules for each extract and its transformations.
• Research into SWP platform, and multiple other IT systems of Confidential and compare data, using queries, and tools present. And come up with solution for integration etc.
• Ensuring the requirement is broken in most granular unit of work
• Went through multiple online trainings/tutorials/ hands on queries/ to come up to speed with team and to get the depth of functionality and domain.
• Validation of data, by queries, SQL, stored procedures, and validating.
• Testing the application before it goes to end user. Analyse results/issues/root cause and come up with detailed/summary evaluation.
• Data quality and remediation analysis, work with business in analysis.
• End to end project coordination including UAT co-ordination/ defects handing/ analysis and tracking.
• Participation in remediation and providing data templets/ and design them.
• Gained good knowledge of Trust and Wealth Management line of business.

Confidential, Charlotte, NC

Data Analyst

Responsibilities:

• Facilitate work sessions to define workflows/ requirements and user stories as needed, and prioritize the same work.
• Creation if use cases and stories and managing scrum calls.
• FSDF exposure working with Technical team closely when the current platform is migrating to Confidential .
• Demonstrate strong interpersonal skills, including the ability to liaise effectively with fellow team members to anticipate technical limitations and glitches and effect smooth system deployments
• Provide written reports and give product presentations to clients to explain system solutions and potential business impacts
• Working with Business/SME to detail out requirements and define BRD/HLD.
• Business process model designing in Visio. Bottom-line of FSD/HLD and LLD/ data design.
• Data mapping, lineage, data source/ ETL and data base analysis/ modelling. SSIS packages design and data mapping.
• Define business rules for each extract and its transformations.
• Research into Loan IQ, Enterprise and multiple other IT systems of bank and compare data, using queries, and tools present. And come up with solution for integration etc.
• Ensuring the requirement is broken in most granular unit of work
• Process implementation, for better project management, implementation of TFS and opting for agile for better work/ development and change management.
• Participate in development activities. Handling the application releases of reporting data to federal authorities.
• Went through multiple online trainings/tutorials/ hands on queries/ to come up to speed with team and to get the depth of functionality and domain.
• Validation of data, by queries, SQL, stored procedures, and validating.
• Testing the application before it goes to end user. Analyse results/issues/root cause and come up with detailed/summary evaluation.
• Data quality and remediation analysis, work with business in analysis to Confidential ( Corp credit reporting & allowance).
• UAT co-ordination/ defects handing/ analysis and tracking.
• Analysis of different data entry points for different systems, AFS, GBS, FED required formats.
• Participation in remediation and providing data templets/ and design them.
• I was also supporting Wealth Management data conversion for a new Asset management tool.

Confidential, New York City

Technical Analyst

Responsibilities:

• Demonstrate strong interpersonal skills, including the ability to liaise effectively with fellow team members to anticipate technical limitations and glitches and effect smooth system deployments
• Provide written reports and give product presentations to clients to explain system solutions and potential business impacts
• Working with Business/SME to detail out requirements and define BRD/HLD.
• Business process model designing in Visio. Bottom-line of FSD/HLD and LLD/ data design.
• Data mapping, lineage, data source/ ETL and data base analysis/ modeling. SSIS packages design and data mapping.
• Research into Loan IQ, Enterprise and multiple other IT systems of bank and compare data, using queries, and tools present. And come up with solution for integration etc.
• Ensuring the requirement is broken in most granular unit of work and write clear business rules for each extract and its transformations logic.
• Process implementation, for better project management, implementation of TFS and opting for agile for better work/ development and change management.
• Participate in development activities. Handling the application releases of reporting data to federal authorities.
• Went through multiple online trainings/tutorials/ hands on queries/ to come up to speed with team and to get the depth of functionality and domain.
• Validation of data, by queries, SQL, stored procedures, and validating.
• Testing the application before it goes to end user. Analyse results/issues/root cause and come up with detailed/summary evaluation.
• Data quality and remediation analysis, work with business in analysis to Confidential ( Corp credit reporting & allowance).
• UAT co-ordination/ defects handing/ analysis and tracking.
• Analysis of different data entry points for different systems, AFS, GBS, FED required formats.
• Participation in remediation and providing data templets/ and design them.
• Developed confidence and sensitivity in working closely with clients to clearly define operational needs and potential solutions
• Successfully helped in automation of pulling multiple data rather then collecting manually.

Confidential, Charlotte

Lead Business Systems Analyst

Responsibilities:

• I was taken as Reporting Business lead for reporting/KPI module of ERP MS Dynamics for Retails industry inclusive of customer engagement, SME, functional consultants and team. Work as a liaison between business, technical teams and vendors.
• Multiple/ cross module work for eg. - Finance, POS, CRM, Logistics etc. Major focus was reporting for all.
• Handled multiple business initiatives. This included vendor management and multiple vendor communication, and proved to be a great asset for the team.
• Went through multiple online trainings/tutorials/ hands on queries/code to come up to speed with team and to get the depth of functionality and domain.
• Demonstrated ability to interact at all levels of organization. Ability to maintain confidential and sensitive information within limits.
• Performed testing of existing functionality to get the hang of functionality of ERP and requirements.
• Writing complex queries to create data structures and coming up with sample data sets for reporting mock-up designs.
• Data mapping/ integration and talk to multiple systems including data transformation.
• Sql server/ SSRS design and validation to ensure the correctness of data.
• Ensure the what part is answered with all data points and be able to dig into issues and come with with appropriate solutions.
• Created planning documents and written reports. Created multiple SSIS packages/ data mapping with existing systems to new db tables.
• Written high quality requirement specifications to support ERP functional design development. Which includes complex business rules for each report and KPI.
• Lead and written detailed functional test plans to ensure system changes work properly, existing processes remain unaffected, and the needs of the users are met.
• Creates scripts for training all internal users, support personnel, and external customers on ERP system changes and new procedures.
• Taken all issues, doubts the team was facing with customers/ consultants to get them to closures with the complete track of those.
• Managed the requirements in TFS, using Agile methodology.
• Managed to gain the customer confidence back after 2 months of joining the team and the same was communicated to senior management by clients.
• To ensure the team health, started having daily 15 minutes’ scrum meetings, resolved team issues, tried to manage team personnel issues, by rotations.
• Anchored the complete UAT as a single point of contact, for technical team users and different stakeholders and daily status reporting with in-depth knowledge of issues.
• Going forward, ensured schedule adherence and timely deliverables, Scope management, Management reporting.
• Issue minutes of meetings and progress reports to project team
• Managed internal data, including identifying risks to data integrity, disaster recovery and restoration
• Provided high levels of technical support for internal staff and contractors

Confidential

Systems Analyst/ Implementation Lead

Responsibilities:

• Lead the implementation of product sustainability/ EHS for GRI, and Confidential (ISCRS) in .Net, SQL server 2008, SSRS/SSAS.
• Lead Fit/Gap analysis for their requirements and after mapping the same to product KPI, done the required customizations in products. Participates in all design activities and lead the same, write complex queries self.
• Lead the data analysis part for implementation of the product and lead the analysis.
• In depth knowledge and zeal to deal with data issues, until solution is defined. Able to come up with reasons of problems, work in panic situations with multi tasking skills.
• Requirement gathering/ documentation was done using use cases/ visio and the complete tracking in TFS.
• Played a role of a scrum lead, to anchor the daily meeting and assignment of tasks at time.
• Converting business requirements, into functional specifications, and data model designing and customizations.
• Worked on SSIS to transfer/load data from existing systems to new data bases, mapping and transformations.
• Defined the rule book for user trainings, product collaterals, stakeholder ownership from each location, SPOC.
• Anchored the customization engineering with agile methodology, with a team of 15 people, for 30 locations at once.
• Prepared questionnaires, feedback and surveys independently to gain confidence and improvisations in product.
• Setup the complete support group when the product went live, which included setup for infrastructure, costing, budgeting approvals, and release management for several departments.
• Give generic requirements to Product team, to include them in roadmap, for future releases.
• Worked with marketing/sales managers to create product flyers, gave products demos to multiple customer teams, by showing their data points in the reports.
• Participated in product demos, to multiple clients across geos.
• Anchored complete UAT and stakeholder management.

Confidential

Lead BSA/ PM

Responsibilities:

• Work with SME, Business users and write the requirements and business cases
• Part od data modelling team and creation of data structure, creation of sql queries ad sample data inclusive of validation and default scenarios.
• Create use cases, test plans and prototype.
• Help writing technical specifications, participated in data base designing, and modeling and data sets.
• Later lead the Business Analyst group in Product, scheduled requirement gathering meetings, with SMEs.
• Complete ownership of agile methodology in tool TFS, for sprint planning, scope and user stories.
• Status reporting to senior management, created many presentations with data points.
• Done extensive testing myself to get to know the health of product, data base queries, data verification, etc.
• Handled defects triage calls to have smooth UAT.
• Participated in all technical design and decisions with tech arch, and worked with them.

Confidential

Technical Analyst

Responsibilities:

• Wrote clear-cut business and technical requirements documents, use cases and related technical design specifications that drove successful application creation.
• Write stored procedures suing sql queries/ to fetch data and show on several reports.
• Able to do all kinds of CRUDS/ DDL and DML operations.
• Capability to use DTS services of SQL server.
• Singlehandedly handled the requirements gathering with onsite clients, at Houston, and delivered to team.
• Take care of coding, reviews, designs, test cases, deliveries.
• Status reporting to all management on times, followed the processes to support all managerial activities to senior managers, and provided all data whenever required.
• The client technical manager recommended to-do continuous work with us
• Led and mentored a client team of four, maintaining high project SLA levels (CSAT scores of 5/5 for 3 years)