SUMMARY

• 14 years of professional experience in Design, Development and Implementation of Data Warehousing applications with proficiency in Data Model, Transformation and Reports & Dashboards Design.
• Collaborate with stakeholders, including executive management, to gather technical requirements for DW and BI Solution.
• Providing technical and functional expertise in design & development of solutions architecture - data warehousing and BI reporting
• Design, develop and maintain data models for reporting and analyzing data related to business, compliance, contractual and ad hoc requirements
• Effectively articulated reasoning for data model design decisions and strategically incorporated team member feedback to produce the highest quality data models.
• Designed developed and implemented ETL to move the transaction data from SQL server to Oracle 12c database.
• Created and maintained data visualizations using BI & Visualization tools that educated, informed and engaged business partners on key metrics and performance measures.
• Evaluate, identify and define potential new areas and services to help drive strategic development of BI beneficial to the business
• Self-motivated and result oriented professional with excellent track record in both individual and team environments.
• Exceptional interpersonal communication and leadership skills with an ability to relate to client management and fellow team members.
• Monitor and present recommendations to improve processing efficiency.
• Conducted thorough review and coordinated with developer to identify issues and areas for improvement.
• Direct and supervise design and implementation of plans including scope of work, objectives, quality of deliverables and activities for DW BI projects
• Maintain, support and understand the enterprise Data warehouse system
• Comply with project life cycle methodology and adhere to IT control policies and guidelines
• Proficient in SQL/PLSQL querying and databases like Oracle, Microsoft SQL Server, and Teradata.
• Established data architecture and DWBI best practices, standards and data models.
• Exposure in implementing ETL transformation and aggregation using Informatica, Talend.
• Well versed with reporting & visualization tools like MicroStrategy, Tableau, Qlik Sense
• Proven ability in leveraging data analysis tools and techniques and extracting insights from data and drive resultant business action
• Strong written and verbal communication/presentation skills
• Excellent attention to detail and organizational skills
• Ability to work in a fast-paced environment and meet tight deadlines

PROFESSIONAL EXPERIENCE

Confidential

Project Manager / Architect

Responsibilities:

• Evaluates functional and technical business requirements; transforms those requirements into solutions that efficiently enable expected application, reporting and analytic capabilities to support strategic initiatives.
• Designed and Created databases, tables, and views. Developed data migration and data load scripts for moving data from legacy systems and loading into an Oracle 12c Db.
• Provided in-depth knowledge of business areas; defining business needs, test requirements, software functionality, training, knowledge share and architectural design of systems
• Maintained data dictionaries and integration of systems through database design
• Supported and mentored development project teams.
• Architect Dimensions & Measures, and developed perfect logical/physical models for reporting environment.
• Designed Intelligent cubes for performance considering Partition strategies, Archival and summarizations
• Optimized existing infrastructure with a focus on usability, performance, long-term usage, flexibility and standardization
• Design and develop holistic solutions to implement complex business logics and functional requirements by utilizing the full scale of ETL and reporting tools out of box functionality.
• Created distribution service subscriptions to burst and distribute reports for hundreds of users and reduced processing time by 80%

Environment: Talend 6.5.1, MicroStrategy 10.11, Oracle 12c, RTC & RLM

Confidential

Solution Architect/ Team Lead

Responsibilities:

• Responsible for gathering and refining requirements from the Business users.
• Converted the Data Warehouse models to comply with modeling and metadata standards by reverse engineering from databases.
• Designed Star Schema Data Models for Citi HR business area
• Designed Data Marts to support business intelligence applications, and Data Warehouse structures for high-volume data capture, scalability and manageability.
• Created and enforced architectural guidelines, database development standards and best practices.
• Involved in Dimensional Modeling by selecting the business process, declaring the grain, and choosing the dimensions and facts.
• Experience in setting up the BI system administration including installation and configuration, Metadata, configure the Intelligence server, creating users, user groups, security filters, roles, privileges, Access Control List and security roles.
• Created Report services with multi-layouts, multi-panels, widgets and formatted to support all export versions (Excel, PDF and Flash).
• Developed Dashboards & Scorecards in MicroStrategy using Widgets and Selectors for summary level reporting

Environment: PLSQL, Database Views, MicroStrategy 10.2, Business Objects, Oracle, URL API

Confidential

BI Architect

Responsibilities:

• Created a centralized Data Dictionary design and reviewed possible Data Warehouse models.
• Provided in-depth knowledge of business areas; defining business needs and plan architectural design of systems
• Involved in design/development life cycle including gathering requirements, user interaction and design and development
• Analyzed and enhanced standards and process of data modeling, metadata and reference data.
• Created several Schema objects and Public objects based on data model.
• Created Schema Objects like Facts, Attributes, derived tables and User Hierarchies Using Architect.
• Defined relationships between attributes in System Hierarchy. Also created User Hierarchies to suffice drilling & browsing needs.
• Built Complex Reports using advanced reporting functions like Level Metrics, Conditional Metrics and Transformation Metrics.
• Created cubes to improve the performance of reports and Report Services documents.
• Involved in training the end users with BI Tools
• Provided the initial support after project roll-out to the end users in Production.
• Used Enterprise Manager to create and produce statistic report to optimize the system.

Environment: MicroStrategy 9.4.1, Teradata.

Confidential

DW Senior Developer

Responsibilities:

• Gathering requirements from business users and translate to Technical Specifications
• Participated in providing the project estimates for development team efforts for the off shore as well as on-site
• Performed Impact Analysis of the changes done to the existing mappings and provided the feedback
• Wrote various technical documents, including Business Requirements, Functional and Technical Specifications, Data Flow and Process diagram
• Coordinated and monitored the project progress to ensure the timely flow and complete delivery of the project
• Integrated data quality plans as a part of ETL processes.
• Debugged existing ETL processes and did performance tuning to optimize the data load.
• Worked closely with developers to help them to define scope for ETL changes.

Environment: SSIS, SQL Server 2008 and Windows Server 2003

Confidential

Team Member

Responsibilities:

• Creating and Modifying Reports as per client requirements.
• Testing the modified Reports.
• Gaining more Project specific knowledge.
• Preparing the necessary documents like Analysis and Design Documents and Functional test cases.
• Created administrative tasks to distribute reports.
• Participant in client calls for status reporting.

Environment: MicroStrategy Desktop 8.x, Oracle 9i