Bi Lead Solution Architect Resume
Bellevue, WA
SUMMARY:
- Around 8+ years of experience in IT industry, Business Intelligence, Reporting, Data Architect, Data Warehousing, Data Analysis, Design, Development, Implementation, OLAP and testing Data Warehousing Applications.
- Designed and implementing effective technical business solutions. Advanced levels of technical knowledge combined with sound business vision and project management skills. Exceptional problem solving and written and verbal communication skills.
- A well experienced consultant in Business Intelligence working with multiple cross functional groups Business and IT.
- Well versed in Normalization/De - normalization techniques for optimum performance in relational and dimensional database environments.
- Experienced leader with strong business and technical with effectively manage cross-functional teams in delivering high-impact solutions in the areas of enterprise planning, Data warehousing business intelligence and ERP systems.
- Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
- Efficient in Dimensional Data Modeling for Data Mart design, identifying Facts and Dimensions, creation of cubes.
- Experience leader with solid understanding ofrelational and dimensional databases.
- Ability to communicate across diverse audience of business analysts, architects, business users and technical project staff.
- Conceptual, logical modeling and physical database design for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems.
- Experience in providing motivation, guidance and an up to date consultancy service to both colleagues and clients and capable with an ability to identify and then deal with a client’s needs by translating them into appropriate technical solution.
- Extensive knowledge on visualization of data and knowledge of tools such as Erwin and ER studio.
- Good command in modeling using case tools like Erwin, ER Studio, Oracle Designer, Power Designer.
- Expertise in writing Simple, Complex Ad hoc queries and fine-tuning the queries.
- Developed Database Design, Data Modeling experience using Dimensional Data modeling, Star Schema/Snow flake schema, Fact & Dimensions tables, Physical & logical data modeling, Erwin Data Modeler with data source/Data Extracted from various sources like Teradata, Oracle, Flat files, SQL Server and MS access.
- Good Knowledge in extraction, transformation and loading (ETL) process. Good Experience on Oracle RDBMS and its tools SQL, PL/SQL, SQL Loader, SQL PLUS, ERWIN and TOAD.
- Excellent communication, presentation, and organizational skills.
- Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
- Good amount of experience in PL/SQL programming: Stored Procedures, Functions, Packages, Triggers, performance tuning and optimization.
- Excellent analytical, communication skills with clear understanding of business process flow, SDLC life cycle and facilitated JAD sessions.
TECHNICAL SKILLS:
Database: Oracle 11i/10g/9iC, MS SQL Server 2008/2005/2000 , Access 2007/2003/2000 , Sybase, Db2, Teradata.
Languages: C, C+ +, Visual Basic 6.0, SQL, PL/SQL, Shell Scripting, C, Java, HTML, XML, SAS
Data Modeling Tools: Erwin, Oracle Designer 2000, Sybase Power Designer, BPwin, Rational Rose, MS Visio, ER Studio
Other Tools: BO Data Integrator XI 3.0, Business Objects XI Release 3.1/3.0/XI, Data stage Enterprise Edition, Oracle Warehouse Builder, Microsoft DTS Services, Oracle SQL* Loader, Live Office, MS Access, MS Excel, Informatica Power Center 6.0/Power Mart 6.0, DB2 Warehouse Center
Operating Systems: Windows, LINUX, Apache/Tomcat
PROFESSIONAL EXPERIENCE:
Confidential, Bellevue, WA
BI Lead Solution Architect
Responsibilities:
- Translate business requirements and models into feasible and acceptable data warehouse designs.
- Design and build appropriate data repositories and data movements (dimensional databases) to ensure that business needs are met.
- Create database models which serve as blue prints for project engagements of all complexities.
- Experience modeling data in either for OLTP or Data Warehousing environments (if possible both) including conceptual, logical and physical models.
- Gathering of Data, Business Rules, transformation rules and statistical models supporting campaign identification and suppression target populations.
- Translate enterprise or business requirements into long-term data architecture solutions including conceptual, logical and physical models.
- Design and review logical and physical data models for OLTP and OLAP in compliance with corporate standards.
- Work with IT ETL and Report Developers to communicate database designs.
- Responsible for design, build, and maintenance of data architectures for complex, highly visible business intelligence and analytic solutions that are both flexible and scalable.
- Design and oversees the implementation of data transformation and change processing procedures to ensure thatdatafrom multiple sources is aggregated, normalized and updated and then published to multiple target environments.
- Involve in the creation of naming standards file.
- Involve in the creation of data mapping documents.
- Involve in migrating the project related tables from one environment to the other.
- Document all technical requirements and design technical solutions utilizing enterprise architecture standards including documenting all solution components and configurations.
- Interact with developers, project managers and focus groups to minimize expenditure, avoid redundancy, and improve overall synergy within organization.
- Translate business requirements into detailed architectures and designs.
- Implement architectural designs while building solid relationships with stakeholders at all levels.
- Work with functional analysts, developers and development managers to ensure that all solutions are deployed within agreed timelines and supported after delivery.
- Identify where exceptions to the enterprise architecture standards are required.
- Provide technical, solution development, and project management expertise to various projects throughout the firm.
- Develop reusable assets such as solution architectures, both physical and logical.
- Create solution architecture and planned the development effort.
- Lead and mentor the project team from both technical and functional perspectives including database development, data architecture, integration development, requirements identifications, testing, and project management.
- Create and review Data Warehousing Solution architecture & design.
- Work extensively on all phases of the project development life cycle of system analysis, design, development, testing and implementation.
- Analyze data for Marketing, Accounting, Finance, and Supply Chain teams.
- Create architecture solution designs and documentation to drive high-quality and feasible implementations.
- Create and manage Work Back Schedule (WBS) of Business intelligence teams.
- Responsibilities included but not limit to, interaction and gathering functional requirements from Business users.
- Define and clarify solution scope and objectives through research and analysis.
- Provide solutions that effectively meet the performance, extensibility, integration, capacity, and accessibility needs of applications.
- Responsible for transforming requirements into architecture and design documents that was used by the team to implement solutions.
- Develop effective standards, best practices, procedures and key metrics to enhance operational stability of the tools supported.
Environment: Erwin, ER Studio, MS Office Suite Applications, MS Visio, Business Objects XIR2, Teradata, Oracle, Toad, Teradata SQL Assistant, Data Warehouse, SDLC, Informatica, Proactive Monitoring, RTAM, Rule Point
Confidential, Richfield, MN
Lead Data Architect
Responsibilities:
- Interacted with clients while designing internal and externaldata interfaces to ensure that database development needs are according to client specifications.
- Coordinated with clients, external data providers, and business team to ensure that business model is accurately represented and understood by all relevant parties.
- Created/maintained the Enterprise Business Intelligence data architecture to increase the robustness, performance, and scalability of systems.
- Responsible for the development of logical data models and physical database designs applied across multiple computing environments.
- Logical and physical data models with data modeling tool such as Erwin, coordinating updates and enhancements with the application development teams.
- Documented the business definitions for the entities and attributes.
- Communicated and syndicated business entity model with key IT and business stakeholders.
- Data Profiling and Analysis.
- Architect and designed data virtualization and abstraction solutions.
- Used business requirements to document clear and concise technical database and ETL design.
- Maintained design and naming standards.
- Created DDL, View SQL, and contribute to performance tuning.
- Contributed to project planning discussions, provide status updates for development progress and be a critical resource for issue resolution.
- Collaborated with report builders on design for optimum performance.
- Organized and lead teams to develop and refine conceptual data information models.
- Extended conceptual models with business rules to develop logical data models.
- Developed analytical models using statistical analysis tools, datamining, and other tools to create high-level data architecture diagrams documenting system anddata flows.
- Provided guidance and support in the development of information value chain analysis,dataquality metrics and metadata capture.
- Evaluated alternatives for integrating legacy data sources with enterprise relational models and strategies for transactional and analytical systems to effectively sharedata.
- Gathered and translated business requirements into detailed, production-level specifications, new features, and enhancements to existing technical business functionality.
- Created databases, tables, views & schemas. Performed users access authorization, defined locations, populated tables with data and performed unload/copy/replicate data from one database into another after detail analysis and design.
- Prepared High Level Logical Data Models and BRDs (Business Requirement Documents), supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
- Designed different type of STAR schemas like detailed data marts and Plan data marts, Monthly Summary data marts, Inventory data marts using Erwin with various Dimensions Like Time, Services, Customers, Sales Hierarchy, Orders and various FACT Tables.
- Conducted JAD sessions with management, SME (Subject Matter Expertise), vendors, users and other stakeholders for open and pending issues to develop specifications.
- Worked with slowly changing dimensions (SCDs) in implementing custom SCD transformations.
Environment: Oracle 9i/10g, SQL, ERWIN, MS VISIO, Teradata, ODBC, MS Office Suite Applications,, Toad, Teradata SQL Assistant, Data Warehouse
Confidential, Reston, VA
Data Architect
Responsibilities:
- Established data standards and policies,datamodeling, systems architecture design, and migration system architectures to ensure access to and integrity ofdataassets.
- Analyzed changes in online transactional processing, business processes, and external information sources and recommends modifications, to improve quality of applications and meet additional requirements.
- Assisted development team in the design of new BI solutions.
- Worked with product owner and business users to understand and translate user stories and/or requirements into data models, analytics reports and scenario models
- Developed standards, process flows and tools that promote and facilitate the mapping of data sources, documenting interfaces and data movement across the enterprise
- Provided architectural solutions covering data structures, sourcing, integration, security, and retention
- Maintained data dictionaries and integration of systems through database design.
- Worked with Business Analysts and potentially business customers to verify requirements fordatawarehouse and resulting reports.
- Created design documentation for relational and dimensional data structures.
- Designed and implement data warehouse tables anddatamarts for consumption by report and ETL developers.
- Focused on the delivery of engagement results to the client, require involvement in several engagements simultaneously and the coordination of other resources involved in a specific project phase.
- Defined the strategy and roadmap for BI Analytics, Enterprise Data Warehouse tools, and future state reporting architectures to meet enterprise needs; research and educate on the use of BI platforms for strategic decision making.
- Evaluated, developed and identified specifications, best practices, integration and proper use of emerging technology as they relate to overall reporting architecture.
- Used MS VISIO for relational database design.
- Extensively used Star Schema Technologies in building and designing the Logical data model into Dimensional Models.
- Extensively used Ralph Kimball Methodology in designing the Datamart’s.
- Performance tuning of the database, which includes indexes, and optimizing SQL statements, monitoring the server.
- Prepared excellent documentation in the MS developers understands the concept of the project.
Environment: Oracle 10g, 9i, SQL, PL/SQL, SQL*Plus, UNIX, Shell Scripting, ER/Studio, MS VISIO, SQL Server 2005, Teradata, Toad, Windows Server 2003.
Confidential
Jr. Data Architect/Analyst
Responsibilities:
- Coordinated activities of database analysts and other database personnel to determine appropriate database deployment strategies and parameters, to ensure cost effectiveness and system efficiency.
- Evaluated reusability of currentdatafor additional analysis, while maintaining integrity and confidentiality of information; conductsdata cleaning to rid the system of old, unused, or duplicate data for better management or quicker access.
- Developed data warehousing blueprints, evaluates hardware and software platforms, and integrates systems to ensure that integration is effective and meets client specifications.
- Defined governance and best practices around meta-data to ensure an integrated definition of data for enterprise information, and to ensure the accuracy, validity, reusability, and consistent definitions for common data.
- Performed modeling tasks associated with dimensional and relational models.
- Analyzed and Performance tuning of queries developed to access dimensional and relational models
- Designed and developed complex solutions for clients using specific technical expertise.
- Work included application development, infrastructure planning, and system integration activities.
- Established and maintain alignment of the data architecture to business strategy, goals and objectives.
- Lead the organization to develop enterprise-wide conceptual architecture and drive to the candidate architecture with an emphasis on BI analytics.
- Documented the business rules for various application specific databases by conducting interviews with the system owners and system users.
- Identified, evaluated, and recommended technical solutions within and across multiple systems to eliminate data redundancy, inaccuracies in data and performance issues.
- Developed, delivered and validated the logical and physical data models through collaboration with team leads, SMEs, business users, and other team members using Erwin 4.0.
Environment: Oracle 9i, UNIX, TOAD, Teradata, Toad, DB2, SQL, PL/SQL, Stored Procedures, MS Excel 2003