SUMMARY:

• Extremely versatile techno - functional lead with a wide array of client facing and technical skills that thrives on solving next-gen technology issues while delivering on-time projects.
• Over 10 years of experience in software architecture, software development, data warehousing, big data analytics and data migration of both backend and front end technologies.
• Designed high-impact auto finance environment that focused on user-centered software with strong appeal, sophisticated production values and intuitive navigation to maximize user engagement
• Experienced in managing all aspects of the SDLC, from initial capture of requirements through development, testing, delivery, enhancement and upgrades.
• Very proficient Microsoft BI stack expert in delivering solutions using SSIS, SSAS, SSRS, TSQL, Azure
• Hands on knowledge in building large data lakes and leverage data for analyses for batch, real time and interactive analytics by data scientists and BI engineers.
• Delivered over 25 multi-million dollars, large-scale solutions, managing onshore and offshore teams
• Skilled in building, training and mentoring high-performing teams in consistently delivering strategic software projects and programs as well as equally ensuring compliance with PMO.
• Outstanding perception in bridging the gap between Technology and Business Divisions to eliminate historic conflicts, ambiguity of requirements, improve understanding and cooperation.
• Knowledge of change management, process improvement and project management methodologies like ITIL, LEAN and Six Sigma in delivering on-time and on-budget projects and programs.
• Deep knowledge of big data technologies like Cloudera, Horton Works, HDFS and MapReduce as well as big data analytical/visualization tools like Tableau, Microstrategy BI, Kibana and spotfire
• Solid background in IaaS using AWS (Amazon Web Services) ecosystem platforms like Elastic compute cloud and Simple Storage Services S3(Redshift, DynamoDB, Elastic Load balancing).
• Hands-on experience with real time stream processing pipelines such as Apache Storm and Spark.
• Efficient SQL analyst in writing dynamic queries, stored procedures, data partitioning and automation using MS SQL, Oracle, MySQL, Sybase, Netezza and Teradata.

TECHNICAL SKILLS:

Big Data: Cloudera, AWS, EC2, S3, Spark, Storm, Flume, Kafka, Pig, Hive, HDFS, Sqoop, YARN, Splunk, Impala

ETL Tools: PowerMart, Informatica PowerCentre, MS Data Transformation Services, DataStage, Ab Initio

BI/Reporting Tools: Tableau, Microstrategy BI, Kibana, Cognos, Spotfire, QlikView, Business Objects

Data Modeling: ERWin Saphyr, ER Studio, Data stage, Rational Rose

Databases: Oracle, Hadoop, MongoDB, Cassandra, Hadoop, SQL Server, Netezza, sybase and Teradata

Platform/Operating Systems: Unix/Linux, MS Windows, Sun Solaris, Oracle Dev Suite

Internet Standards: XML/SOAP, HTTP, SMTP, HTTP/SSL

Languages: C, C#, HTML, MMX, Perl, PHP, SQL, T-SQL, PL/SQL, VizQL, C, Java/J2EE, Access

Project Management /Office: MS Project. MS Word, Excel, Access, Visio, Powerpoint, Outlook

AREAS OF EXPERTISE:

• Software Architecture
• UX design
• Business Intelligence
• ETL
• Quality Assurance
• Project Management
• Strategic Planning
• Data Integration
• Software Development
• Problem Solving
• Big Data
• Time Management

CORE COMPETENCIES:

• Highly proficient Software architect lead engineer with first rate skills in developing ETL solutions, big data lakes and analytics solutions, dashboards and statistical analyses using platforms such as AWS, Cloudera-Hadoop (CDH), Azure, Tableau, Microstrategy BI, Informatica and BO.
• Very apt in creating functional Design Specification documentations and Technocal Design Specifications documentations for technical delivery projects.
• Highly skilled in creating sound investment solutions with strategic and risk innitiatives.
• Efficient in using IBM Suite, Data stage, Erwin, Cognos Power designers and MS Visio to develope conceptual, physical and logical data models.
• Experience in both Abinitio and Informatica cloud evironments.
• Outstanding presentation, written and oral communication skills in relating business issues to all departments and teams accross my organization as well as executives.
• Proven understanding of the SDLC processes, architecture and project management steps used in delivering IT solutions with confidence in executing data warehousing concepts and strategies.

PROFESSIONAL EXPERIENCE:

Data Integration Architect Lead

Confidential, Irving TX

Responsibilities:

• Defined strategy and implementation plan that resulted in the acquisition and integration of 10.4million loans from Bank of America into the NSM technology environment.
• Designed end to end Data warehouse and later data lakes which were used enterprise wide by multiple Business Intelligence Solutions software for all LOB’s
• Proficient Microsoft BI Stack developer in designing, executing and engineering data warehouse solutions for next generation analytics platforms
• Created SSIS packages, integrated multiple sources, created cubes and MDX queries with SSAS and provided insight with Microsoft power BI.
• Led multi-disciplinary teams of business analysts, developers, engineers, DBA’s programmers, and client users in eliciting sustainable requirements.
• Unwrapped multiple SSIS packages to reverse engineer source to target mappings and re-engineered migration and integration of data from legacy systems to analytics platform.
• Used Azure, cloudera-hadoop ecosystem, MapR, Pig, Hive, Impala, flume, Kafka for batch processing and AWS Redshift, Spark and Storm for real time analytics and high speed streaming.
• Designed easy-to-use automated dashboards and heat maps with power BI tools like Tableau, BO Webi, Cognos and Microstrategy BI for business intelligence visualization on data lakes.
• Partner with all key stakeholders to deliver multi-platform high quality data driven applications that meet business needs of both internal and external clients.
• Responsible for planning, developing, improving and maintaining complex components of the Citi’s website and data models.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions

Environment: IBM Suite, AWS, Cloudera-Hadoop, Microstrategy BI, Microsoft SSIS, SSAS, SSRS, TSQL, Azure, Flume-Kafka, Tableau, Erwin, SAS, Teradata, Cognos, SharePoint

Confidential, Plano TX

Data/Software Architect

Responsibilities:

• Built cross-functional, and multi region teams of developers, engineers, project managers to drive multiple auto finance development programs and projects to successful launches.
• Used Microsoft SSIS for data integration, migration and for data analytics and paralleling of huge amounts of data.
• Instrumental in creating and managing data migration into data lakes and between servers using the cloudera ecosystem components.
• Used entire Microsoft BI stack to provide detailed architecture IT compliance and data integrity organization as well as built fail over disaster recovery servers and mitigated risk
• Maintained load balance in the auto warehouse production environment and made sure to resolve space and data issues for process improvement and continuity in WAS S3 environment.
• Scheduled backups and disaster recovery servers for business sustainability
• Hands-on development and management of code tracking to upgrades for the Confidential 360 website and provided an easy to use platform for clients.
• Implemented global BI architecture for migration of mortgage and home loans from Teradata onto the AWS cloud and used Tableau and Microstrategy BI for data visualization and analytics.
• Optimized requirements for Hadoop migration, created functional design documents, specifications, performed data quality checks, analysed data and performed impact analyses.

Environment: Teradata, AWS-EC2, S3, Microsoft BI stack, Kibana, OLAP, Informatica, Ab Initio, Cloudera-Hadoop, Pig/Hive, YARN, Splunk, Cognos, Microstrategy BI, Tableau, SQL.

Confidential, St Louis, MO

Data Architect

Responsibilities:

• Management of data architecture team by executing quality assurance, feasibility studies, data warehouse sustainability and created optimized data models using Erwin.
• Managed issue/ticket tracking and resolution while engaging the appropriate teams and resources on bridge lines for proactive fix to data quality issues.
• Designed data objects with Microsoft BI stack to establish and enforced Confidential policies, procedures, standards and metrics for data quality wellness checks and master data management
• Heavily used MS Visio to record and document processes and inconsistencies in the production environment and worked very closely with storage teams to enhance capacity planning.
• Created optimized visual reports with Kibana and shared across the end users in the organizations as well as third parties for decision making on constant analyses and discoveries.
• Gathered requirements and recommended sustainable technologies to tackle data quality issues and readability in the Informatica environment.

Environment: Business Objects, kibana, Sybase, kibana, SAP ERP, Erwin, Control M, SAS, Informatica, Spotfire, Tableau, SharePoint, PL/SQL, Java, Unix, Toad, MS Visio.

Confidential

BI Manager Architect, VP

Responsibilities:

• Brought in to lead the full lufecycle design, developement and delivery of a fully automated business implementation enterprise PMO build out and Loass Prevention SaaS project.
• Planned and directed programs, policies and data architecture to ensure that all portfolio units’ activities are with FAR regulatory compliance using Cognos power play cubes and Erwin .
• Used MS Visio and Cognos powerplay designer for process mapping and engineering architectural designs for developing performance and business metrics.
• Worked closely with dev teams to carry out UAT and document findings appropriately while using Miscrosoft BI stack for integration and analytics.
• Managed and supported the datawarehouse revitalization of global financial department towards sustainable and efficient technological advancements.
• Develop standards and methodologies for benchmarking, performance, evaluation, testing, data security and data privacy.

Environment: SAP BW, BO, Miscrosoft SQL server, Oracle 9i, MS Suite, SAS, Irwin, SharePoint, Control M, Netezza, Tableau, JIRA, Informatica, MS Visio

Confidential

Management Consultant

Responsibilities:

• Marks and Spencer
• Confidential Bank
• Maersk
• Alliance Data+

Environment: Teradata, HPSM, IBM Suite, Erwin, SAP, Informatica, Sharepoint, Microstrategy BI, SAS, Java, Control M, Oracle, Tableau, SQL, UNIX, Business Objects.

Confidential

Software Engineer/Developer

Responsibilities:

• Produced wireframes, XHTML code and CSS that contributed to user-centered design (UCD) efforts for dozens of Web pages.
• Advised senior manages on emerging technologies and implemented strategies for business optimization and achieved operational efficiency savings of $9Million
• Used SSIS, SSRS and SSAS to develope and intergrate reports in Management Studio.
• Designed solution architecture and modelled both conceptual and physical data for intelligence implementation using Erwin, datastage and sybase power designer. w orked very closely with ETL training groups and created swimlane diagrams using Visio for step by step process education and t ransformed strategic projects into solutions.

Environment: Linux, MS-SQL, Sybase Power designer, SAP, Oracle PL SQL, Informatica, IBM Datastage, SAP usiness Objects.