SUMMARY:

• 8+ years of Industry experience as a  Sr. Business / Data Analyst  with solid understanding of, Data Modelling, Evaluating Data Sources, ETL Development  and strong understanding of  Data Warehouse/Data Mart Design, ETL, BI, OLAP, Client/Server applications.
• Experience in supporting the design and testing IT applications related to Capital Markets & Fixed Income Derivatives, capital modeling, capital reporting, Revenue, risk data analysis and Data Warehouse & Reporting Services in various industry domains like Banking, Telecom and SEM.
• Knowledge of the Software Development Life Cycle (SDLC) phases such as Planning, Analysis/Design, Development, and Testing for the software/system development process.
• Working knowledge of reconciliation of exposure data to General Ledger (GL).
• Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Good understanding of Business Requirements , Physical and Logical Data Modeling, Data Definition Language, Data Normalization and UML.
• Excellent knowledge on  Perl  &  UNIX.
• Extensive Experience in Teradata Utilities like Fastload, Multiload, BTEQ, TPump, FastExport and Teradata Parallel Transporter (TPT) on UNIX environments
• Experienced working with  Excel Pivot  and VBA macros for various business scenarios.
• Strong skills for preparing adhoc reports in Tableau.
• Good understanding of Business Requirements Modeling, Physical and Logical Data Modeling, Object Modelling, Data Definition Language, Data Normalization and UML
• Strong experience in  Data Analysis, Data Migration, Data Cleansing , Transformation, Integration, Data Import, Data Export   and writing  SQL and PL/SQL  statements - Stored Procedures, Functions, Triggers and packages.
• Experience in  automating and scheduling  the ETL jobs using UNIX shell scripting in Autosysy.
• Experience in testing  Business Intelligence reports  generated by various BI Tools like Tableau.
• Extensive experience in creating Business Requirements Documents (BRD), Functional Business Requirements (FBR) and conducting various analysis like GAP, SWOT.
• Excellent in creating various artifacts for projects which include  specification documents, data mapping  and data analysis documents .
• Expertise in creating Test Plans and Test Cases from the Requirements documents for distinguished testing efforts like Performance and User Acceptance Testing (UAT)
• Proficient in coordination of defect management and monitoring the status using Bugzilla, JIRA, Quality Center, ServiceNow.
• Extensive experience in the Implementation of Data Warehousing using Extraction, Transformation and Loading (ETL) and Reporting.
• Experience with query optimization and ETL loading on Teradata, Vertica DB performance tuning.
• Experience in Python and UNIX shell scripting for processing large volumes of data.
• Experienced in handling change management process, production support and maintenance project.
• Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
• Experienced in creating Use Case Models, Process Flows, Workflow Analysis and Unified Modeling Language (UML) Diagrams like Class, Use Case, Activity, Swim Lanes and ER Diagrams using popular designing tools. 
• Highly motivated team player with excellent Interpersonal Skills, Organizational, Analytical, Presentation Skills, and Excellent Oral and Written skills.
• Proficient in interacting with stakeholders, workshops and existing system documentation or procedures and defining business processes.

TECHNICAL SKILLS:

Operating Systems: Windows, Linux, Solaris

Databases: MS Access, MS SQL Server, Oracle, Sybase, Teradata

Design and Tools: MS Office, MS Project, ZEN, JIRA, Rally,, MS VISIO, Enterprise Architect, Toad, Gliffy

Data warehouse tools: Informatica, Lavastrom

Quality Management Tools: Quality Center/ALM, Rational Clear Quest,, ZEN

Programming/Scripting Languages: Unix/Perl scripting, Python, C, VB Script, R

Document/Content Management Tools: Documentum, MS SharePoint

Knowledge Management: Share point, Twiki sites

Applications / Tools: Tableau, MS Office Suite, Toad, Perforce

PROFESSIONAL EXPERIENCE:

Confidential

System Data Analyst

Responsibilities:

• Scraping data from diverse platform’s and applying business logics and loading data to Snowflake(Cloud) database
• Responding for incoming requests from the Business users and understanding business requirement.
• Prepared Logical Data Models that contain a set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements
• Handle the analytical request from business users using Tableau.
• Help business users by providing the forecasting report for revenue to monetize the traffic.
• Helped design scope document and to coordinate with top management for the approval process.
• Helped design scope document and to coordinate with top management for the approval process.
• Extract large datasets from PADB(Paracceldb) and load it in Snowflake cloud database via s3.
• Involved in extensive DATA validation by writing several complex  SQL  queries and Involved in back-end testing and worked with data quality issues .
• Upload daily feeds from external server on s3 using multipart upload feature of AWS and then load this data into Snowflake cloud database
• Wrote python scripts to automate the load and the job failure alerting
• Created Python programs to analyze complex data structures from varied sources.
• Attending audit meetings with project leader and higher management people.
• Wrote SQL code to help the business users.
• Maintain service now tickets for incoming incident/requests from the users and interacting with the users for the same.
• Analyze the project code and business requirement and suggest lots of improvement to multiple teams.
• Attending turnover meetings (tools: Gitlab, TCM)
• Regular interaction with the Business Users.

Confidential

Sr. Business Data Analyst

Responsibilities:

• Acted as a liaison between IT department and the business client for collection, analysis, review, documentation, and communication of business needs and requirements.
• Interact with SME’s and prepare the metadata for future reference.
• In-depth interaction with SME’s from various business units for requirement gathering, managing Change Control Process, updating existing use case specification
• Worked on business requirements involving Corporate General Ledger Reconciliation involving Financial Strategic Reporting departments.
• Prepared Logical Data Models that contain a set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements.
• Extract large datasets from Teradata using utilities like fastexport, BTEQ and Load into Verticas
• Extensively worked on the ETL mappings , analysis and documentation of OLAP and OLTP reports requirements.
• Developed BTEQ scripts to extract data from the detail tables.
• Written  complex SQL queries  for validating the data against different kinds of reports.
• Worked on design to normalizing the tables for simplification of the Data Model.
• created class diagrams ,Data mapping, logical data modeling, and ER diagrams and used SQL queries to filter data within the Oracle database
• Build a python wrapper to handle the ETL load in Teradata.
• Worked in importing and cleansing of data from various sources like Teradata, Oracle, flat files, SQL Server with high volume data,
• Worked with Excel Pivot tables.
• Helped implement Source-to-target mapping (STM) to migrate existing historical data from legacy system to new schema.
• Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Perl, Toad, MS Access, Excel and SQL
• Create regular reports for the stakeholders and SME’s - Project Schedule reports, Revenue forecasting report and ad-hoc query using Tableau.
• Wrote python script for alerting and sending out an email.
• Verified and got approval for final requirement specifications for correctness, completeness, unambiguousness, consistency and traceability
• Worked closely with the project team in planning, coordinating and implemented QA methodology on various phases of UAT.
• Provided post-production support during the Go-live phase of the project and working on production issues.
• Provided assistance and training to the technical support staff and end users for any problems in running the application, errors and questions with the application.

Confidential

Business Data Analyst

Responsibilities:

• Prepared Business Requirement Documents (BRD’s) based on the Client requirement meetings and extracted Functional requirements.
• Conducted Gap analysis (the as-is and to-be scenarios) and documented inconsistencies that came during Project
• Being at onshore I was involved in interaction with client, understanding there issues and single handily resolve all the issues and given adhoc reports and automate also using UNIX and SQL.
• Attending audit meetings with project leader and higher management people.
• Writing scripts and automating the support activities to reduce man power (tools: Unix, Shell/Perl scripts)
• Performing backend testing for the databases and applications
• created class diagrams, Data mapping, logical data modeling, and ER diagrams and used SQL queries to filter data within database
• Wrote SQL queries and validated back end data used by Edge for storing and retrieving data for Data Analysis.
• Conducted JAD sessions for Requirement analysis and Risk analysis studies with the developers, QAs, and the management staff to identify business critical and high-risk areas of the application
• Using the UML techniques, created use case Process flows, Activity Diagrams to illustrate different scenarios for the requirements and interacted with the development team to impart knowledge of the new requirements
• Supported development and QA post requirements phase for question and concerns.
• Developed test Environment Application for testing swap trade booking and maintain test data by overnight autosys batch job.
• Frequently used Teradata Utilities such as BTEQ, Fastload and Multiload accordingly to load small and large amounts of the data into the tables
• Wrote python scripts which sends out an email with the load stats to the reporting team.
• Wrote a shell script to manage the batch process load.
• Involved in UAT, data validation, User training, change and defect management.
• Actively involved in User Acceptance Testing along with end users and Business.
• Excellent experience of Application production support to trade settlement.

Confidential

System Data Analyst

Responsibilities:

• Working on numerous small enhancements programming project.
• The solution designing, implementing and developing for the client requirements using UNIX and Perl script.
• Implement the unit testing for the application.
• Creation and maintenance of SQL, PL-SQL scripts, functions, procedures.  
• Developed and maintained project related relevant documents.
• Acted as a liaison between the project group and the operations group.
• Helped design scope document and to coordinate with top management for the approval process.
• Interviewed various personnel including broker dealers and traders to understand the current process and the future requirements.
• Responsible for physical/logical data modeling; metadata documentation; user documentation; and production specs.
• Manage Scope and change throughout the SDLC process of the product.
• Led the design team in implementing Unified Modeling Language (UML) methodologies to design Use Case Diagrams, Data Flow Diagrams and Activity Diagrams.
• Prepared Use Case Models, Domain Models, System Mapping, and Source-Target Data Mapping.
• Developed Business rules for the equity trading system based on technical chart analysis and fundamental analysis and trends.
• Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
• Used rational Rose to create use cases for different scenarios and cases.
• Developed Business specification diagram so as to understand the whole work flow.
• Created UI Specifications and wire frames.
• Developed activity diagrams in Rational Rose software, so as to have a diagrammatic view of the workflow.
• Collaborated with the QA team for developing scenarios for validation and testing.
• Participate in the analysis, requirements gathering, design, development (coding), testing, and implementation of solutions.
• Got involved in the User acceptance Testing (UAT) and SIT and documented the test scenarios and outcomes.

Confidential

System Data Analyst

Responsibilities:

• Prepared the Functional Specification Document (FSD) and Software Requirement Specifications (SRS) as per SEI CMM standards.
• Conducted the JAD Sessions with stakeholders and developers to have a clear picture of a project.
• Implemented RUP (Rational Unified Process) methodology for iterative and incremental development of the system.
• Wrote SQL scripts for creating performance evaluation reports.
• Developed test cases and test plans on the basis of requirements and also did manual testing of the functionality of the application to ensure that the application is able to handle a lot of data.
• Used UML to create use case diagrams, sequence diagrams and activity diagrams.
• Performed Backend testing by using PL/SQL queries to test the integrity of the application.
• Developed flowchart and process diagram using MS Visio.
• Conducted interviews with clients to analyze their data and gather requirements.
• Wrote python scripts to automate the load and the job failure alerting.
• Clarified QA team issues and reviewed test plans and test scripts developed by development team and QA team to make sure all requirements have been covered in scripts and tested properly.
• Was in regular contact with Business partners on the status of issues, action plans and timeframe for resolution throughout the development cycle.
• Identified bugs during the test phase and reported them using HP Quality Center.
• Maintained Traceability Matrix throughout the project.
• Used the Rational Unified Process (RUP) to build the different phases of Software Development Life Cycle (SDLC).