Sign in

Developer Support

Los Angeles, California, United States
August 29, 2017

Contact this candidate


Satarupa (Simi) Mahapatra

**** ***** ******, ********, **,91306 +1-805-***-**** CAREER OBJECTIVE

Seeking a technical position in a challenging environment to provide effective knowledge and technical skills for successful completion of organizational objectives.


• Programming/Scripting languages: Java, J2EE, SQL, Oracle, Shell scripting, XML, JavaScript,HTML,C,C++

• Specialized Tools: MicroStrategy – Desktop, Web, Mobile, Visual Insight, Tomcat, Cognos tool - Report Studio

• Methodologies: Waterfall, Agile, Scrum,OOP,MVC design

• Productivity Tools: SQL Developer, SQL Server Management Studio, SQL Server, MS Access, Eclipse, Remedy, Control-M, JIRA, Microsoft Office, Clearcase,GitHub

• Environments: UNIX, Windows


• MicroStrategy Certified Developer V9.4.1

• MicroStrategy Certified Project Designer V9.4.1

• MicroStrategy Certified Report Developer V9.4.1

• MicroStrategy Certified Document and Dashboard Designer V9.4.1

• Oracle Certified Java Programmer

• Oracle 11g SQL Certification

• ITIL - Information Technology Infrastructure Library Certification

• NCFM Certifications on Financial Markets, Equity Derivatives, and Interest Rates EXPERIENCE


Sr. BI Developer

Project: Self-servicing BI Bombardier Inc.

Technical Skills: MicroStrategy, SQL,Javascript

Bhubaneswar, India

Jan 2015 To May 2015

Develop a centralized self-servicing BI tool to track work performed at the manufacturing floor of Bombardier, a Canada-based multinational aerospace and transportation company. The architecture involved a MicroStrategy BI layer on a central data reservoir sourcing data from SAP, NCMS and FlexNet systems.

• Led calls with the Canada- and US-based business teams to refine requirements on enhancement requests on the existing dashboard.

• Architected the BI solution based on MicroStrategy architecture with intelligent cubes, including hierarchies, facts, attributes, metrics, filters, and prompts. Designed templates with grid and graphical layouts.

• Built interactive and ad-hoc Reporting where in the reports can act as a search engine to retrieve the required data.

• Coordinated reviews with BI and Data Architects for data mapping, integration and data security for role-/site-based access.

• Gathered new requirements for building nine reports from scratch.

• Trained teammate on MicroStrategy and helped her ramp up on building new reports.

• Prepared and updated SOWs to capture changes in requirements and scopes. BI Developer

Project: BI Platform Limited Brands

Technical Skills: MicroStrategy, SQL,Javascript, JQL Bhubaneswar, India

Aug 2014 To Dec 2014

Develop a customer analysis and financial reporting BI platform on MicroStrategy for Limited Brands, an American fashion retailer.

• Interviewed US-based business groups for gathering requirements. Analyzed requirements for implementing MicroStrategy reports.

• Implemented MicroStrategy reports by creating Attributes, Facts, Attribute Relationships, Conditional, Transformation, Dimensional and Compound Metrics, Filters, Filter Prompts, Object Prompts ICubes.

• Created complex reports for analysis with Custom Groups, Consolidations and complex Filters & Prompts.

• Used MicroStrategy Mobile to develop customized business dashboards on iPhone and iPad for senior management.

• Developed an Intelligent Cube for Visual Insight (VI) and provided training to Business users, analysts and managers on VI.

• Worked closely with the System Testers for functional testing of the reports and dashboards to make sure that the data being reflected in the reports match with the expected data.

• Implemented optimization techniques to achieve improved performance. BI Developer

Project: Customer Insight TCS Internal POC

Technical Skills: Cognos Report Studio 10

Bhubaneswar, India

Mar 2014 To Jul 2014

• Prepared functional requirement and design document for report development.

• Write Cognos report by using Cognos reporting tools.

• Worked on Data Modeling and Data Warehousing using multidimensional, star and snowflake schemas.

• Incorporate data from several databases into one report.

• Created simple and advanced list reports, added data formatting, grouping and sorting features and added page breaks.

• Created reports with drill up/down, drill through reports, cross-tab and list reports, parametrized filters and adding features like query driven value prompts.

• Provide support to the reporting team and perform other duties as assigned. Systems Engineer

Project: Synapse Application Support for LME & NLX London Clearing House Ltd. Technical Skills: Java, J2EE, JMS, SQL

Bangalore, India - Jan 2014 To Feb 2014

London, UK – Apr 2013 To Dec 2013

Bangalore, India - Jan 2013 To Apr 2013

Provide application support for Synapse – a J2EE-based clearing platform in the TCS-owned banking application suite (BaNCS), for London Clearing House (LCH). LCH’s Synapse platform has several interfaces: A web based GUI, A FIXML post-trade feed, End of day reports. London Metal Exchange (LME) and NASDAQ were two major users of this platform.

• Represented the Synapse support team at client location in preparation for its go-live for NLX on 31st May, 2013. Coordinated with 14 internal teams and 3 client teams to ensure reliable & effective application services.

• Acted as the primary liaison in the business meetings and requirements refining with the London, Sweden and Canada offices of LME & NLX. Preparing weekly status reports, documents for support and knowledge base.

• Provided planning support for the pre-launch, launch and post-launch technical activities in concert with NLX.

• Partnered with QA team on a multi-faceted testing on functionality, integration, regression, load and performance to certify the platform supporting 100K simultaneous trades.

• Liaised with LME to implement the EMIR updates at their end and track progress.

• Identified infrastructure requirements, prepared end-user test cases, and led dress rehearsals with production-like simulations.

• Optimized several processes and ramped up the offshore team to support LME and NLX in parallel.

• Spearheaded successful European Market Infrastructure Regulation (EMIR) migration for 52 members within four months.

• Represented LCH in supporting their platform for LME and NASDAQ.

• Triaged issues, analyzed root cause and effectively resolved issues in production processes. Managed delivery timelines.

• Automated parsing of custom formatted PC Bridge trace logs using UNIX scripts.

• Received appreciation for showing initiative and going beyond assigned responsibilities to help team members and meet deadline.

• Mentored and reviewed deliverables from new team member. Asst. Systems Engineer

Project: Synapse Application Support for LME London Clearing House Ltd. Technical Skills: Java, J2EE, JMS, SQL

Bangalore, India

Apr 2011 To Jan 2013

Provide application support for Synapse – a J2EE-based clearing platform for London Metal exchange and NASDAQ.

• Owned the support for the entire application, including its high-velocity clearing module.

• Understood the business of LCH and translated it into Synapse’s modules and its upstream and downstream interfaces.

• Wrote DB scripts to validate pending trades and closing prices for all instruments in the system for early-determination of job failures to ensure a smooth EOD job execution and avoid next-day system downtime.

• Owned production quality and recovery procedures. Released 11 upgrades and 5 hot fixes.

• Develop test applications to assist in monitoring and testing of Java-based application servers.

• Handled disaster recovery during server migration. Developed and deployed hot fixes.

• End-to-end monitoring of servers – monitored application health, executed SQL queries, reviewed application logs, batch logs, configuration files and UNIX logs, reviewed & modified batch (Shell) scripts to patch Control-M.

• Identified and implemented workarounds to help deprioritize critical issues per the SLA.

• Supported customer queries on use cases and business logic.

• Managed logging, triaging and tracking of issues.

• Received appreciation for adhering to strict deadlines of the high-stake, zero-tolerance project. Trainee

Technical Skills: Java, J2EE

Guwahati, India

Jan 2011 To Mar 2011

Training on proprietary applications, internal processes and soft skills for client interaction. AWARDS AND ACCOLADES

• Best support team among a dozen teams for two consecutive years.

• TCS Gems – on-the-spot award for disaster recovery – Q4 2011

• Client appreciation emails from senior management (COO, CIO & Director of Listed derivatives LCH.Clearnet). EDUCATION


• Major: Electronics and Communication 8.27 CGPA


• Work Authorization: Have work authorization document (EAD). No need for sponsorship.

• Interests: Singing, Cooking

Contact this candidate