SUMMARY

• Hands - on Experience in all facets of Data Management and Data Governance
• Experienced in developing, improving, supporting, monitoring and enforcing Data Integrity, Data Naming standards and Business Intelligence standards to reduce redundancies
• Proficient in designing, developing, implementing and deploying Relational / Transactional / Data Warehouse Data Models, ETL solutions, Database solutions and Reporting solutions
• Experienced in creating and enforcing best Coding Practices (database / scripting), Data Quality and Data Cleansing, Mapping, Transformations, Data Distribution and Data Security (Encryption, Fine Grained Security / Virtual Private DB)
• Adept in database performance tuning, problem solving and troubleshooting, saving companies inordinate amount of downtime
• Hands-on Experience at working with all ranks in an organization(both onshore and offshore) right from developers to CEO through various phases of SDLC
• Qualified to lead a Data Architecture team
• Excelled at Fostering collaboration and team work
• Trained in Cloudera stack of applications, MongoDB (Big Data /Cloud ) and trained our team in the same

TECHNICAL SKILLS

• UTPL-SQL
• ETLVisio, UML
• Power Designer
• Embarcerado
• Hummingbird
• Toad
• SQL Query Analyzer
• OMNIS
• Autosys Scheduler
• DB Artisan
• SQL PLUS
• IBM COGNOS
• Inhouse BI Tools
• CVS (Version Control)
• SSIS
• SSRS
• SSAS
• Tableau

PROFESSIONAL EXPERIENCE

Data Architect / BI Architect

Confidential, Boston, MA

Responsibilities:

• Created a Road Map, Data Vision and Data Dependencies presentation for the layer leads
• Mastered the provider data from soup to nuts and created a generic logging process
• Created a flexible Reporting Module
• Trained the BI team into thinking performance while coding, design and process, latest features of SSRS / SSIS / SQL Server / Cloudera
• Performance tuned various poorly performing queries
• Researching the best tools for the merge of structured and unstructured Data and analyzed various BI tools like Tableau, Power BI, Excel, SSRS
• On the Architecture Review Board and the Data Architecture Review Board

Confidential, Boston, MA

Responsibilities:

• Trained all the DBA’s and Developers on the use of the ER Studio
• Introduced Data Naming Standards, Coding Standards, Best Practices and Performance Tuning
• Worked with Business Analysts and Business Customers, third party Vendors to define the Requirements, Delivery Approach and Technical Solution of the Insurance suite Data Model (Policy, Claims, Legal, Billing, Financial, claim fraud detection and prevention Model
• Worked with the in house DWH team to design the DWH to map to the SR transactional Database
• Responsible for architecting, reverse engineering and the data movement strategy (transitional, ODS, DWH, external feeds), SQL Server to UDB and creating an Enterprise Data Dictionary
• Developed and demoed a prototype to educate the upper management of the use of MongoDB for document centric projects. (Policy Generation)

Data Architect

Confidential, Boston, MA

Responsibilities:

• Architected a common Data environment for High Income, Fixed Income and Equity of Security Reference system, Holdings, assets and Benchmark system, Organization and Person reference system, Portfolio management, Research and Trading system and Market Data (external / internal ratings).
• Reverse Engineered the current systems (Sybase, Oracle, SQL Server) and analyzed the current functionality, coordinated with the business to eliminate obsolete functionality.
• Created conceptual Model, Logical Data Model and Physical data Model using Power Designer to support the various application systems mentioned above.
• Provided technical oversight, defined data loading rules and validations and facilitated historical data seeding as well as data loading procedures and defined a Common Data access Layer.
• Coordinate with the onsite and offsite clients to ensure the Validity of the existing outbound and inbound feeds
• As a member of the Code Review Board primary responsibilities includes to conducting walkthroughs of all code, peer reviews, and provide performance tuning guidance.
• Responsible for analyzing various market data feeds from vendors and identifying one (Factset) feed that had the most comprehensive coverage of securities and market / external financials data to meet our business requirements.
• Key contributor in the vendor evaluation process. Conducted many meeting with the various vendors to explain our requirements and verified the functionality could meet our requirements. Evaluated the cost / license / vendor SLA to ensure a 24 / 7 support model.
• Lead the Data Modeling team to architect and design the Data Warehouse multi-dimensional data Model (combination of Star and Snowflake Schema).
• Created Materialized Views for the reporting team.
• Conducted rigorous regression and UAT testing to ensure compatibility with the existing application.

Data Modeler / Principal Data Analyst

Confidential, Boston, MA

Responsibilities:

• Pioneered the Information Barrier Technology at the Database level in Sybase and oracle.
• Researched the various Data Access Policy technologies and adopted the most suitable to fidelity applications and methodology. Designed and developed the proof of concept (POC).
• Interacted with the Business Analyst to ensure the correct fund / research business access policies.
• Conducted extensive testing with the business community and Database developers to understand the concept of Information Barriers and prepare them for possible questions from business.