We provide IT Staff Augmentation Services!

Technical Development Lead - Assistant Vice President Resume

PiscatawaY

SUMMARY:

  • Technically sophisticated senior architect with more than 10 years of experience in design and implementation of data engineering, data warehouse and data visualization solutions using cutting edge technologies within Investment Bank, Financial and Insurance domains.
  • Specialized on MPP platform columnar oriented databases on Hadoop Platform and developed solutions by enabling users to make smart business decisions using fast analytics solutions.
  • Seasoned development lead equally effective with leading technical teams and providing hands - on technical programming expertise.
  • High Proficient authority in industry languages, SDLC methodologies, standards, and best practices, superior planner and prioritizer with track record of on-time project delivery.
  • I’m responsible for technical design (Data Integration / Securing the data / Provisioning the data to various systems), development of data lake / data warehouse using BIG Data Hadoop Platform, Design / Prototyping the Data Visualization on Tableau, Conducting workshops with stakeholders for the requirements and signoff and also providing guidance and collaborating with on-shore / off-shore teams.

AREAS OF EXPERTISE:

Business Analysis | Business Process Improvement | Project Management | System Architecture | Resource Management | Stakeholder Management & Cross team Communications | Agile & Scrum Methodology | Team Leadership| Change and Release Management | Problem Resolution | Visualization Dashboard Reporting | Test-driven development | QA & Test Automation

TECHNICAL QUALIFICATIONS:

Data Governance, Management, Architecture and Modeling: ERWIN, ER/Studio, Data modeling (OLAP & OLTP Design - Star & Snowflake Schema), Data warehouse Projects implementation Kimball / Inmon methodologies, DB Migrations and Upgrades, Data Integration, ETL/ELT Design Patterns and Data Cleansing and Data Migration.

BIG DATA, Databases & BI analytics: MariaDB Columnstore, BIG Data Hadoop, Hive, Apache Impala, Apache Kudu, Spark, Flume, No SQL (Hbase, Cassandra) and New SQL based Databases, Confidential Analytic Platform APS/PDW, Azure Data Warehouse, SQL Server 2008/2012/2014/2016 , Confidential BI - SSRS/SSIS/SSAS, Oracle, DB Performance Tuning.

Messaging Systems: Kafka, Solace Messaging systems

Reporting and Data Visualization: Tableau and SQL Server Reporting Services

Configuration Tools: Team Foundation Server, VSS, Perforce, Jira and HP ALM

Programming Languages: Net C#, Vb.Net, Python

Quality Assurance: Test Automation, Database Testing, Data Quality Testing

PROFESSIONAL EXPERIENCE:

Technical Development Lead - Assistant Vice President

Confidential, Piscataway

Responsibilities:

  • Development team lead of Identity and Access Management data warehouse system and responsible for designing and architecting system to scale multi terabytes of data.
  • Requirements analysis and detailed functional design for the various blocks identified within the application.
  • Getting Working Sessions with the client group and formal signoff of the deliverable.
  • Liaise with senior management, auditors, control & legal teams. Defined data architecture and developed solutions to regulate the risk areas and control gaps. Leading the initiatives in forefront and integral part of key milestones.
  • Initiated the Proof of Concept using Open source MariaDB Columnstore (MPP framework based). This is the initiative to save the cost from the use of traditional database proprietary (MS SQL/Oracle) thus resulting high return on investment.
  • Initiated the Proof of Concept on modern technologies BIG Data Hadoop as Data Lake, Hive, Impala, and Kafka and received the approval and funding from management for proceeding further.
  • Has responsibility of setting up team and vendors for the BIG Data Initiative and successfully finished initial phase of project, which includes Infrastructure capacity planning and sizing, environment setup, Defining Implementation practices and guidelines, Security Guidelines.
  • Assigned tasks to associates, staffed projects, tracked progress and updated managers as necessary.
  • Developed and executed programs and solutions resulting in increased exposure, system stability and customer satisfaction.
  • Optimized poor performing Database SQL’s, Procedures, SSIS packages and gained 30% of ETL batch runtime efficiency.
  • Expert in dimensional data modeling using SSAS and Erwin, cube partitioning, optimization, creating aggregations
  • As an application owner, focused on continuous business support and deployed automated monitoring control mechanisms to make sure that highly visible applications are operational smoothly throughout 24/7.
  • Expert in data blending, metrics, attributes, filters, reports, advanced chart types, visualizations and dashboards. Act as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution.
  • Screening and finding right technical members for the team, hiring and on-boarding them.

APS/PDW BIG Data Warehouse Lead Consultant

Confidential, Cleveland

Responsibilities:

  • Design the ELT design patterns on PDW, Documentation & shared the knowledge with the developer community.
  • Train & mentor the peers and accelerated the team performance on development using PDW.
  • Ingest Data on Hadoop in real-time and used as Data Lake. Data is stored in ORC for higher compression and faster I/O.
  • Used Polybase and Connect to Hadoop to pull the data into warehouse using PDW External Tables.
  • Troubleshoot and performance optimization of external tables ex: Push Predicate, Stats on external table etc.
  • Monitor PDW appliance using console and perform health checks. Monitoring the Data Movement Service.
  • Design Database (Distributed, Replicate, Round Robin) as per PDW standards and maximize the efficiency of MPP platform.
  • Lead Query performance tasks, optimization of the application performance tuning and gained overall performance by 30%.
  • Software configuration management and release management and liaise with the QA team.

SQL Server, MS BI Data Warehouse Consultant

Confidential, Redmond

Responsibilities:

  • MS-Cloud based Data warehouse ETL solution migration onto SQL Server 2014. Revamped some of the legacy code components and gained significant performance in ETL layer and saved overall batch runtime by 40%.
  • Developed and maintained the best practices. Focused on database performance & scalability.
  • Optimizing the SQL code & performance tuning and adhere to the Confidential Defined principles.
  • Involved in code reviews and adhere to the best practices as defined by leadership team.
  • Participated in workshops with Development Lead. Defined ETL layer optimizations plan and executed successfully.

SQL Server & MS BI Lead Consultant

Confidential

Responsibilities:

  • Requirements analysis and detailed functional design for the various blocks identified within the application.
  • Getting Working Sessions with the client group and formal signoff of the deliverable.
  • Detailed technical design for all the identified subject areas (blocks) required for further build activity.
  • Dimensional data modeling using Star Schema for the various metrics related report.
  • Report UI design specification to be used for report creation and testing.
  • OLAP services & cube design for advanced analytics and KPI reporting.
  • Coordinated with the QA team for the Smoke, Assembly & System testing of the reports. Unit/System Testing & validation.
  • Monitored database status including CPU, memory, I/O, space and dead lock using SQL Server Utilities.
  • Design and Develop new SSAS Tabular Models, which uses xVelocity (formerly Veritpaq) in-memory engine.
  • Advanced knowledge of Excel for using Pivot tables, Power Pivot, Complex formulas. Created Power View Reports using the Tabular SSAS models in Excel 2010 and 2012.

SQL Server & MS BI Lead

Confidential

Responsibilities:

  • Liaise with business SME’s in analyzing business requirements (KPIs), understand the various data sources.
  • Design, Develop, Peer Review and maintain the schema, tables, indexes, views and procedures in SQL Server.
  • Develop strategies for use in high volume, high performance heterogeneous environment.
  • Map source data elements from various systems and develop, test, and support extraction, transformation and load processes.
  • Analyze source data rules to the data in the raw data mart and load it to the reporting data repository.
  • Defines and captures metadata and rules associated. Design and develop the FSD/TSD for ETL development.
  • Knowledge in designing and developing data warehouses, data marts and business intelligence using multi-dimensional models such as star schemas and snowflake schema for developing cubes using MDX.
  • Write Technical specification for the related work for each SSAS Tabular models.
  • Manage artifacts - versions, including software code, documents, design models, and even the directory structure itself.

SQL Server & MS BI Lead

Confidential

Responsibilities:

  • Work closely with IT and the Business group to understand business-reporting requirements.
  • Participate in development and execution of tactics and strategies to optimize data quality in data warehouse.
  • Developed ETL pipelines using SSIS and loaded data into SQL Server from various Data sources including Flat Files, SQL server.
  • As a backend developer, developed stored procedures, functions, views, and triggers.
  • Create the database schema and implemented a relational (for Confidential ) and dimensional model (star schema).
  • Create logical and physical data models and implement the database.
  • Provide subject matter expertise to systems programs in the form of knowledge of data systems, interpretation of source data including data cleansing, data testing and validation in multiple systems.

Senior Project Engineer - MS BI, SQL Server Developer

Confidential

Responsibilities:

  • Work closely with IT and the Business group to understand business-reporting requirements.
  • Participate in development and execution of tactics and strategies to optimize data quality in data warehouse.
  • Developed ETL pipelines using SSIS and loaded data into SQL Server from various Data sources including Flat Files, SQL server.
  • As a backend developer, developed stored procedures, functions, views, and triggers.
  • Create the database schema and implemented a relational (for Confidential ) and dimensional model (star schema).
  • Create logical and physical data models and implement the database.
  • Provide subject matter expertise to systems programs in the form of knowledge of data systems, interpretation of source data including data cleansing, data testing and validation in multiple systems.

Hire Now