SUNITA DATTA

Chicago, Illinois ***** • 347-***-**** • ad0wra@r.postjobfree.com • www.linkedin.com/in/dattasunita

SUMMARY

A highly proficient and innovative data solutions architect with multifaceted experience in feature development, requirements gathering, project management, Agile methodologies, SDLC, data visualization, SQL server integration services, and strategic planning. Demonstrates established capabilities in designing and delivering enterprise-level data solutions, including data modeling, data warehousing, and advanced analytics using Microsoft Azure stack. Leverages exemplary leadership, technical and communication skills to foster continuous integration and ensure successful deployment of data projects, while perpetually redefining expectations.

TECHNICAL SKILLS

Cloud Platform: Azure

CI/CD Tools: Azure Pipelines

Databases/ Data Storage: Data Lake, Oracle Database 11g, Oracle Database 10g on RAC and EXADATA, DB2, Sybase 12.5, Postgres, Microsoft SQL Server 2012

Oracle Internet Application Server OAS- 4.x

MS-Windows, UNIX (Sun SPARC Solaris Server, HP 9000 Series

PL/SQL, SQL, T-SQL, Shell scripts, Perl, PySpark, Python

JAVA, JSP, JDBC, HTML/DHTML, XML, JavaScript

ERWIN Model mart, Visio, Rational Rose, Dream weaver

Quest TOAD, SQL Navigator, CRM Package Software

TKPROF, AWR, ASH, Quest SQL optimizer, performance analysis tool.

Informatica ETL Tool

SSMS (11.0.2), SSIS, MS visual studio

Tableau, Power BI, SAP Business objects BI suite, Incorta Data analytics tool

EXPERIENCE

LSC COMMUNICATIONS, Chicago, IL

Senior Solution Architect, June 2016- August 2023

Performed enterprise data modeling and data analytics design and development utilizing Microsoft Azure stack. Developed data model and data warehouse solution. Designed and led delivery of solutions to data challenges and provided feedback on others’ work. Managed entire product line lifecycle from strategic planning to tactical activities. Drove discovery, design, and execution of wide variety of data solutions for business user groups. Developed flexible, coherent, and reliable enterprise data architecture approach to support business growth and change. Led database architecture and design of enterprise data warehouse platform with BI analytics, reporting, and data visualization. Created and owned roadmap for enterprise data platforms for advanced analytics.

Established guidelines for building high-performance abstraction database layer to facilitate creation of high-performing visualization dashboards. Owned and maintained enterprise data standards, best practices, security policies, and data governance processes. Collaborated with engineering teams, identifying multiple approaches to complex problems, and finding innovative solutions to capture maximum business value. Communicated with upper management, UX design, development, and testing teams on product roadmap and project status. Collaborated closely with business stakeholders and team of engineers and thought leaders to design, build, and implement next-generation solutions in advanced analytics, BI, and cloud.

Define and manage the enterprise data warehouse architecture standards. Set best practices in database design and analytics development processes; setup code reviews & technical design sessions, writing and reviewing technical design specifications.

Lead Business intelligence team to gain operational efficiencies, to improve customer experience and meet challenging business and market requirements by deploying series of projects and supporting applications from in-house BI application to cloud adoption model thereby reducing operational cost by 20%.

As an SME provide expertise to the business in identifying Key Performance Indicators and defining reports and dashboards that align with requirement metrics to the executive leadership team.

Successfully designed and implemented integration of multiple siloed systems such as Sales system, manufacturing – press and bind system, paper, logistics and built a robust one place shop platform for C-level executives and finance team and provided end to end comprehensive order tracking system called customer profitability system. This enabled the outlining of operations and sales from beginning to end, resulting in a substantial increase in profits for the company.

Strategize design and migration of sales and manufacturing DataMart and Business object report solution to Incorta.

Design recommendations and design decisions for migration of legacy data warehouse and business object reporting solution to Azure cloud architecture and power BI reporting solution. Consolidated 8 databases to 4 DBs, thereby saving associated hardware, maintenance cost.

Review RFQ, onboarding vendor companies for the Azure cloud migration project. Proof of concept of Postgres, Power BI as potential migration solution. Prototyping data visualization using power BI reports, Incorta dashboards.

ERWIN mart server installation. Developed, implemented, maintained data models and the database designs to build and maintain enterprise data warehouse. Erwin administration

Data mining, analyzing data to identify pattern, linkage data points, data gaps during the process of initial discovery phases of requirement analysis. Data profiling, source-target analysis.

Collaborated closely with technical and business stakeholders as an SME in gathering requirements, prioritize, design and develop technical business intelligence solutions to automate and streamline business processes. Successfully implemented many projects involving data warehouses, migration, reporting, BI, and data analytics using Oracle, Microsoft SQL Server, DB2, SAP business objects, Power BI, Azure, and Incorta. Acted as expert, liaison, and technical oversight for the Business intelligence technical team.

Implemented processes and controls for QA and testing for data team to facilitate Agile adoption and continuous integration. Provided leadership, set common direction, and mentored team within the group. Training business on using new application solutions and tools.

Skills: Requirements Gathering, Design Solution, Agile Project Management, Application Data Architecture, Feature Development, Data Visualization, Agile Methodologies, Data Analytics, Data mining, DevOps

Tools and Technologies: Azure SQL Database, Azure Synapse Analytics data platform, Data Pipelines, Azure Data Lake, Power BI, DevOps, Oracle, Microsoft SQL Server, Postgres, Informatica, Incorta, Power BI, SAP Business objects, ERWIN, Visio, Jira, PL-SQL, T-SQL, PySpark, Java, Python

RR DONNELLEY, Chicago, IL (Parent company to LSC Communications)

Data Architect – Consultant, Mar 2016 – May 2016

Designed solution to split the sales system into 3 to prepare the spin-off of RR Donnelley splitting into 3 companies. Responsible for analyzing the existing design and devising changes required to do the spilt of the Sales data mart. Instrumental in designing the final model, making the transition from start to end. Offered full time role after the company split was complete at LSC communications one of the spin off company.

MESIROW FINANCIAL, Chicago, IL

Senior Data Architect, Mar 2014 – Dec 2015

Served Advanced Strategies Database Architecture Team, contributing to development and maintenance of system with robust data integration structure. Crafted centralized data warehouse that integrated information from various sources. Developed data dictionary and model encompassing core entities from backend storage of legacy applications - mosaic, pertrac, PMT, and portions of Quant database. Led review sessions for conceptual data model with database architecture manager and CTO. Collaborated with data architecture team to chart out roadmap for constructing data warehouse. Led design of data domains for performance data from legacy database for mosaic application and exposure data from Quant database.

Engaged with vital stakeholders from client reporting team, gathering input and observations, and assessing their reporting inventory. Established priorities based on pain points to streamline report delivery. Initiated milestone of automating performance and exposure data, collaborating with development team to define loading strategies and calculation logic for initial set of reports from data store. Worked closely with PMT application - Frontend analytics development team to outline analytics screen requirements and establish datastore entities to meet their needs. Designed and enhanced MAS - Portfolio management system (PMT), integrated decision support platform for fund management.

Led efforts to define data governance and standardize ETL strategies. Implemented uniform terminology, database entity naming conventions, and error handling features in ETL processes. Documented and shared these standards on team confluence portal. Automated upload/update of cash balances on various accounts linked to different funds, ensuring consistency between accounts and fund classes. Revamped monthly refresh and roll-forward process for Investment history and Surviving Dollars; involved recording investment flows, starting/ending NAV, contributions/withdrawals, adjustments, and up-to-date ROR based on pricing. Performed data analysis and technical database development work for sprints as required.

Collaborated with QA team to validate and test reports and data elements.

Maintained continuous effort to deliver consistent information to support application and user requirements across group.

Provided support to development effort by optimizing SQL statements and eliminating query performance bottlenecks using tools like Explain Plan and SQL Trace; implemented indexing strategies on OLTP database.

Defined and documented mechanisms for data cleansing, validation, business rules, transformation logic, and data integration.

Conducted analysis sessions to assess report catalog, prioritize reports by business importance, and collaborated with reporting team to define data requirements for new streamlined reports.

Fostered functional Agile environment by cultivating collaborative atmosphere within group, facilitating seamless flow of information.

Oracle 11.2.0.2.0, PL/SQL, SQL Developer (3.1.07), ERWIN Data Modeler 8, VISIO 2013, GIT version control, BI analytics with Tableau, SQL server 2012, SSMS (11.0.2), SSIS, MS visual studio, SSRS, PL-SQL, T-SQL

CME GROUP, Chicago, IL

Senior Software Engineer/Architect, Aug 2011 - Mar 2014 - Post Trade Technology (PTT) - Regulatory IT Group

Oracle 11.2.0.3.0, PL/SQL, Quest Toad (11.5), ER/Studio Data Architect 9.1.1, Informatica power center 9.1, UC4 batch job scheduling/automation tool, GIT version control, Unix shell scripting, TKPROF.

Worked within regulatory IT group's compliance team. Led front-door projects, encompassing requirement analysis, defining project objectives, playing pivotal role in project architecture, and documenting detailed software design. Initiated requirement analysis sessions with business analysts and users, maintaining consistent communication with business to measure and meet user expectations. Analyzed and translated business requirements into conceptual, logical, and physical data models in complex, multi-application environments. Created and maintained design documentation, communicated, and reviewed design implementation with team, and created source-target data mapping/data flow deliverables.

Analyzed and interpreted trends/patterns in complex data sets, collaborated with subject matter experts to resolve related functional issues. Participated in Agile scrums, collaborating daily with business users, SMEs, development team, and quality assurance team. Integrated fees and membership data into regulatory system, liaising effectively with multiple teams within organization. Developed complex ETL processes using PL/SQL procedures and packages, and built oracle tables, indexes, views, materialized views, and database triggers. Collaborated with DBA team on partitioning scheme and statistics for optimum performance. Organized and ran periodic project meetings with development team, SMEs, QA team, and business analysts, resolving issues during project lifecycle.

Aligned technical activities with project plans, scope, and timeframes in collaboration with management team. Organized weekly code review meetings within development team, promoting better coding standards. Led backend ETL developer team, mentored junior team members with technical expertise, and interviewed/trained new team members. Developed periodic project goals, organized JIRA stories, prioritized and monitored stories for monthly release cycles. Assisted in QA environment data setup, closely collaborated with QA and business users to resolve issues during QA testing and UAT, ensuring timely and accurate completion of work. Maintained project progress report and encouraged internal team interaction.

Updated DBA team on upcoming database changes and addressed concerns.

Coordinated and managed monthly production release.

Built confluence space, defined data flow mapping of data attributes, aiding impact analysis of upstream changes and serving as useful resource for analysis of new requirements, developers, and quality assurance team.

Identified performance issues, diagnosed I/O memory utilization issues in order load process, and provided resolution measures. Analyzed ETL batch processes and underlying SQLs in production for optimization.

Tuned complex SQL embedded in front-end application, improving response time for business users/regulators.

Provided off-hours production support as level-3 (expert), analyzed and troubleshot production issues related to performance and source data from clearing systems and provided design ideas and technical expertise for other projects.

ADDITIONAL EXPERIENCE

ALLANT GROUP, Warrenville, IL, Solutions Delivery Group - Database Architect – Consultant, 11/2010-7/2011. Participated in Comcast Business services initiative focusing on prospecting and customer marketing database catering to B2B business segment. Contributed to creation of marketing database solutions. Worked closely with business analyst and technical leads to comprehend client requirements and devise solutions. Developed comprehensive process flow specifications, formulated logical data models, generated DDLs, and established database objects such as Partitioned Tables, indexes, and views. Engaged in analyzing source data from client companies, defining database loading techniques, and implementing error handling and archiving strategies.

CHICAGO BOARD OF OPTIONS EXCHANGE (CBOE), Chicago, Illinois, Data Architect, 04/2007-09/2010. Designed and administered multiple oracle databases containing over 500 tables for real-time and batch applications. Created and managed OLTP database supporting applications used by regulatory group and large in-house Oracle Data warehouse with volume over 100 TB and advanced database tuning, including instance-level performance optimization. Designed and developed advanced data models to optimize access within databases. Created logical and physical data models using ERWIN building entity-relationship constraints, creating primary key, non-primary key attributes, and trigger templates and codes. SQL performance tuning utilizing auto trace, explain plan, statspack, AWR and performance analysis tools. Monitoring real-time database performance. Managed technical design reviews by providing technical advice. Designed and maintained multi-level partitioning strategies to build highly optimized databases.

FIDELITY INVESTMENTS, Merrimack, New Hampshire; Boston, Massachusetts Consulting Database Analyst, 10/2005-10/2006. Fixed-Income Division -Designed and developed database systems for Fixed Income Application suite, built on SOA architecture comprising multiple components like event-driven web-services benefiting cross-functional teams, including floor traders. Collaborated with client management to outline intricate business requirements and processes. Explored and assessed alternative solutions and provided suggestions. Devised and built database system for fixed income data environment group named UDE (Unified Data Environment), delivering and distributing data between environments within and outside system, using batch and real-time models employed by floor traders.

Worked on Equity Trade Information Warehouse (ETIW), serving as reporting and distribution vehicle for equity trades, holdings, and broker-related information. Designed and executed summarized trading and commission database module, enhancing performance of analytical reporting for equity trades, holdings, and broker-related information via ETIW Portal. Conducted data analysis by accessing data quality in sample data, identifying data anomalies and distribution, and proposing necessary data transformations. Devised strategies and crafted solutions for recovering missing trade information.

UBS INVESTMENT BANK, Stamford, Connecticut, Senior Database Analyst (Consultant), 10/2004-7/2005. Played key role in growing Fixed Income data repository called CDR. Designed and built large-scale ETL solutions integrating data from multiple sources. Developed components on core database and client access layers. Created numerous object-based back-end PL/SQL database procedures, functions, and packages to enhance code organization and reusability, along with diagnostic scripts for improving database integrity. Conducted SQL query optimization for swift response times. Profiled and cleansed data from various feeds to conform to business rules. Designed and maintained data models and documentation.

EDUCATION

BOMBAY UNIVERSITY, Bombay, India, Bachelor of Science, Physics and Computer Applications

CERTIFICATIONS

Oracle Database 10g Certified Associate – Certification from Oracle Corporation

Contact this candidate