We provide IT Staff Augmentation Services!

Bi Developer / Team Lead Resume

SUMMARY:

  • 15+ year’s software development expert with strong track record of development experience, including 7 years designing and implementing data warehouses, data marts, and other business intelligence solutions throughout the business intelligence lifecycle.
  • Solid hands on experience with Data Warehousing tools, Data Analysis, Data Mapping, Unit Testing, Migration, Conversions, Problem Solving, and Process Documentation.
  • Expert in managing/leading ETL and Business Intelligence Testing for supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution using MS SQL Server.
  • Develop SSIS packages to extract data from flat files, SQL Server database and Excel to load to data warehouse. Some of the data flow transformations used include Data Conversion, Conditional Split, Lookup, Fuzzy Lookup, Slow Changing Dimension, OLE DB Command, Merge, Union All, Sort, Aggregate and more.
  • Experienced as SQL Data Analyst / Data Reporting Analyst with strong background in design, development, and support of online databases and information products as well as data analysis/ reporting/processing.
  • Experience in Dimensional Data Modeling using Star and Snow Flake Schema,SSRS Reports.
  • Strong Understanding of Database Concepts that can be used to configure the business layer and optimize to improve the performance.
  • Expertise in working with SQL queries and PL/SQL (Stored Procedures, Triggers, Packages/Functions).
  • Experience in delivering projects in a SOX compliant environment.
  • Competent in all aspects of Data Warehousing including project planning, requirement gathering, data modeling, development, deployment, maintenance, and enhancements.
  • Able to work collaboratively, quickly understand system architecture and business needs while committed to achieving corporate goals.

TECHNICAL SKILLS:

Operating Systems: Windows (NT, 95, 98, 2000, 2007), Windows XP, Windows 7, MS DOS

Databases: MS SQL Server 6.5/7/2000/2005/2008/2012, Oracle 8.1/9i/10g/6.0, MS Access

Query Tools: PL/SQL, Toad 7.4/8.3.6, SQL Query Analyzer, SQL Plus

ETL Tools: Microsoft SSIS

Modeling Tools: Star-Schema & Snowflake-FACT and Dimension Tables

Languages: VB Script, Java, JavaScript, C,HTML, Visual Basic, ASP, XML

Project Management tools: Microsoft Project Server.

Reporting Tools: MS SSRS, Crystal Report 6.0/7.0, Actuate 4.0/6.0/7.0

Others: Visual Source Safe, Heat, MKS Tool kit

PROFESSIONAL EXPERIENCE:

Confidential

BI Developer / Team Lead

Responsibilities:

  • Assisted the client in creating initial business requirements specification document for the reports of the Support Service Organization.
  • Analyzed the business requirement of the reports of the support service organization.
  • Involved with Design Process of data modeling to dimensional modeling of the business.
  • Created the mapping document to identify the report fields and corresponding Siebel fields using the Siebel tools.
  • Extracted Siebel booking, assets/entitlement, opportunity and service request data using ETL tool.
  • Extensive experience in developing SSIS packages to extract, transform and load (ETL) data from disparate data sources.
  • Transformed data from raw forms into structures as per the report requirement.
  • Execute, schedule, review, manage, audit and create dependencies among ETL requests.
  • Created executive reports using SSRS for management.
  • Involved in the fixing of the bugs and code changes and enhancements through client requests.
  • Technical Support to the Team and as well as Client.
  • Tuning of Jobs to improve the performance.
  • User testing and UAT sign off
  • Leading the team for assigning the work.
  • Involve in Coordinating between Client and development.
  • Production support of monitoring SSIS jobs.

Confidential

BI developer / Team Lead

Responsibilities:

  • Find/generate executive level support for the data warehouse initiative
  • Define key business drivers for the data warehouse initiative
  • Deliver a project scope that directly supports the key business drivers
  • Define the overall data warehouse architecture
  • Define technical requirements, technical and data architectures for the data warehouse
  • Design and develop the ETL process, including data quality and testing
  • Design and develop the information access and delivery effort for the data warehouse
  • Define and implement security requirements for the data warehouse
  • Define meta-data standards for the data warehouse
  • Define production release requirements
Confidential

Senior BI Developer

Responsibilities:

  • Design and develop SSIS packages, stored procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
  • Developed the database schema design using the Entity-Relationship model as per user requirements.
  • Conformed the database model to the rules of referential integrity and Normalization (3NF) in order to maintain its consistency.
  • In-depth understanding of processes involving data modeling and building data marts.
  • Participated in the development and maintenance of a Date Warehouse / Data Mart Routine Load Schedule.
  • Performed production support duties.
  • Involved in business requirements gathering to enable Data Integration across all business groups.
  • Created executive reports using SSRS for management.
  • Used complex SQL to query the database and was involved in SQL optimization of existing queries.

Confidential

Data Warehouse Developer

Responsibilities:

  • Used DTS migration wizard to convert DTS to SSIS packages and develop new SSIS packages.
  • Created trace in SQL profiler and used database engine tuning advisor for performance tuning on stored procedures and Scripts.
  • Analyzed old reports designed in crystal reports and transform those reports into SSRS report with proper mapping and error handing.
Confidential

Data Warehouse developer

Responsibilities:

  • Analyze daily basis any load failures and any data load failures in Booking, Billing, Backlog, Customer, Product, Shipment details to the Data Warehouse and then to Essbase System.
  • The jobs are invoked using Kornshell jobs and the loader program was written using Visual Basic. The daily verification excel sheet verifies the booking, billing, backlog daily basis between JD Edward and Data Warehouse.
  • Any out of balance issues requires analyzing and immediately fixing the issues.

Responsibilities: Support the Forecast Application.

Confidential

Data Warehouse Developer

Responsibilities:

  • Migration of Forecast application from Windows 95 environment to windows 2000 environment.
  • This project required to study the system and plan to move the ASP 3.0 developed application from windows 95 environment and IIS 4.0 to windows 2000 environment and IIS 6.0 and rewriting the reports by creating stored procedures and showing in excel.

Confidential, CA

Visual Basic Developer

Responsibilities: This Project involved writing stored procedures in PL/SQL having the business logic and developing all reports using crystal.

Environment: S/W-Visual Basic 5.0,O/S-Windows 95, Crystal Report 6.0,PL/SQL 2.0,ORACLE DATABASE 7.0

Confidential

Responsibilities:

  • C-LIS, Citation Laboratory system was developed on MS-DOS platform PL1 being the language and BETRIEVE as the Database.
  • This Project involves migration of C-LAB system from its Character based screen to more sophisticated Graphical User Interface.
  • As a GUI Developer, designed and developed GUI VB forms for different modules.

Environment: S/W- Visual Basic 5.0, O/S - Windows 95

Confidential, USA

Visual Basic Developer

Responsibilities:

  • This product is developed to Log the defects from different levels of testing of all in-house projects.
  • The features that the product included are creating new defects, assigning the defects to the responsible developers, Closing a defect and keeping track of status of all the defects. Analysis, design, development and test of the system.

Environment: S/W- Visual Basic 4.0, MS-Access, O/S-Windows 95

Confidential

Visual Basic Developer

Responsibilities:

  • This project is to integrate and automate finance, procurement, accounting, personnel and administration, purchase and sales department of a dairy farm. As a software Developer my responsibilities involved analysis, design, development and testing of procurement module.

Environment: S/W-Power Builder 4.0, O/S-Windows 95, Windows NT

Confidential

Visual Basic Developer

Responsibilities:

  • This project developed to monitor the weekly progress report of the employees.
  • The main module is to maintain user details.
  • The other functionality of the project was to review weekly assigned tasks and make changes to the plan and mostly record progress in terms of percentage.
  • Managers used it on daily and weekly basis to review completed tasks and assign more tasks and follow up on tasks to make sure the project is in proper time line.
  • This assisted the company in assessing the performance of the employee and also forecast the hiring requirement.
  • As a software developer my responsibilities included Analysis, design, development and testing of the application.

Environment: S/W-Power Builder 4.0, O/S-Windows 3.11

Hire Now