We provide IT Staff Augmentation Services!

Principal Senior Data Analyst / Solution Architect Resume

SUMMARY:

  • 15 years experienced IT management professional, with extensive background in Enterprise level data warehouse/business intelligence projects.
  • A strong and consistent history of aligning information strategy to business strategy, capabilities and capacity.
  • Leading and motivating people and projects to successful, high value/high impact outcomes.
  • Combining business acumen with technical savvy as a thought leader innovating and implementing highly integrated, scalable information strategy and architecture, business intelligence, Data Integration/Data Migration, analysis & designed projects using proven and emerging technologies driving top line and bottom line impacts in health, governmental settings and financial.
  • Proven ability to direct technical and business teams, coordinate consultants, and manage programs and projects.
  • Rapid discovery of key issues underlying intractable problems. Inspires teams to strive relentlessly towards success.
  • Enjoys strategic collaboration, brainstorming, and mentoring.
  • Exceptional group analytical ability.
  • Strong advocate of openness, transparency, and accountability to balance strategic vision and pragmatic need.

WORK EXPERIENCE:

Principal Senior Data Analyst / Solution Architect

Confidential

Responsibilities:

  • Collaborated with multi - disciplinary teams to improve product quality by emphasizing defect prevention, data quality audits, and strong user acceptance testing.
  • Defined and recommended data management procedures and policies that ensure safe upkeep of the data
  • Work closely with customer's Senior Infrastructure Lead and service provider onshore and offshore extended teams, so see through execution of activities in support of specific set of infrastructure systems that are vital to the organization's daily business operations.
  • Developed, documented, and reported data quality goals and standards
  • Designed Data Quality & Analysis Template and processes
  • Used information analyzer to perform primary key, foreign key and cross domain analysis.
  • Establishes and executes the Data Quality Governance Framework, which includes end¬to¬end process and data quality framework for assessing decisions that ensure the suitability of data for its intended purpose.
  • Develops and executes data quality strategies in line with the organization s strategic plan and goals.
  • Works with executive leadership and establish data quality rules and definitions consistent with department and organizations strategies. creates an effective work environment by developing a common vision, setting clear objectives, expecting teamwork, recognizing outstanding
  • Performance, and maintaining open communications.
  • Develops staff through coaching, providing performance feedback, providing effective performance assessments, and establishing performance & development plans.
  • Consults on applications development staff and users on database solutions to business problems, data architectures, data base management system facilities and capabilities, and the operation and tuning of databases.
  • Provides advice and guidance to less experienced staff.
  • Work in multiple Data analyst platforms; interact with customers and management to provide insight and analysis for some of CTO (Chief Technology Office) database systems project.
  • Designed Several Quality using IBM Quality Stage to address data anomalies.
  • Lead team for Data Analysis, data integration and Data Migration projects.
  • Created upgrade plan to migrate all internal applications populating data marts and data warehouse to new version.
  • Implemented upgrade plan including testing of all production mappings, sessions, workflows.
  • Modified mappings, sessions, workflows as needed to get them to work as designed in upgraded environment.
  • Architected and developed multiple ETL jobs to load large and volumes of complex SIMAS I legacy data into SIMAS II data migration project.
  • Designed Source to Target (STM) mapping for Stage and Final Target Data migration.
  • Developed ETL processes to extract the source data and load it into the enterprise-wide data warehouse after cleansing, transforming and integrating.
  • Completed Data Quality analysis of the legacy SIMAS l database system for SIMAS II data migration project from Oracle 10g database, generated varieties kind of reports using IBM Information Analyzer, Oracl e Toad and SQL, and SQL plus.
  • Scheduled multiple ETL jobs to populate Facts and Dimension tables.
  • Successfully populated large volume of SIMAS II staging database using IBM Webshpere DataStage & Quality Stage, FastTrack, Analyzer, Workbench.
  • Develop, document, promulgate, and maintain data quali ty goals and standards. This includes overseeing the organization's data policies.
  • Identify areas for data quality improvement and help to resolve data quality problems through the appropriate choice of error detection and correction, process control and improvement, or process design strategies. This includes maintaining database dictionary repository, maintaining standards, and profiling data to discover anomalies.
  • Configured WebSphere resources like JDBC providers, JDBC data sources, connection pooling.
  • Successful implementations of Work Load Management (WLM) using clustering techniques.
  • Administering and monitoring tasks related to the support of Web Sphere Application Server (WAS) in Linux and Windows Environment.
  • On-call support (24x7), Monitoring and maintaining multiple Applications at Development.
  • Designed MQ Backup, recovery process, & clustering of Queue Managers.
  • Created and configured MQ Objects like Queue Managers, Remote Queues, Local Queues, and Queue Aliases.
  • Defined rules to evaluate data quality as well as assessment and measurement of accuracy, data integrity and development and documentation of the overall data quality assessment process.
  • Work closely with customer's Senior Infrastructure Lead and service provider onshore and offshore extended teams, so see through execution of activities in support of specific set of infrastructure systems that are vital to the organization's daily business operations.
  • Created reports for executives to show quality and quantitative trends to define key metrics
  • Worked with customers on their feedback, monitored and audited data processing
  • Managed the data processing team (6 - 5 people)
  • Work ed with customer business users and the software development team to identify, document and correct data quality issues.
  • Work ed with the software development team to ensure that data rules are being supported and properly maintained.
  • Identified areas for data quality improvement and help to resolve data quality problems through the appropriate choice of error detection and correction, process control and improvement, or process design strategies. This includes maintaining database dictionary repository, maintaining standards, and profiling data to discover anomalies.

Environment: DataStage 8.1,8.5, Oracle, 9i,10g, 11g, UNIX, TOAD, SQL Plus, IBM Inforsphere DataStage, QualityStage, Information Analyzer, IBM WorkBench, IBM FastTrack, Enterprise Architect, Data Architect, Discovery. Windows 2003, 2005, Linux. Middleware: WAS8.X, WebSphere MQ 11.3, WebLogic Web servers: Apache, IBM HTTP Webserver, Microsoft SSIS.

Sr. Data warehouse/ETL & Business Intelligence Consultant

Confidential

Responsibilities:

  • Designed, planned and architected the complex data migration and quality improvement
  • Component of a large business database. Managed team of consultants that developed the solution using Data Stage targeting an Oracle database.
  • Lead a team that implemented Data Quality processes for a large Data warehouse effort and then defined the best practice architecture and Standards for the Extraction, Transformation and Load (ETL) of data between operational systems.
  • Designed a technical solution architecture and incremental project approach to introduce
  • Structured data storage and reporting to an internal reporting team.
  • Designed and developed Several DataStage ETL Mappings to populate the data into dimensions and fact tables.
  • Developed Source Target mapping (STM) document indicating the source tables, columns, data types, transformation required, business rules, target tables, columns and data types.
  • Authored Instructions for Manual ETL processing control M Jobs manually and other routine O&M tasks.
  • Extensively participated in functional and technical meetings for designing the architecture of
  • ETL load process (mappings, sessions, workflows from source systems to staging to EDW).
  • Worked on performance tuning of the complex transformations, mappings, sessions and SQL
  • Queries to achieve faster data loads to the data warehouse.
  • Worked on designing and updating ETL Software Design Document (SWDD) and Data Load Processes.
  • Created Parameter files, defined mapping and Performed unit testing to detect defect in code.
  • Developed and documented all load processes for both initial load and incremental load into the Enterprise Data warehouse (EDW).
  • Evolve models to meet new and changing business requirement
  • Maintain data structures by employing data modeling techniques for performance management.
  • Implemented type I & II slowly changing dimensions tables and DataStage Jobs.
  • Maintains effective communication throughout the lifecycle with management and or Lead architect.
  • Ensures quality deliverables through unit testing, regression testing and other data quality processes.
  • Design and Implement data quality improvement processes.
  • As a member of the Data warehouse production support team, Perform O&M daily and
  • Biweekly Data load into production Operational data store (ODS) on multiple interfaces.
  • Fine - tuned existing tables (Dimensions, Facts) with indexes (Bitmap or Normal) for performance
  • Optimization. Identify columns for indexes for load time reduction.
  • Lead loader of data into pre-production (TEST) and Production environment.
  • Actively engage in design discussions for all Data warehouse, Business Intelligence and database Initiatives.
  • Tracked software customization, defects and issues via the use of SDLC.
  • Collaborating with DBA and Development teams for implementation of projects.
  • Work with fellow developers to optimize database and query performance.
  • Participates in data migration, conversion and implementation activities.
  • Designed various types of reports with Complex Formulas, Custom Functions, SQL ExpressionsParameters, Drill Down, Sub reports and Cross Tab reports using Business Objects
  • Manage objects, schedule reports within Business Objects Enterprise.
  • Maintain mapping logic for loading data into both Non & Integrated Data warehouse (NIDW& IDW).

Environment: DataStage 8.0, 8.1, Oracle, 9i,10g, 11g, Linux/UNIX, TOAD, SQL Plus, ClearQuest, Putty, SQL Server 2000/2005, Business Object Enterprise, Business Objects- Web-Intelligence.

Senior Data Analyst

Confidential

Responsibilities:

  • Gathered and analyzed the requirements of the in-house business users for the data warehousing from JAD sessions.
  • Created source to target mapping and job design documents from staging area to Data Warehouse.
  • Used DataStage Designer to create the table definitions for the CSV and flat files, import the table definitions into the repository, import and export the projects, release and package the jobs.
  • Developed ETL processes to extract the source data and load it into the enterprise-wide data warehouse after cleansing, transforming and integrating.
  • Developed job sequences to execute a set of jobs with restart ability, check points and implemented proper failure actions
  • Wrote several complex SQL queries to extensively test the ETL process.
  • Provided production support and performed enhancement on existing multiple projects.
  • Used DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions (on an ad hoc or scheduled basis).
  • Performed unit testing and system integration testing in dev and UAT environments.
  • Analysis of healthcare revenue life cycle (patient, clinical, facility, physician, ICD9, and claim data)
  • Monitor mainframe jobs
  • Alert appropriate customers/programmers of potential problems.
  • Report all job failures and other problems to Program Manager and assist with resolution.
  • Report and coordinate resolution of all problems in the absence of Program Manager.
  • Distribute customer daily reports
  • Maintain unique scheduling calendar
  • Update all documentation (SOPs, logs etc)
  • Provide statistics gathered from various sources
  • Coordinate Mainframe Batch Job Schedules
  • Change JCL (Job Control Language) as appropriate. The parameters that need changing include, but is not limited to: dates, tax, cost center types, & various data
  • Schedule & submit daily, weekly, monthly & annual batch systems & monitor jobs for multiple systems for completion & monitor expected results.
  • Verify job(s) set up and Networking accuracy (Control M )
  • Trouble shoots Control M issues.
  • Reconcile multiple transactions received from internal/external source(s) prior to loading them into the respective systems each night.
  • Analyzed Business intelligence roadmap by analyzing project deliverable requirements, conducting data analyses, application prototyping and meta data repository analysis, report generation, data analysis and data mining.
  • Responsible for technical requirements gathering and specifications from end users for multiple projects including data warehouse logical data models and data movement/transformation requirements between enterprise systems.
  • Collaborate with the Data Warehouse technical staff, project data modeler/DBAs and infrastructure staff for efficient method to load and present data to business users.
  • Participate in all aspects of the systems life cycle; analysis, design, coding, testing and implementation using the Cognos, ReportNet and Powerplay, Business Objects.
  • Administer and Provide production support for Business Intelligence Applications, training and performance monitoring.
  • Work with other team members to develop, document, and implement processes correcting deficiencies, improving reliability or increasing efficiency.

Environment: - IBM Information Server 8.1, IBM Information Analyzer 8.1 IBM Data Stage 8.1 (Designer, Manager, Director), Erwin 4.1, Windows XP, Unix Shell scripting, TOAD 8.1, Oracle 10g, MS SQL server, flat files, xml files, Autosys, cognos. Business objects, Oracle, MS SQL 2000, SQL Server 2000 DTS, Data Mirror, Oracle Warehouse Builder, Sharepoint, Cognos 8 Framework Manager, Cognos PowerPlay Transformer, ReportNet, Query Studio, Event Studio, Report Studio, Cognos Access Manager, Cognos Connection and Upfront, System Performance, COGNOS and Oracle performance, OEM, Business Objects, Mainframe, Remedy.

Senior Information Technology Specialist

Confidential

Responsibilities:

  • Devised and implemented Business Intelligence strategies including but not limited to Creating common definitions, assessing the organizations current situation, Created a plan for data storage, understanding what users need and considering all business intelligence components at hand.
  • Served as a Data Warehouse Architect in the enhancement and development of a Business Intelligence/Data warehouse application. Responsibilities included but not limited to conducting interviews with executives, senior managers, SME's, business analysts, and technical staff in capturing and understanding business requirements, and defining project scope; performed detail data analysis of both data elements requested by the end users and management.
  • Implemented Business Intelligence and Data warehouse roadmap including but not limited to vision and strategies, process mapping, methods and responsibilities, deliverables, measures and improvement, analysis, project planning in a phased project rollout method designed to ensure the success the overall project initiative.
  • Responsible for technical requirements gathering and specifications from end users for multiple projects including data warehouse logical data models and data movement/transformation requirements between enterprise systems.
  • Developing business Intelligence architecture and designs.
  • Interact with the Data Warehouse technical staff, project data modeler/DBAs and infrastructure staff to develop the most efficient method to load and present data to business users.
  • Participated in the design and development of both logical and physical data models.
  • Designed and developed cube architecture for drilling across multi - dimensional cubes analysis and down to detail for Business Intelligence and Data warehouse.
  • Defined database structure, standards and documentation for the organizations Electronic Health record Project (EHC).
  • Participate in all aspects of the Business Intelligence Application systems life cycle; analysis, design, coding, testing and implementation using the Cognos ReportNet and Powerplay, Business Objects.
  • Administer and Provide production support for the reporting and analytic environment including troubleshooting, new user setup, security, training, performance monitoring.
  • Work with other team members to develop, document, and implement processes correcting deficiencies, improving reliability or increasing efficiency.

IT Business Systems Analyst (Business Intelligence)

Confidential

Responsibilities:

  • Writing technical specifications using MS Visio and UML Tools
  • Develop process documentation and uses cases for process or system architecture, including process modeling and business requirement.
  • Gathering, analyzing, and documenting organizations business objectives and functional requirements.
  • Gathering technical specifications, requirement from clients, Enterprise Architecture understanding requirements to ensure a high quality solution is produced for Data warehouse Projects.
  • Performing problem analysis, identifying root causes, outlining resolution options and taking appropriate actions to resolve problems.
  • Managed project - including setting timelines and milestones, interacting with vendor, reporting on project status to business unit, authoring reports using Crystal Reports.
  • Work closely with business and technology groups to identify best methods for promoting/implementing new products and services.
  • Prepared best practices for Customer Relationship Management (CRM) projects. worked with end-users, subject-matter-experts, project personnel, and other relevant stakeholders to identify and design processes as well as ensure a smooth deployment of the final application; assist with transitioning the system into operation mode, including configurations, analysis of data conversions, testing, and other related activities.

Hire Now