BI Developer INFORMATION TECHNOLOGY

More than 10Years of outstanding Business Intelligence development activities

Proven experience in successfully completing reports development projects, ensuring government compliance for privacy issues through system design. Has hands on experience in all stages of the SDLC including business process definitions, analysis, requirement gathering documenting, creating reporting data warehouses, star schema configuration, data profiling, data gap analysis, development of reports, testing, deployment of complex web-based BI intelligence reporting applications and training of end users. Has extensive hands-on experience in designing and developing databases and backend system support. U.S. Citizen.

Skilled in:

• Requirements Gathering
• Requirement Analysis
• Systems Analysis Design
• Logical/Physical Data Modeling
• Data Management
• Data extraction transformation and loading ETL
• Data profiling, data extraction and data maintenance through stored procedures and packages and job scheduling
• Business Intelligence OLAP Development
• Reports development
• Reporting Project Planning
• Management Reporting
• System Testing including user acceptance testing and debugging.
• User training
• CMMI Level 2 Process Improvements
• Client Relationship Management
• Work independently as well with across team members
• Has excellent analytical skills with effective and pragmatic problem solver
• Project management skills including time tracking and level of effort estimation and writing requirement documents and managing stakeholder expectations.

TECHNICAL COMPETENCIES

• Microsoft Project,
• Microsoft Office Tools Word, Excel, PowerPoint, Visio etc ,
• CMMI methodologies,
• Data modeling : ERWIN, Visio,
• Data base : Oracle 10g, Oracle Designer, Toad, SQL Server 2000//05/08
• Data ware housing tools: SQL server SSAS, SQL server TSQL query languages. Stored procedure, triggers and creating packages., SSRS reporting model .Micro strategy 8 , Business Objects 6.5 and Microsoft 2005 BI reporting and Cognos Impromptu
• Programming Languages: Oracle PL/SQL and SQL , Pro C, and Visual basic
• Reporting tool :, Microsoft SSRS , Crystal report s XI services, MIcrostratergy , Cognos and BUSINESS OBJECT 6.5
• ETL tool : SSIS Microsoft 2000/2005/8 and RI

CAREER ACCOMPLISHMENTS

Confidential

Senior BI Developer/ Short Term Contractor

Responsibilities include

• Design and Development of consolidated data warehouse for CDC/NIOSH program reporting, along with a business analytics and reporting capability. Data warehouse contains WTC Health Program, allowing for detailed analysis of program operations and health care delivery. Development of the data bases are created meeting compliance with HIPAA, patient privacy and information and security. Functional area : Health care
• Work within team to design system architectures, develop, and/or integrate information and communications systems to support client requirements and assure that present and future cross functional requirements are effectively integrated into solutions Interface with client technical personnel and perform other duties as assigned
• Conduct data mapping, design, develop, and implement extract / transform / load processes using custom ETL based on SSIS technology.
• Adhere to all development standards and protocols including Change Management, code review, documentation, and testing Educate and advise internal customers on how to leverage available data for consumption
• Assist in the documentation and cataloging of developed software
• Write SQL server stored procedures and create / maintain SQL Server Development Database objects in the data warehousing environment
• Create SSIS packages execute unit test plans based on written specifications.
• Develop ETL implementation scripts to move packages to development to production environment .
• Schedule job to render ETL packages using SQL server Agent .
• Write ETL related design document for knowledge transfer and requirement trace ability
• Following the SDLC process and PM principles implement deliverables and work with other team members to share resources and knowledge.
• Create and test report queries for entire WTC Health Program to be implemented in the reporting tool namely Micro Strategy tools meeting business rules.

Confidential

Contractor

Responsibilities Include Creating new crystal reports using user requirement , testing and implementing in business object reporting portal maintaining back-ups in clear case Documenting Technical detail like report data requirement with data base fields and conditions.

Confidential

Sr BI developer /ETL developer/ LBI Reports developer

• Responsible for creating data warehouse environment using SQL server 2000 and 2005 SSIS ETLs pointing to various data bases like Oralce 10g P/L SQL and SQL as data transformation queries , AS400, db2 SQL as transformation queries , Excel or Microsoft access
• Responsible for developing business centric reports, dashboards, data requests, metrics, and other tools using the Lawson Business Intelligence framework. Represent IT, HR and Finance department in fostering and developing relationships with other business units requesting business intelligence services.
• Generate and maintain control documentation of reporting procedures to comply with governance audits and regulatory requirements. Document data Management processes and procedures and provide input to the creation of data definitions, business rules and data access methods
• Design, develop, code and write stored procedures and functions using SQL server reporting capabilities on the Microsoft platform toolset along with Crystal reports XI Used all functionality of crystal reports using labels, templates letters and dashboard features
• Implement schedule and maintain published reports in Lawson web-sphere platform.
• Being a part of a Project team facilitated the launching of Lawson production system upgrades. This involved implementing successfully about 200 reports for HR and Finance and payroll related reports into the production environment. .
• Document data Management processes and procedures and provide input to the creation of data definitions, business rules and data access methods

Confidential

Contractor

• Documentation on reporting project for library of congress
• Crystal reports development using XML tags and Oracle 10g data bases. PL SQL/SQL

Confidential

Sr. BI Analyst

• Responsible for developing business centric reports, dashboards, data requests, metrics, and other tools using the Microsoft Business Intelligence framework. Represent the department in fostering and developing relationships with other business units requesting business intelligence services. SSAS, SSIS and SSRS
• Serve the overall enterprise user community with an initial focus on the DELTEK based business office system s .
• Responsibilities include the creation of new and modification of existing reports based on Cognos Impromtu tool.
• Generate and maintain control documentation of reporting procedures to comply with governance audits and regulatory requirements.
• Design and development of a formal data warehouse, ETL tools and technology, and reporting capabilities on the Microsoft platform toolset using SSAS and SSIS and SSRS

Confidential

Senior Reports developer/Analyst

• Managed requirements gathering and analysis, led data management and testing modules for internal data warehousing projects.
• Developed/ designed data models using Visio and developed waterfall data bases and develop reconciliation and monthly reports using SQL server analysis tool SSRS and Excel for the clients Bank Of America
• Develop data extraction, wrote SQL queries, stored procedures and packages and manage data integrity for the data used in the reporting projects.
• Create reports pertaining to monthly reconciliation of accounts related issues for the accounting and finance departments and do reconciliation on banking transitions
• Do data extraction to meet yearly auditing needs. Example FAS91 compliance

Confidential

Sr. Technical Analyst / Consultant

• As the architect of the Business Intelligence project created projects, attributes, metrics, customs groups, consolidations, security filters, drill maps, prompts, filters, custom templates, hierarchies, transformations, auto styles, reports and documents -Expert in data warehousing and OLAP Reporting
• Hands-on experience with dimensional modeling and relational modeling and has worked with relational and multidimensional DBMS structures-Created automated reports and documents based on clients need.
• Worked in a team environment and lead a small team of developers. -Interact with clients to gather requirements and clarify issues and train end users.
• Designed policies and procedures using CMMI
• Other duties included bug fixes and creating or modify various reports created in different reporting tools like Business Objects, Crystal reports or Oracle reports along with PL SQL/SQL and Micro strategy.

Confidential

Lead Reports developer

• Managed reports development efforts out sourced to a 3rd country , for the multiple Avectra's clients
• Do analysis, requirements gathering, documentations, coding like stored procedures and packages , Query optimizing, testing, bug fixing, implementing reports to the web application using Crystal reports or SSIRS and SQL server 2005
• Project managing of the reporting projects. This would include providing time estimates for report requirements, managing the day-to-day activities of the team in the manager's absence, and handling more difficult report-related issues as they arise.
• Conduct Crystal Reports training for our clients' users in our training room
• Participating in the improvement of processes for requirements gathering and report estimates. Guided out client project managers toward retrieving better report specifications from our clients and made the development process more efficient.

Confidential

Programmer/ Analyst

• Write technical requirement document containing pseudo Code and design the logical and physical design of data base components and business object universes based on the customer operations team reporting needs.
• Help Optimization of queries and performance tuning to make the queries to run fast from tables with millions of records using PL/SQL codes.
• support Data warehouse team to analyze data and help with proactive data issue fixes and generate automated reports using Business object modules to generate daily, weekly and monthly reports of customers, sales, Usage, promotions data that are used by executives and several departments.
• Complete the user acceptance testing before pushing the reporting applications into production.
• Train the user community on using and refreshing the automated reports.
• Creating adhoc reports and automate reports as and when needed using BO 5

Confidential

Data analyst/Client Sprint:

• Defined requirements for the report from the company manager,
• Participated in team meetings and got involved in technical design/ planning of middle ware database to combine data from various sources.
• Developed reporting schema in oracle database using PL /SQL and created and implementing an application using Access and Visual basic.
• Performed data analysis by using statistical measures and created executive level reports and posted them to the company web site on time.
• Created Universes for the Business Object 4.0 using designer module and created many reports using various functionalities available in the Business Object tool like charts, pivot tables and Alerts
• Did statistical data analysis and the results were presented as power point presentation for the monthly executive meetings.
• Involved in the complete cycle of the designing implementing and maintaining of the automatic collection of statistical sample information about the effective and ineffective sites in the customer network.
• Provide data to the managers of the IP Dial Internal support team to facilitate and implement proactive fix actions