SUMMARY:

• Data driven, dynamic, and results - oriented Data Architect with wealth of experience in designing and implementing solutions, providing guidance-thought process for implmenting best pratices & standards in Data Management Life Cycle from Data acquistion to Data Archival process including Master Data Management, Data Goverance and Data Visulatization. Developed solutions for both length (Huge volumes) and width (Data Analytics, QARG) using data platforms like Row base, Columnar, NoSql and Cloud. Ensured successful implementation of data ingestion process for Batch Processing, Real & Near Real time data
• Architected and implemented solution to provide Customer specific products in Satellite Radio Space by integrating massive volumes of Users Consumption, Events and Ps real time data from Cloud environment with in-Premises data by leveraging big-data technologies and Columnar-Data bases.
• Significantly improved Operational efficiency, adoptability to applications at Credits Firm though designing of Master Data Management and Governance strategies to address data issues. The impact is more than 50% of issues were resolved in minimal time thus by reducing troubleshooting team size.
• Led the team to architect, design Market Derived Ratings analytics application for CDS, Sovereigns, Bonds at Major Credit Ratings firm to support users across globe, by integrating data from various external vendors and internal sources.
• Ensured implementation of more efficient, higher quality Data Analytics Applications by designing, developing Data Models, Data Architecture and smoother transition from legacy version.
• Successfully integrated 3 organizations Real Estate information into one Centralized Data Warehouse system by designing Data Marts, Data Integration and Reporting platform.
• Data Architecture & Strategic solutions
• Data Integration (In-Permsis / on Cloud / Hybrid)
• Data Goverance & Master Data Mgmt
• Row / Columnar / No-Sql Data Bases
• Analytical Application Development
• Tools & Technologies evulations
• Team Building & Delivery Support
• Stake Holder Management
• Participated in design sessions to understand business needs and functional / non-functional requirements, and applied methods and practices
• Provided guidance to teams on data architecture and data life cycle management techniques.
• Represent data architecture concerns in design, implementation and deployment reviews.
• Lead data innovation, appropriate tool selection and proof of concepts.
• Maintain organizations wealth and health with leading and emerging data technologies including big data platforms, NoSQL databases, data streaming, in-memory data management, real-time analytics, cloud data services
• Identify business opportunities for applying leading and emerging data technologies and guided business teams.
• Created Data Models, provided solutions for Data Movement and migrations, shielded data with rigorous data security and data governance practices.
• Actively involved in designing One source of truth (Master Data Management).

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center, DT Studio, IDQ, SSIS

BI Tools: Business Objects, Cognos

Data Modeling: Dimensional, Star, Snw-Flake, Physical, Logical

Row Databases: SQL Server 2005+, Oracle 10g/9i/, Tera Data

Columnar DB: Vertica, Amazon RedShift

NoSql DB: Cassandra

Programming / Scripting: C, Java Script, VB Script, ASP, T-sql, Pl/Sql, Shell Script

Misc Tools: Autosys, Erwin, TOAD, VCC, VISIO, XML SPY, Dev Center

SDLC: Water-Fall, Agile, Kanban

Big Data Eco System: Hadoop Hive, Flume, Sqoop, Kafka Exposure

Specialties / Key Word Search: Team Management, Project & Stake Holder Management, Design, development of Analytical & data warehousing apps, delivery, Change Management, Release Management, Scope Management, OnSite- Offshore, Informatica, Data Analysis, database architectures (Relational, MOLAP, ROLAP), Client facing skills, Convert challenges to opportunities, Strong DW Fundamentals and concepts, Scorecards, Dashboards, Performance Tuning, Cloud Data Integration, ETL, BI, Agile, Risk Mitigation strategies, Data Mining

PROFESSIONAL EXPERIENCE:

Confidential - NEW YORK, NY

Consultant Data Architect

Responsibilities:

• Converted stake holders requirements into deliverable solutions inc Integration of data, able to perform interactative analysis.
• Actively participated in Tool selection and Recommend appropriate BI and ETL tools, platforms, and methodologies.
• Architected the BI solution for integrating real time data (from cloud) with batch data (in-permsis).
• Created Data Models, Master Data Management, data govereneance guidelines to shield data.
• Sliced whole project requirements into stories, trackable delivery items for Agile and PMO tracking.
• Partnered with with ETL Team, Reporting, QA associates and BSMs to deliver business needs into technical deliverables by following best standards.
• Provided data integration work efforts and durations by collobrating with teams.
• Assisted PMOs for Tracking the deliverables, communicating status, risks and mitigation.

Confidential - NEW YORK, NY

Data Specialist

Responsibilities:

• Demonstrated excellence in engaging with Stakeholders to create Master Data Management, Meta Data Management process for data-centric applications.
• Created data integration delivery road map in alignment to organization’s standards, process, and best practices.
• Planed, estimated, manage resources, budgeted and communicate to stakeholders and upper management.
• Worked with Enterprise Architects for prototype applications for moving data to Cloud platform by using Big Data eco system for analytical scoring.
• Built security and data quality for data distribution and storage process by Working with Data Governance and Data Ops teams

Confidential

Delivery Lead

Responsibilities:

• Managed customer (analysts) issues through QC (Quality Control) process and resolving them in a timely manner.
• Leading team in Design, development and conducting periodic Code Walkthroughs.
• Mentoring, guiding of team and performance appraisal process of team members.
• Working with Change management teams for periodical release to production.
• Taking care of SOW extensions and approvals for new team members.
• Updating senior management in weekly status metrics and progress charts.

Confidential

ETL Architect

Responsibilities:

• Developed ETL architecture approach this project. integrated all data feeds & applying business rules before delivering data to Quant Models
• Estimated and planned Data Storage requirements, Data Model and Data Base design.
• Creating Data Dictionary, Data Requirements document from BRD Docs and mapping those with source / data feeds.
• Closely working with Business Users, DBAs, and Enterprise Architect teams to make sure solution meets the application requirements and adhere to organization standards.
• Hands-on for complex data components using Pl/SQL procedures and Informatica mappings.
• Worked with Development team to mentor them to deliver the project within given time frame.

Confidential

Technical Lead

Responsibilities:

• Involved in the Scrum meetings with the EDW Team and Technology partners and held discussions about the current and consecutive Sprint deliverables as a part of Agile methodology.
• Created Technical System Design documents, Low-Level Design documents, Unit Test Case templates
• Involved in doing the effort analysis and allocating the tasks to the team and managing the same.
• Enhanced performance of SQLs and Informatica mappings/sessions by session partitioning techniques
• Created plans for UAT and Production rollout of the product.

Confidential

Senior Developer

Responsibilities:

• Involved in designing ETL data load strategy for SCD type1, 2 Dimensions and Fact tables, ETL rejects handling, ETL restart recovery logic.
• Involved in writing UNIX scripts for generating the parameter files dynamically, file watcher, file validation, to schedule/Run Informatica session/workflows, and file archive strategies.
• Created Unit & QA test case templates (standardized formats)