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

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 Confidential 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, Cognos Power designer

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. worked very closely with ETL training groups and created swimlane diagrams using Visio for step by step process education and transformed strategic projects into solutions.

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