Lalitha Sekar
Irving
Summary
Dynamic professional with significant experience in leading cross-functional teams and ensuring timely project execution. In-depth knowledge of web technologies and frameworks, paired with a robust background in Business Intelligence. Adept at analyzing data trends and producing comprehensive reports for strategic insights. Proven capability to work collaboratively across teams to drive process enhancements that optimize operational efficiency.
Overview
13
13
years of professional experience
Work History
Senior Software Engineer– PostgreSQL /Tableau Senior Developer
Uniphore Software systems
Chennai
01.2021 - 07.2023
- Creating Sql and Plsql codes based on the requirement.
- Optimizing the Existing plsql Queries to improve performance.
- Providing estimates, Sla for the task assigned
- Creating and maintaining tableau dashboards.
- Involved in integrating tableau dashboard to API.
- Involved in tableau admin works to achieve SSO.
Senior Associate – Sap Analytics Cloud Developer
Ernst & Young GDS
Chennai
03.2019 - 07.2019
- I hold the responsibility in helping customers to resolve challenges and solutions with analytical and planning visualization using Sap Analytics Cloud.
- Created Live and imported data models
- Performed requirement gathering for Model, Story and Dashboard Development
- Performed Planning and Allocation
- Created different types of dashboards like Geo maps, Heat map, Bubble chart, Pie chart
- Created variances and threshold in the dashboard.
- Created Digital Boardrooms and templated in SAC
- Created Page level and story filters to filter data based on user requirement
- Worked with application team to integrate SAC dashboards with in the application
- Created Unit test Cases and Perform Unit testing
- Payroll under (Final search pvt ltd, Bengaluru)
Associate Projects – Business Objects / Tableau developer
Cognizant Technology Solutions
Chennai
09.2012 - 02.2019
- Understanding the requirements and functionality of the application from specifications.
- Consistently attended meetings with client and subject matter experts to acquire functional requirements.
- Designed, Developed, tested and maintained Tableau Functional reports based on user requirement.
- Created worksheets and Dashboards using Tableau.
- Created design rich reports and deploy graphical visualizations with drill down and drop down menu options.
- Converted existing Bo reports to tableau dashboards.
- Developed Tableau visualizations using cross tabs, Heat maps, Scatter plots, Pie charts, Bar charts and Density Charts.
- Hands on building Groups, Hierarchies, set to create detail level summary reports and dashboards.
- Utilized Tableau server to publish share the reports with business users.
- Distributed Tableau reports using techniques like Packaged workbook, Pdf to different user groups.
- Prepared test cases for unit testing to validate data, Performance and design structure of the reports.
- Client: Hartford Insurance
Associate Projects – Business Objects / Crystal Report Senior Developer
Cognizant Technology Solutions
Chennai
09.2012 - 02.2019
- Use JIRA Tool for tracking/open Incidents and work on them on priority and timely delivery
- Use Database Expert, Group Expert, Select Expert, Section Expert to create different Crystal reports
- Use Section Expert with conditional formatting to create hide/ Suppress in summary report.
- Developed standard, cross-tab, On Demand and Drill-down Reports using Crystal Reports.
- Used features such as functions, running totals and parameters, conditional formats to develop highly formatted Crystal Reports.
- Create Hierarchy groups with Group Expert and Group Selection Formulas in Crystal Reports Use Conditional Formatting, Format Painter, Report Alerts and Suppress features of Crystal Reports to format the report
- Designed Complex reports using sub reports, manual cross tabs using Crystal syntax with extensive usage of Local, Global, and Shared variables at report formulas.
- Involved in Writing Sql Queries on Oracle database.
- Developed reports using Complex SQL queries (Add Command), Stored procedures and using Tables.
- Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data to be displayed on the report.
- Worked extensively with the major functionality of BO like Breaks, sections, Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.
- Exported reports into XL, PDF, CSV and XML formats as per the client requirement.
- Published and scheduled Business Objects Reports to users using broadcast agent to run the reports automatically.
- Client: Blue shield of California
Programmer Analyst, Business Objects / Crystal Report Developer
Cognizant Technology Solutions
Chennai
09.2012 - 02.2019
- Gathering requirements from users and designing reports as per the business requirements.
- Performed Unit testing, System testing and user acceptance testing for universe, Reports and security Management
- Developed Universe and Report use documentation guide for the future end end user reference.
- Analyzed existing Actuate reports for migration to crystal report.
- Create Hierarchy groups with Group Expert and Group Selection Formulas in Crystal Reports Use Conditional Formatting, Format Painter, Report Alerts and Suppress features of Crystal Reports to format the report
- Created Sub-Reports (Unlinked / Linked, In-place / On-Demand) with Shared Variables between the main report and the Sub-report in Crystal Reports.
- Extensively worked with Business View Manager for developing Business Views, dynamic Cascading Prompts
- Involved in Data Modeling and Oracle Database
- Applied row level and object level securities on different groups and users.
- Improved the performance and reduced the coding with the use of @functions (@aggregate aware, @select, @prompt, @where).
- Defined Alias and Contexts to resolve loops and also tested them to ensure that correct results are retrieved.
- Performed integrity testing of the Universes (Universe Structure checking, Object parsing, Joins parsing, Conditions parsing, Cardinalities checking, Loops checking and Contexts checking) after any modifications to them in terms of structure, classes, and objects.
- Involved in performance tuning and optimization on Business Objects Universes by creating Aggregate tables.
- Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
- Updated and maintained existing Universes based on changing user requirements and based on changes in data source.
- Worked extensively with the major functionality of BO like Breaks, sections, Group values, Sorts, List of values (LOV), Pre-defined conditions, Calculations and Ranking.
- Exported reports into XL, PDF, CSV and XML formats as per the client requirement.
- Used CMC (Central Management Console) to manage the universes, users/groups, reports and Security model to objects
- Proposed and implemented the Windows Active Directory (AD) security model for the new environment by creating Bridge Table to act as the security look-up table in order to implement the row-level security. Incorporated the 'BOUSER' variable is into the security logic from the Business Objects Environment.
- Provided training to analysts, crystal report writers, users about the Business Objects Environment (Universe development, CMC WebI, InfoView) to get them up to speed using the new reporting system.
- Publication Jobs are created to run the crystal Reports based on the trigger event.
- Published and scheduled Business Objects Reports to users using broadcast agent to run the reports automatically.
- Client: Anthem Healthcare Insurance
Software Engineer, Business Objects/Talend Developer
Wipro Technology
Chennai
06.2011 - 08.2012
- Worked with Data Mapping Team to understand the source to target mapping rules.
- Analyzed the requirements and framed the business logic for the ETL process using Talend.
- Involved in the ETL design and its documentation.
- Developed Jobs in Talend Enterprise edition from stage to source , intermediate, conversion and Target
- Worked on Talend ETL to load data from various sources to Oracle DB. Used tmap, treplicate, tfilterrow, tsort and various other features in Talend.
- Worked on Talend ETL and used features such as Context variables, Database components like tMSSQLInput, tOracleOutput, file components, ELT components etc.
- Followed the organization defined Naming conventions for naming the Flat file structure, Talend Jobs and daily batches for executing the Talend Jobs.
- Worked on Context variables and defined contexts for database connections, file paths for easily migrating to different environments in a project.
- Implemented Error handling in Talend to validate the data Integrity and data completeness for the data from the Flat File
- Used Talend components such as tmap, tFileExist, tFileCompare, tELTAggregate, tOracleInput, tOracleOutput etc.
- Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Talend Integration Suite.
- Created various User defined objects including Dimensional, Detail, and Measure objects and tested them to ensure correct mapping of data in Bo universe.
- Improved the performance and reduced the coding with the use of @functions (@aggregate aware, @select, @prompt, @where).
- Resolved Chasm, Fan traps and Loop problems.
- Defined Alias and Contexts to resolve loops and also tested them to ensure that correct results are retrieved in Bo universe.
- Performed integrity testing of the Universes (Universe Structure checking, Object parsing, Joins parsing, Conditions parsing, Cardinalities checking, Loops checking and Contexts checking) after any modifications to them in terms of structure, classes, and objects.
- Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data to be displayed on the report.
- Published and scheduled Business Objects Reports to users using broadcast agent to run the reports automatically.
- Performed unit testing, system testing and user acceptance test (UAT) for universe and reports.
- Client: Citi group
Contract, Xcelsius Developer
Wipro Technologies
Chennai
06.2010 - 06.2011
- Interacted with Business Users and Business Analyst to gather and document the requirements and translate these to Technical Specification for designing dashboard reports.
- Created graphical representation of reports such as Bar charts, Pie charts, Column chart, Line chart, Bubble chart using Xcelsius 2008.
- Created Xcelsius components like charts, menus and containers
- Used Flash variables and Fs command to pass parameter values.
- Integrated the Xcelsius Report with java application.
- Created complex drill down reports and alerters to indicate the criticality of the target met for each agent.
- Dynamic Visibility is set to control when the chart is visible based on the condition.
- Created Report use documentation guide for the future and end user reference.
- Involved in Unit testing, User acceptance testing and system testing.
- Client: Allstate Insurance
Education
M.C.A -
Periyar Maniammai college of technology for women
Thanjavur01.2009
B.Sc. - Computer science
Seethalakshmi Ramaswami college of arts and science
Trichy01.2006
Skills
- BI tools: Business Objects, Tableau
- Reporting tools: Crystal Reports, Xcelsius
- Data integration: ETL, Talend
- Database technologies: Oracle, SQL Server, PostgreSQL
- Scripting languages: Bash, Control M
Experience Summary
- 13+ years of IT experience in Data Warehousing Domain have extensive work experience on Business Intelligence tools such as Business Objects, Crystal report, Tableau ,SAP Analytics Cloud, Xcelsius Talend, PostgreSQL.
- Experienced in Data Modeling, Star/ Snowflake schema modeling, Fact and Dimension Tables, Physical and Logical data modeling using Microsoft Visio.
- Interaction with BA team to get the requirements for the request received.
- In depth knowledge of designing Entity Relationship and Data Flow Diagram for Business processes. Strong understanding of data modeling and dimensional modeling concepts like Slowly Changing Dimensions.
- Sound Experience in designing, development and deployment of complex Universes.
- Experience in creating Universes with measures and dimensions objects, Join conditions, Filters, LOV, Cardinality, Aliases, Contexts, and Aggregate Awareness using Business Objects Designer.
- Worked on of new features of Business Objects XI including Index awareness, Derived tables and Central Management Console(CMC)
- Performance Tuning and Optimization of BO reports at all levels.
- Worked with Crystal Reports 2008 for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports and data reports.
- Expert in generating Sub Reports, Standard, Mailing Labels, Cross Tab Reports and Graph Reports by using Chart expert of Crystal Reports.
- Worked extensively on various Business Objects functionalities like Queries, Slice and Dice, Cross Tab, Breaks, Alerts, Filters, Sorts, Ranking, Prompts, and Calculations.
- Technical proficiency in creating interactive dashboard and scorecards using Xcelsius
- Used Live Office and QaaWS (Query as a Web Service) to feed live data into Xcelsius 2008 to show product portfolio.
- Worked with various components of Tableau 8.0. Created Workbook and Dashboards using Tableau
- Hands on Experience on many components which are there in the palette to design Jobs & used Context Variables to Parameterize Talend Jobs
- Extensive experience in using Talend features such as context variables, triggers, connectors for Database and flat files.
- Created complex mappings in Talend using components like: tMap, tJoin, tReplicate, tParallelize, tAggregateRow, tDie, tUnique, tFlowTolerate, tSort, tFilterRow, tWarn, tbuffer, tcontextload.
- Experience in development methodologies like Agile and RUP
- Strong written and oral communication skills, self-motivation, creativity and ability to adapt to new technologies and applications.
Languages
Tamil
First Language
English
Proficient (C2)
C2
Timeline
Senior Software Engineer– PostgreSQL /Tableau Senior Developer
Uniphore Software systems
01.2021 - 07.2023
Senior Associate – Sap Analytics Cloud Developer
Ernst & Young GDS
03.2019 - 07.2019
Associate Projects – Business Objects / Tableau developer
Cognizant Technology Solutions
09.2012 - 02.2019
Associate Projects – Business Objects / Crystal Report Senior Developer
Cognizant Technology Solutions
09.2012 - 02.2019
Programmer Analyst, Business Objects / Crystal Report Developer
Cognizant Technology Solutions
09.2012 - 02.2019
Software Engineer, Business Objects/Talend Developer
Wipro Technology
06.2011 - 08.2012
Contract, Xcelsius Developer
Wipro Technologies
06.2010 - 06.2011
M.C.A -
Periyar Maniammai college of technology for women
B.Sc. - Computer science
Seethalakshmi Ramaswami college of arts and science
Similar Profiles
Mercy ChristinaMercy Christina
Senior Co-Ordinator Workplace Experience at Uniphore Software Systems Private Limited, ChennaiSenior Co-Ordinator Workplace Experience at Uniphore Software Systems Private Limited, Chennai
Jitin RajJitin Raj
Senior Sales Engineer at Uniphore Software Systems Private LimitedSenior Sales Engineer at Uniphore Software Systems Private Limited
Viswanathan RViswanathan R
Lead Workplace Experience Cordinator at Uniphore Software Systems Pvt LtdLead Workplace Experience Cordinator at Uniphore Software Systems Pvt Ltd
Stephen FragaStephen Fraga
Maintenance Technician 2 at CARVANAMaintenance Technician 2 at CARVANA
Gabriella MandujanoGabriella Mandujano
Customer Solutions Specialist at Portfolio Recovery AssociatesCustomer Solutions Specialist at Portfolio Recovery Associates