SUMMARY:

• I am a highly motivated and disciplined professional with a knack for business analysis. I always enjoy learning about market trends and how they translate into businesses. My accomplished background in the field and firsthand experience in data warehousing, data workflows and financial systems are rooted in my innate desire to keep learning, and my ongoing experiences are nourished by my inquisitive nature. I have lived and worked in two different countries and three different cities in the last 7 years, so I am adept at promptly acclimating myself with a myriad of situations. I also possess strong Analytical skills, functional knowledge in financial industry and E - commerce, excellent communication skills - both verbal and written - and I am proficient in articulating views and ideas to and from the technical teams, business teams and internal and external stakeholders.
• Requirement Gathering
• Business Requirement Documentation (BRD)
• Orcale SQL Developer
• Visio
• AGILE - Sprint, Scrum
• Atlassian - Confluence & JIRA
• Tableau
• PowerBI
• Data Modeling, Analysis, Workflow
• Ms Office Suite (Excel, Word, PPT, Outlook)
• Python
• XML/JSON
• Jupyter, Pycharm, Spyder
• Anaconda
• Rally (DevOps)
• Financial Products, Instruments, NAV

PROFESSIONAL EXPERIENCE:

Confidential

Business Analyst

Responsibilities:

• Incorporated high level implementation plans, data and process models, cost estimating, cost benefits analysis, return on investments and revenue
• Supported Client's Customer Investment Database(CID) that aimed to increase safety and efficiency of various retirement plans and plan sponsors, retirement fund, reduce cost overheads and preparing a robust system by future proofing the database
• Designing, outlining, implementing design of the IT process and workflow of CID to support the enhancement of CID on premise to CID AWS migration
• Design, document and perform sanity checks for current and future CID system consisting of complex SQL tables, views and reports using Oracle SQL developer, Power BI and in-house CID application in Systest
• Develop User Stories for DevOps and performing system testing of the implementations Involves writing manual and automated test cases of various reports that are generated by investments group to verify the their legibility and accuracy in the system
• Author complex test SQL queries and developed automated python test modules to perform outgoing Investments XML files to bolster testing between MSQ and SSC
• Coordinate directly with Investment Management teams to define user requirements to solidify future implementations and timelines of the project
• Demonstrate financial knowledge and expertise in business, IT products and consumer product/service recommendations with the members to support multiple services provided to sponsors and participants including various ETF funds, mutual funds and underlying holdings
• Research, analyze and prepare Business Requirement Documents and Technical Requirement Documents pertaining to project requirements, system requirements and scope
• Perform ad hoc analysis using Oracle SQL and Python (Matplotlib, Plotly), Excel (vLookUps, Pivots, VB etc.) and BI tools (PowerBI) and proactively generating reports of emerging trends to optimize business performance and reduce costs.
• Designing Database with database developer by analyzing historical data using SQL and unorganized data in Python (PANDAS, NumPy) to extract, clean and organize for a successful relational database (RDBMS) build.

Confidential, Chicago, IL

Business Analyst

Responsibilities:

• Outlined and summarized end-to-end process flow from a complex technical architecture to provide a high-level holistic view to business end users - achieving 20% reduction in planning and design preparation time
• Responsible for high level implementation plans, data and process models, cost estimating, cost benefits analysis, and return on investments
• Responsible for supporting Securities Settlement Discipline that aimed to increase safety and efficiency of securities settlement, reduce settlement trade fails in the EU affecting multiple business units such as Custody funding, Securities Lending, Brokerage, Investment Operations Outsourcing, Equity, Hedge Fund Services
• Research, analyze and prepare BRDs and TRDs pertaining to project requirements, system requirements and scope
• Spearheaded detailed gap analysis and defect management based on strategic implementation of the Penalty tool to ensure optimum delivery to outbound systems from Target Operating Model’s perspective
• Operated all project-based tasks through AGILE Methodology - Bi-Weekly Sprints, daily Scrums (JIRA) - performing requirement analysis updates and writing Epics, User Stories, and supported UAT processes
• Qualified the migrated data and the validity of the migration processes and operation. Reduced the discrepancy by 90% overall.
• Streamline overall communication to help optimize and speed up the design process by analyzing business data needs and wrote supporting documents to close the gap between Business and IT teams
• Maintain key performance metrics, operational metrics, and gap analyses for different Business Areas. Helped anticipate future strategic or tactical changes needed
• Perform ad hoc analysis using Python (Matplotlib, Plotly), Excel (vLookUps, Pivots etc) and BI tools (PowerBI) and proactively generating reports of emerging trends to optimize business performance and reduce costs
• Designing Database with database developer by analyzing historical data using SQL and unorganized data in Python (PANDAS, NumPy) to extract, clean and organize for a successful relational database (RDBMS) build
• Loading thousands of SWIFT messages from different markets and applications. Transforming them into JSON schema for data analysis through Spyder (Python IDEs) - automating the manual process for faster delivery
• Ensuring data integrity for multiple inbound data streams (i.e., Static Data, Failing Transactions, etc.) into the cash penalty system by assisting data modeling team in refining the canonical model
• Defined and restructured inbound data flow for certain applications that are limited due to their reliance on other vended applications for penalty statuses & failing reasons and help streamline process for optimized system integration

Confidential, Chicago, IL

Application Programmer/Data Consultant

Responsibilities:

• Data Quality analysis lead responsible for defining and documenting data transformation requirements and performing data quality analysis based on overall project data quality rules and standards
• Monitored progress and issues tracking, prepared trend analysis and created reports to support investigations and solve critical incidents
• Managed defects in Global Trades data quality between upstream & downstream systems by investigating root cause
• Facilitating audit and compliance documentation along with regular and ad-hoc quarterly reports for optimum audit process
• Liaison between business SMEs and developers to ensure requested requirements and changes are documented and accurately integrated into data releases for each client
• Researched, designed, and formulated “fit for use” data quality rules for multiple compliances, IMM, QFC, and Collateral to ensure dev teams and compliance teams are concordant in terms of rules.
• Guided and documented the implementation of systems-based rules to maintain data integrity and security across varied data hosting and data housing platforms
• Collaborated with dev teams, support teams and compliance teams to unify technology, business and finance information and provide technical support to end user
• Reviewed, analyzed, and evaluated clients’ requirements and led audit Quartz compliances projects - IMM, QFC - to successful implementation
• Performed daily, monthly, and quarterly analyses and reconciliation based on control procedures
• Maintained key performance metrics, operational metrics, and executed gap analyses for different business areas
• Critically evaluate data gathered from varied sources, reconcile conflicts, decompose high-level information into workflow documents and development artifacts
• Engineered detailed trend analysis insights for end users and delivered through Tableau dashboard based on new and existing Operational & Financial risk KPIs
• Performed risk assessments (Risk Weighted Assets for IMM), and establish, implement, and document audit compliance control procedures
• Developed Python programs that queried and manipulated SQL databases essentially supporting overall project implementation and report generation. Helped reduce the overall manual process by 70%

Confidential

Data Warehouse Consultant

Responsibilities:

• Software Development Lifecycle (agile methodologies) from requirements gathering, analysis, design, construction, QA, user testing
• Employ appropriate methods to motivate, organize, facilitate, and administer the project team
• Understanding the client business operations, data and processes and regressive documentation of requirements
• Conducted a qualitative and quantitative research on restaurant industry, compared and analyzed financial ratios and performance metrics of key players, and drafted a report
• Developed reports to meet business requirements including building queries, single/ multi-reports, and batch reports using PowerBI and Tableau
• Built a predictive model in Tableau for hourly workforce based on historical data. The model is used by the clients’ finance and HR teams to plan for new hires and operations managers to schedule optimal number of employees each day
• Using Python (PANDAS, NumPy) to effectively work with huge data from numerous connections to automate and build comprehensive patterns for existing processes of data mining, manipulation, cleansing, and migration
• Developing dashboards and trend reports based on the results in Microsoft PowerBI and Tableau for internal and external projects
• Led and managed project delivery, including milestones and reported progress toward delivery goals throughout project
• Interacted with users to collect report specifications, using information to design and deliver relevant reports on a daily, monthly, annually, or on ad-hoc basis.
• Created workflow and data flow documents for multiple stages and harmonizing data needed at several stages of development using mappings and cleansing techniques.
• Strong understanding pivot table, slicer using Excel and PowerPoint to streamline reporting process.
• Proficient use of research methodologies and prepare details & summary level reports with written interpretation of analytical results
• Gained clients’ recognition by project on-time delivery and exemplary presentations and memorable functional visualizations
• Developing ETL processes and purging, modification, and normalization to maintain client’s data.
• Streamlined effective data integrity for various stakeholders; internal and external