Profile

Proven 24 years of senior executive experience in Data Science, Big data, Business Analytics, Database management, Data warehouse, Data Architect, Enterprise Architect, Program Management, IT Operation Infrastructure, Project Management, Portfolio management, Contract Management, Information Architect, Business Process Modeling and Customer Relationship Management.

• Experience in Hadoop MapReduce, HDFS, and HBase using MapR 4.01 Cloudera CDH 4. Good understanding of Hadoop stack-internals, Hive, Zookeeper, Impala, Drill, Pig and Spark, Shark, HBase, Accumulo, Cassendra, MangoDB, Strom, MAPR-DB MAPR-File system, Architecture lead on Business Analytics Predictive Analytics implementation projects
• Extensive experience in Sun SPARC, Sun Solaris OS, AIX, Windows Server, Many years of experience in Netezza Striper IBM PureData System for Analytics , Oracle RAC. Data Guard, Sybase ASE, Sybase Replication, SQL Server, My SQL, Oracle Weblogic, Oracle Fusion Middle Ware, Oracle PL/SQL, Erwin ER-Studio, Embarcadero DBArtisan, DB change Manger and Oracle Business Intelligence, SQL Server BI 2012, Microstratgey, Informatica and Experience in selection and implementing COTS solutions.
• Expert-level knowledge of Amazon EC2, Amazon S3, Amazon DynomoDB, SimpleDB, Amazon RDS, Amazon Elastic Load Balancing, Amazon SQS, Amazon Redshift and other services of the AWS family and experience in Microsoft Azure virtual machine, storage, SQL .
• Lead and manage large IT control frameworks, IT process frameworks i.e., ITIL , ISO17799/27001 information security standard, Sarbanes-Oxley compliance and process engineering/process improvement
• Experience in Implementing all phases of the TOGAF Architecture Development Method ADM and created Business, Application, Data and Technology Architecture model. Experience in following business process management BPM that supports managing by process and convergence of technologies for workflow, enterprise application integration EAI , document and content management, business rules management, performance management and analytics among others have been brought to bear with a focus on supporting process based management.
• Comprehensive functional understanding and close working relationship with all business areas of global Fortune 500 companies.
• Demonstrated ability to challenge current business practices, envision new methods to improve processes, manage business expectations, and implement cost effective solutions
• Leadership in project planning, scheduling, prioritizing, work assignment and identify mitigate risk. Improved team productivity by 15 by implementing project portfolio management to reduce multitasking
• Responsible for executive presentations of technical and financial project management status and future performance objectives
• Demonstrated ability to focus on high-payoff improvements to achieve immediate bottom-line benefits and developed methodology for business process analysis and integration. Also, the subject matter expert SME in supporting the enterprise IT process integration
• Lead Architect for CNCS and USDA focused on emerging technologies and managed direct reports responsible for database management, application strategy, designs, implementation plans, and builds. Designed, built, and managed environments that consist of Windows, Red Hat Linux, Active Directory, IIS, Apache Tomcat, Weblogic, Oracle Application server, Oracle, MSSQL, Striper, VMware, SAN, Blade Centers, Cisco firewalls, routers and switches. Collaborated with team of consultants, software engineers, developers, DBAs and vendors to design, document, and implement applications and infrastructure solutions.
• Recommend and designed future technology directions trends and developed analysis and recommendations for CRs Change Request to the business process and the corresponding process models based on the client s business requirements, implemented approved changes to the process models
• Improved operational capabilities and customer satisfaction by simultaneously managing multi-million dollar federal database projects for the past 12 month period.
• Delivered staffing and consulting services to both government and commercial clients in information technology, risk management, business continuity, and financial service management.
• Leverage extensive background as a software developer, Data Modeler, information Architect, Database Admin, Data warehouse admin, Business analyst to create high quality requirements documentation, business rules spread sheet, scope estimates, mile stone, resource allocation, Budget estimate, Use strong analytical and communication skills to drive quick resolution of project dependencies.
• Extensive experience in Relational Data Modeling, Dimensional Data Modeling, Logical/Physical Design, ER Diagrams, Forward and Reverse Engineering, Publishing ERWIN diagrams, analyzing data sources and creating interface documents and proficient in Relational Database Management Systems.
• Experience in Meta data management in tracking and retaining business data that leverages and facilitates reuse of existing table definitions, Business rules. Understand how the data was derived and where it is stores and used auditing critical business data.
• Experience in Hybrid clouds deployment module namely private, public and community clouds and Knowledge of SaaS, PaaS IaaS as service module, implemented Amazon cloud i.e. AWS .
• Accomplished Information Technology Executive with extensive leadership and organizational development skills in building and leading worldwide architecture, Infrastructure, development and support organizations across diverse industries.

Professional Experience

Confidential

Manage and support of multiple advanced predictive analytical and BI projects for telecom, government, and Insurance industries using IBM PureData System for Analytics N2001 i.e. Netezza Striper , MapR Cloudera Hadoop echo System products namely MapReduce, Yarn, Spark, Pig, Shark, Impala, Hive, HBase, Accumulo, Strom, Spark Streaming, Flume, Sqoop, Sentry, Oozie, Zookeeper. Oracle, MS SQL Server, IBM SPSS Modeler, Python, Java, R, Scala, Big data Hadoop, HDFS, HBase, Hive, Shark, Cassendra, MangoDB, MLLIB, Mahout, GraphX, Rest API, MAPR-DB, MAPR-FS, Microstrategy, SVN, GIT, Mega, EA, Confluence, SharePoint, Sales point, Weblogic, Tomcat, OAM, AWS, SSO. Amazon EC2, S3, RDS, Redshift, ELB, EBS and SimpleDB, Microsoft Azure, IBM BigInsight IBM Bluemix.

Confidential

• Manage and support of enterprise Data Warehouse operation, big data advanced predictive application development.
• Directed few technical staff to provide quality robust production, application support, automated day-to-day database and application jobs.
• Manage and support a broad range of interdependent database projects including upgrade install security patches, Service Pack, policy procedures, Application enhancement, Advance Analytical application development and Info Security implementations. Actively collaborate with the cross-functional teams and leaders on proposed solutions, resources, project scope and project estimates.
• Design, investigation and implementation of public facing websites on Amazon Web Services AWS
• Creating and Managing Virtual Machines in Windows Azure and setting up communication with the help of Endpoints and also VM Migrations from Transitional hosts on Razorsight Boxes.
• Knowledge of IBM Cloud Bluemix and exposure to IBM BigInsight BIG SQL, Text mining, BigSheets and Big R for Hadoop.
• Experience in Big data Analysis, set frequent Mining and Association Rule Mining.
• Experience in drive delivery of technology roadmap related items by various teams, interface with Enterprise, and give presentations on upcoming initiatives
• Establish relationships with various technology partners Wintel, UNIX, Storage, Network, etc. Attain a deep knowledge of Retail Direct Bank IT technology/infrastructure, critical operational controls, and architectural standards
• Demonstrated and proven ability to handle multiple assignments and achieve targeted goals on time.
• Implemented firm's disaster recovery plan to ensure minimal productivity loss for client's database and applications.
• Developed documentation that details Database standards, procedures, policies and service level agreements between different clients database team.
• Experience in migrate few customers from Netezza to Hadoop, HBase and Hive platform by saving support cost, hardware cost for the company. Big data MapR Data Lake to archive, store large volume of data and export import larger volume of data using Spark, Sqoop by reducing hardware cost of Netezza.
• Implemented major migration of Netezza from Twinfin to Striper 24 disks to 240 disks .
• Extensive experience in tuning of Netezza Appliance quires, tuning of table data distributions, Configure CBT, design star and snow schema, recommend team to create Materialized views.
• Recommend DBA to schedule daily groom table, execute generate statistics, get top 10 poorly running quires, tune SQL quires and follow Netezza best practice document.
• Experience in tuning BI KPI reporting and Analytical SQLs and make sure that customer billing, usage, Sales, customer reports are running as expected and support in tuning executive dash board, trend analysis, Ad-hoc Analysis and pre-defined report table distribution and SQL.
• Help team to learn about explain plan, tune Analytical SQL and avoid broadcast, redistribution of costly quires.
• Implemented Netezza workload management, implemented Netezza Analytical function, and procedures.
• Implemented Data loading using MapR Spark, Sqoop from external CSV, text files to Netezza database as raw data.
• Experience in Converting data to transactional data start/snow schema
• Increased the uptime of all servers to a level of at least four nines 99.99 on all major database and application servers. Managed critical upgrade efforts and solved few clients' issues.
• Implemented standard security on all Oracle, MS QL Server, Netezza Workload management to ensure the protection of data from both internal and external attacks by enabling monitoring.
• Architected numerous databases to handle thousands of transactions per minute without any latency using MS SQL Server log shipping, mirroring clustering, Oracle Data Guard, Netezza Backup strategies.
• Developed documentation that details Database standards, procedures, policies and service level agreements between different clients database team.

Enterprise Architect Role

• Accelerate the delivery of exiting services and Analytical products to market while meeting company's risk and cost reduction objectives
• Match up with business experts and architects to convert key strategic objectives in to governable and actionable designs and roadmap
• Draw existing and future vision enterprise architecture, containing traceability from IT and business strategies to recommended technologies
• Design and carry out proofs of concepts for vital enterprise capabilities, including building business case with benefits, costs, and efficiency measures
• Analyze technology and business challenges, suggest solutions and assess costs
• Artifacts are in Visio and moving these artifacts into Mega.
• Helped senior architects in developing existing and future systems architecture artifacts using Mega.
• Experience in defining the Razorsight's architecture, documenting architecture, reviewing architecture and working on blueprints, road maps information technology customers.
• Design and implement agile IT systems, streamlined business processes, and optimized operating frameworks aligned with their business strategies
• Experience in implementing business architecture, information architecture, IT Architecture and application blueprint to ensure that an accurate representation and documentation of Razorsight's application architecture and Seamlessly integrate your application assets and solutions into your existing IT architecture boost the productivity of IT system design projects
• Experience to understand and know content, link the metadata to do what if analysis, process reports around interfaces and information services
• Experience in creating mega artifacts for IT Architecture, Application Blueprint and IT portfolio management.
• Performed design and system analysis, requirements definitions, interface and data architectures, lifecycle cost estimation and analysis, and governance
• Assisted in analyzing legacy systems and applications to derive necessary business rules and functions from existing applications
• Worked with project leaders and five member team to establish guidelines and standards
• Razorsight equips a model-based framework for implementing architectures using the TOGAF 9.1 Architecture Development Method and tightly integrated with Enterprise Architect.
• Implement all phases of the TOGAF Architecture Development Method ADM
• Create visual models of As-Is and To-Be architecture
• Model all four TOGAF architecture domains: Business, Application, Data and Technology
• Productively document all TOGAF work Products

Data Scientist Role

• Experience in executing univariate to get descriptive statistics execute bivaraite to correlation analysis, to evaluate the relationship of each field with the target and execute multicollinearity to evaluate which fields are redundant using Netezza Analytical functions and Python scripts
• Execute data imputation namely mvmean, mvnull, mvnull, mvzero and transformation process namely mean, median, trend, log, cube standard deviation to generate statistical data.
• Experience in data modeling scoring using IBM SPSS and visualize results as a dash board using microstratgey
• Experience in Data m Mining, upload data, explore data, build and evaluate deploy model
• Experience in Predictive modeling which is used to predict customer loyalty, revenues and gross profits. Shrinkage Analytics is used to predict fraud. Predictive Analysis for Inventory management. Predict product uptake and trigger ordering/balancing much ahead in time. Marketing teams use segmentation to predict which group of customers will respond well to a promotion K-means, KNN, SVM etc. .
• Experience in Advance Predictive Analytic to encompass of variety of statistical technique from modeling, machine learning and data mining and analyze historical and current to make predictions about the future, unknown and events.
• Create Analytical churn, MS Clustering, Linear regression, Native Bayes, Decision tree, logical regression modeling scoring using IBM SPSS R and create Dashboard using Microstrategy

Confidential

Manage the support of multiple programs simultaneously for 4 different customers Corporation for National and Community Service CNCS , pension benefit guaranty corporation PBGC , New York City Health and Hospitals Corporation NYCHHC and US department of agriculture USDA .

• As primary point of contact, I organize, coordinate and drive action items to completion with each of my Customer. Focus Teams, excelling in quickly identifying areas of difficulty, developing and implementing solutions, and evaluating results. Maintain full accountability for overseeing all aspects of day-to-day program activities by applying strategic planning, leadership, communication, and project management skills toward consistently achieving critical deadlines and deliver program benefits. Manage a broad range of interdependent projects including software development lifecycle SDLC , policy procedures and Info Security implementations. Actively collaborate with the cross-functional teams and leaders on proposed solutions, resources, project scope and budget estimates.

Enterprise Architect Role

Responsible for the complete process of application design and operations, including systems analysis, maintenance, security and systems configuration

• Implemented server and services designs using UNIX, Linux, Windows, Sun, VMware ESX, Java, and Oracle standards infrastructure namely Oracle Application server, Web Logic, OID, and OAM followed exception process when alternative infrastructure was required. Provided Oracle, MS SQL Server, Netezza, Big data Hadoop solution to customers
• Presented application designs to engineers and management
• Asset, change request, and configuration management using ITIL processes in CMDB Remedy, Clear quest
• Experience in defining the USDA SharePoint architecture, documenting architecture, reviewing architecture and working on blueprints, road maps information technology customers
• Provide rough order of magnitude ROM estimates which include Software, hardware, licensing and labor costs. Planned Application, infrastructure and operations additions in large enterprise wide IT and Engineering data centers. Work with engineers on designing and deploying network element monitoring tools into field locations.

Confidential

Manage the content rich collection of secured Partnerweb web sites, sponsored and managed by various programs within FNCS. This is a collaboration site center, intended for information exchange with organization and individuals who conduct business directly with FNS or CNPP.

• Responsible for managing SharePoint FNS Partnerweb site and actively involved with all requirements gathering sessions with departmental SMEs and IT personnel to translate business requirements into functional requirements with both SharePoint and SQL Server.
• Used and Managed Team Foundation Server to do source control, work item tracking, Team Foundation Build, a team project Partner Web portal Web site, reporting, and project management capabilities Team heavily used C , .NET, ASP and Microsoft Visual Studio.
• Manage the Planed, Designed, configuring and installed activities of MOSS 2007 2010 server which has one Front end Server, Index server and separate Box for SQL 2008 R2.
• Make that SharePoint schedule Backup are happening daily

Big Data Architect Responsibilities

Validate the Installed and configured Hadoop MapReduce, HDFS, developed multiple MapReduce jobs in Java for data cleaning and preprocessing.

• Good understanding and related experience with Hadoop stack - internals, Hive, Pig and Map/Reduce
• Wrote MapReduce jobs to discover trends in data usage by users Involved in defining job flows
• Involved in managing and reviewing Hadoop log files Involved in running Hadoop streaming jobs to process terabytes of text data, Load and transform large sets of structured, semi structured and unstructured data
• Responsible to manage data coming from different sources
• Supported Map Reduce Programs those are running on the cluster
• Involved in loading data from UNIX file system to HDFS and Installed and configured Hive and also written Hive QL scripts.
• Responsible to manage data coming from different sources
• Involved in creating Hive tables, loading with data and writing hive queries which will run internally in map reduce way. Installed and configured Pig and also written Pig Latin scripts.
• Implemented Partitioning, Dynamic Partitions, Buckets in HIVE.
• Monitor System health and logs and respond accordingly to any warning or failure conditions.
• Created SharePoint all the environments Development, Testing, Staging and production on AWS cloud.
• Deployed portal on Amazon web services AWS Cloud .
• Strong RDBMS concepts and well experience in creating database objects like Tables, Views, Sequences, triggers, etc. taking the Performance and Reusability into consideration.
• Possess strong Conceptual and Logical Data Modeling skills, has experience with requirements gathering, creating data mapping documents, writing functional specifications, queries.
• Managing and supporting databases including Oracle, MS SQL Server, Netezza, and Big data Hadoop
• Strong Experience in T-SQL programming and PL/SQL.
• Created/maintained/modified database design document with detailed description of logical entities and physical tables.
• Extensive experience in writing functional specifications, translating business requirements to technical specifications, created/maintained/modified database design document with detailed description of logical entities and physical tables. Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling

Confidential

Validate and support SSO integration for Oracle BI presentation Services and Oracle BI Publisher

• Create policy domain for OBIEE, add resource, Analytics, create Authorization Rule to allow the users and add authorization access, Specify form bases authentication and assign authorization role.
• Install the Web Gate on the proxy server and configure the reverse Authorization Rule.
• Oracle Internet Directory serves as the central CNCS user repository for Oracle Identity Management, a component of Oracle Enterprise Fusion Middleware suite, simplifying user administration in the Oracle environment and providing a standards-based application directory for the heterogeneous enterprise.
• Oracle Internet Directory runs as a CNCS's five applications on an Oracle Database.

Program Manager

As a program manager in managing many CNCS projects that serves more than 5 million Americans, lead and manage e-Grant Classic/ESPAN, Staff portal, Member Portal, e-Grant Phase II and Grantee Portal application, State Data Warehouse project.

• Successfully implemented and transitioned to operations multiple deliverables toward organizational security and program benefits
• Responsible for running complex programs, projects, which includes handling critical tasks that are involved in design, development, reengineering, production support services and knowledge of CA Clarity Agile.
• Exhibited leadership and strategic planning in successfully leading a broad range of project managers, resources, time, cost, and quality for projects critical to consistently achieving goals and milestones.
• Facilitated weekly and monthly program/project status and governance/PMR meetings, maintained weekly dashboard, and integrate best practice tool and process for tracking action items, issues, risks and decisions.
• Train project management team in areas of financial management, stakeholder management, resource management, issue/risk management and other best practices to improve project team performance, increase the quality of deliverables and number of completed projects that meet success criteria
• Standardized processes and tools for the PMO, improving efficiency and harmonizing customer experience and ensure the project team adherence.
• Manage Oracle Data modernization project and persuaded the team to maintain data model for each application and affirm the data quality and standards are maintained.

Specialties: Waterfall Agile methodologies. ITIL PBOK standards and CMMI level 3 application development standards complaint. Audit using HP Fortify 360 tool.

Technologies: Oracle, Oracle Business Intelligence, Hadoop, HBase, Hive, MS SQL Server, SharePoint, Mega Architect tool, MarkLogic, IBM Netezza 6.0, Oracle Fusion Middleware, Weblogic, Node Manager, Java J2EE, Struts, OAM, OID, Oracle SSO

Confidential

Planned and managed all phases within a project's life cycle such as analysis, documentation, architect and design, development, testing, deployment and support for various JP Morgan Equity trading systems, Back End Database and other applications to support the critical management group.

• Ensured optimum performance of JP Morgan Chase Equity Discerning investors seek to partner with J.P. Morgan Asset Management for our broad array of research-driven equity strategies spanning the risk/return spectrum across styles, market capitalizations. To ensure that the best ideas are leveraged across our entire offering, we support multiple processes and strategies across U.S., international, global, regional and emerging markets to meet the full complement of our clients' investment needs during critical trading hours through monitoring and advising dedicated L2/L3 Database Application, Business Support personnel hired, mentored and evaluated teams of programmers and database analysts, and coordinated with offshore development and quality assurance.
• Successfully migrated legacy systems rescheduled new development projects and brought them back on track, with feasible release schedules, updated requirements and improved the relationships with the user community through mitigating user issues.
• Maintained senior management and customer expectations by prioritizing project contents and meeting project milestones.
• Oversaw relationships with other departments and third party vendors to track progress and coordinate multi-departmental releases.
• Resolved critical issues with the offshore team by encouraging organizational openness and trust. Documented all major GEM, Core Processing Systems for required internal and external audits.
• Managed IT's compliance with Sarbanes-Oxley requirements by preparing all departmental procedures, specifications and manuals according to Countrywide's FASTER methodology.
• Coordinated the setup and managed the maintenance of a comprehensive disaster recovery system and conducted annual DR drills for multiple critical database application Manage database and application migration using agile methodologies.
• Managed the development of various critical brokers and trading application products.
• Coordinated daily interaction and monitored progress between development team, several business units, QA teams, DBA team, release management team and several layers of support.
• Established coding standards, standardized procedures for releases, production testing guidelines and enforced source code control.
• Developed robust Windows-based Executive Information Systems that provided key performance indicators to support critical decision making.
• Migrated Sybase, oracle databases from Sun to Linux saved multimillion dollar and make sure that the legacy migration follows PMOK standards.
• Lead and directed technical staff of 19 to provide quality L2/L3 database development and production support, automated day to day database operations.
• Negotiated contracts, directed long-range planning, prepared and monitored database application upgrade database application projects using waterfall methodologies.

Specialties: Waterfall Agile methodologies, ITIL. Sun, J2EE, Weblogic, Linux, Oracle 11G RAC, ASM, Data Guard, Grid. Sybase ASE 15.7, Sybase Replication, MS SQL Server, DB2 UDB.

Confidential

Senior Technical database Project Manager, Database management lead in managing many projects using Waterfall, Agile methodologies. Solid record of accomplishment in profit generation through cost-effective and timely project management, crisis intervention and outstanding service to internal and external customers. Proficient in running all aspects of the waterfall and agile methodologies for Sybase/DB2/Oracle Business Intelligence/ MS SQL Server upgrades and SOX, ITGC remediation. Uniquely qualified with proven technical, analytical, negotiation and customer relations skills to optimize project value. Proven ability to communicate clearly with individuals, including project team members, other senior managers and clients to implement complex application and database projects.

Project Manager

Extensive project implementation experience in the MF, SF, ITGC LP and Ability to quickly adapt to different working environments and to understand complex technical concepts.

• Led project team in the successful development and integration of the HARP HAMP program. Coordinated and led team in adherence with the defined project phases using S/W Development from inception phase to implementation/post implementation phase.
• Created and defined project inception phase gate documents i.e. Vision and Scope SOW Document, Project Charter, High-level time lines and cost estimates, etc. for project owner stakeholder's review and sign-off.
• Led technical team in delivering various elaboration phase gate documents and other artifacts i.e. BRS, Functional Specs, Technical Specs, DB Changes, GUI Storyboards - applying screen access usability, Sequence Diagrams, DB Design, SQLs, etc. For review and sign-off prior to development.
• Managed and coordinated the technical team and business user relative configuration and functional changes that impact the project timelines.
• Managed teams of developers, business analyst, DA, DBAs and quality assurance experts working on multiple projects.
• Project included web-based front-end, Mortgage system and interfaces to DB2, Sybase, Oracle, SQL server back-end.
• Created project plans, business and test cases. Reviewed and created project documentation and prioritized new features, bug fixes and subsequent task assignment.
• Led the development of test cases, scenarios, data used in the execution of testing QAT UAT .
• Managed performance testing SIT UAT to ensure apps response time are within expected level including fine tuning of SQL and stored procedures . Led the preparation of user and system operating manuals describing the new functional changes/enhancement and procedures.
• Lead Multifamily MF Single Family SF project implementations which includes MF/SF Origination and Underwriting System OUS : This initiative will modernize our infrastructure by merging no-longer-supported technology and multiple off-line spreadsheets into one unified origination and underwriting platform and we will capture all the data necessary to properly source assets. The new system will also better reflect the mortgage products and transaction options in the current marketplace.
• Negotiated contracts, directed long-range planning, prepared and monitored budgets up to 20M.
• Handled Loan Prospector LP project implementations which includes risk assessment tool that gives you ready access to Freddie Mac's credit and pricing terms, making it easier. LP helps you provide more borrowers with the lowest-cost financing available. With our continuous many application enhancements, external users can count on LP to give you easy access to the latest technology. Using statistical models, credit data from the national credit repositories and the loan application data details a mortgage originator supplies, LP assesses the Three C's Credit Reputation, Capacity and Collateral and the layers of risk to assist the originator in the originator's determination of a borrower's creditworthiness and the acceptability of the loan application.
• Send project status reporting to senior management and project stakeholders, including delivery of presentations, written reports, milestone updates and metrics reporting
• Identified and worked with developers, Database admin to address root cause of the issue, Developed processes around a new application, Setup many small releases and SDLC management process and Support operations along with resource management processes
• Manage support Multifamily Originate and Underwrite program to help Sellers originate loans for purchase by Freddie Mac as a part of our Program Plus, Seniors Housing and Targeted Affordable Housing networks of correspondent lenders.
• Leading all phases of diverse technology projects in Oracle Apps E-Business Suite 11i/R12 in Financials, Inventory, Account payable, Account receivable and Sub-ledger accounting modules
• Coordinate with various teams to complete gap analysis, requirements gathering, business requirements and functional and technical specifications documents for various projects in Invoice to Cash AR Finance group
• Interacted with business owners and other project stake holders to get business, functional, technical, performance and other gate reviews sign-offs required as part of project life cycle
• Identified infrastructure issues in ITGC infrastructure project in the database management domain and other application domain and has been remediated
• Manage Information technology change control project ITGC , Prepare project charter, conduct kick of meeting, Provide ITGC project Artifacts like proposed Architecture, Business Rule spreadsheet, Data profile questionnaire, prepare project management plan, plan the resources, management cost and determine the budget, send week status dash board report to Vice president and director, Track, Manage and reports project progress, Work with project sponsor director to negotiate the change in the ITGC project schedule and Revise or produce technical documentation and ensure quality and accuracy.

Confidential

Database Manager Architect

Managed development, operation, Analytical, data warehouse databases.

• Directed technical database staff of 50 to provide quality Data warehouse, Database support, reliable remote access support, regular data backup, and robust production support.
• Implemented firm's disaster recovery plan to ensure minimal productivity loss for many departments within Freddie Mac.
• Analyzed database development support and automated many data movement support task in many departments and improve client services and firm's visibility.
• Prepared RFPs for major technology database infrastructure build-outs and Oracle RAC/OBIEE implementation. Established targets for equipment lifecycles to maximize productive use of technology at all levels of the organization.
• Developed and implemented technology standards, reducing unnecessary complexity and realizing a savings of 1.1M annually on apps web server, other maintenance support costs.
• Superior communication skills, effortlessly interacts with executives, clients, vendors and staff. Responsible for planning, architecting, acquiring and administering the database infrastructure for different department customers as well as managing a staff of database professionals.
• Extremely hands on in all aspects of database administration, as well as managed a team of database administrators. Implemented ITGX SOX standard security on all apps database servers to ensure the protection of data from both internal and external attacks
• Architected numerous apps to handle thousands of transactions per minute without any having any delay. Developed documentation that details implementation standards, procedures, policies and service level agreements between database application teams.
• Provide technical support to accommodate Section 508 compliance, including assessment support and remediation.
• Managed and supported technical Sybase, Oracle, DB2 UDB, Sybase IQ MS SQL Server database and Data warehouse operations.
• Supported many application development projects in Loan prospector, Single Family and Multifamily division and regularly take database backup and supported production database servers in Freddie Mac
• Automated day to day database operation and provide DR failover and failback functionality test of critical servers
• Implementation and production support of Oracle High Availability solutions for databases including RAC, Data Guard implementation, RMAN, Grid Control, and migrating existing databases to RAC environment
• Install upgrade many Oracle, Sybase, SQL Server and DB2 servers and provide 24 7 rotation production on call support
• Planned, organized, and controlled all development, production activities related to the administration modeling of Sybase Servers ASE, Replication Server. MS SQL Server, DB2 UDB.

Technologies: Oracle, MS SQL Server, Sybase ASE, Sybase Replication and DB2 UDB, Oracle E-Business R12, OBIEE, Hyperion.

Supported Division: Multifamily MF , Single Family SF , Loan Prospector, PSL, Loss mitigation Accounts and Finance departments in Freddie Mac, HARP HAMP

Confidential

My support is mainly concentrated for Lotus/IBM Finance/Sales applications using ASE databases DB2, Lead IT team namely Louts notes admin/Unix admin and developers and support Database tasks.

• Planning, organizing, and controlling of all activities related to the administering of Sybase ASE Servers and Replication Server. Performing system administration functions including installation and upgrading of Sybase SQL Servers ASE-11.5, 11.9.2,12.0 Replication Server-11.X, 12.0, performance fine tuning creation, backup, and recovery of databases
• Configuration of database devices system resources: Disk memory distribution, access permissions on servers, databases, and objects and the maintenance of data consistency, integrity and fixing database corruption.
• Allocate disk resources for optimal database and object storage, Provide server, and database and object access to end users. Analysis and specification based on interviews with problem space experts.
• Maintenance of Sybase IQ-12.0 Server i.e. Sales DSS system , Migration of data from legacy systems to Sybase RDBMS Enforced server, user, and database security, the granting and revoking of permissions and the management of the audit system.
• Tuning database objects: tables, indices, stored procedures, triggers. Generate physical data modeling using ER-WIN and Power Designer.
• Training entry-level DBA's on database administration and Transact-SQL on the organization's business practices. Program code development for event driven GUI, interaction with RDBMS and adherence to pertinent business rules. Application implementation using a variety of integrated development environment.
• Back up of databases and transaction logs and recover them after a server or a media failure. Provide ongoing maintenance and management of a server and Installation configuration of DB2 UDB Migrated ASE to DB2 UDB

Technologies: Sybase ASE, Sybase Replication, DB2 UDB and Lotus

Confidential

Credit Operating System: This System automates credit operations of the banking system. COS Sybase based system takes data from the FASTRACK Lotus Notes based system and does some processing and puts the information into the different IBM Mainframes. It deals with banking functions like Overdraft, Loans, Import /Export and Foreign Exchange. My role is to generate Logical/Physical model suing ER-Win generate database DDL reverse Engineering scripts. Performing system administration functions including installation and upgrading of Sybase SQL Servers performance fine tuning creation, backup, and recovery of databases configuration of database devices system resources. Technologies: ER-win, Sybase SQL and Power Builder.

Confidential

My Responsibilities included Systems Analysis, design, coding, testing, database maintenance and documentation of complete system which caters from Student admission, Time Table Tracking, Examination set-up ,Vocational training program , Account Payable System and Payroll.

Technologies: Sybase SQL Server, Win NT, VAX/VMS, HENCO-INFO

Confidential

Automated hospital system from generation of entry token to billing and payroll. Re-engineered Inventory control, Product data control, Purchase Order, Job scheduling/Costing, Material Management and Master scheduling modules of MIS system of manufacturing industry developed in COBOL on VAX Platform. Put record structures under a Common dictionary using CDD data dictionary utility and screens for entry programs and maintenance programs using DEC forms utility. For better management of data VAX RDB is used, which provides better data security and integrity.

Technologies: VB3.0, Oracle, Win3.1, NT VAX/VMS 4100, Power Builder-3.0, Dec - Rdb, Dec - Forms, VAX - COBOL

Confidential

Involved in design, development and testing of multiple projects like Payroll for leading distillery company, Smart Trader to automate tracking investment and disinvestment of shares and accounting of payments. Implemented Portfolio Management system that keeps account of their shares and debentures traded in BSE and NSE exchanges, monitor price movements, planners and investment returns. Built a Financial accounting system for a finance company to maintain all transactions and generate statement of account with just a few clicks.

Technologies: VB3.0, Oracle, Access, HCL AT-486 , VAX4100, Fox-pro

Confidential

Real Estate management System: Analyzed, designed and developed modules handling store cost statement and stock control statement. Generated graphs depicting periodic production of products, stock level of material and periodic stock analysis, Reorder level and Stock analysis report.