We provide IT Staff Augmentation Services!

Technical Lead/developer Resume

Lansing, MI

SUMMARY:

  • 14+ plus years of experience as BI DW Consultant experience in Development, operations and Maintenance of various Client/Server and applications in Finance, Telecom and health projects.
  • 10+yrs of experience in Business Intelligence Administration solutions using SAP Business Objects 4.BI,Universe Designer, Designer, SAP Information Design Too, Explorer, Design Studio, SAP Business Objects Dashboards 4.4.
  • Designed Complex Universes both in UDT and IDT
  • Managed Folder/Category structures for Report level and Universe Level within Business Objects.
  • Migrated reports from Business Objects 6.5 to Business Objects XI 3.1, BI 4.0/4.1/4.2.
  • Migrated from Universe design tool (UDT) to Information design tool (IDT).
  • Worked extensively to ensure proper scheduling times for all reports, including but not limited to reports sent to user inbox, and emails.
  • Worked with Admin Team Publication of Universe and Webi Reports to Production Environment.
  • Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
  • Worked extensively with (@select, @aggregate aware, @where, and @prompt) to overcome the problems with database when integrating with Business Objects
  • Performance tuned and optimized various complex SQL queries.
  • Create Executive Level Financial dashboards using Xcelsius2008, Sap Business Objects Dashboards
  • Created Static and dynamic Dashboards using SAP Business Objects Dashboards, QAAWS and live office.
  • Involved in Testing SAP BI 4.0/4.2 Upgrade, Designer and Dashboard.
  • Strong Understanding of Databases, VLDB Settings, SQL optimization techniques
  • Strong experience in designing and developing large scale and optimized Data Warehouses using Teradata
  • Experience in Logical and Physical Data Modelling and Dimensional modelling (Star and Snowflake) skills in Physical database design, Relational Models
  • Good exposure in Data Modelling for OLAP, OLTP, ODS and Data Mart or Data Warehouse for Financial Application
  • Data Warehousing ETL experience of using Teradata utilities (TPT, BTEQ, MLOAD, FAST LOAD and FAST EXPORT)
  • Strong expertise in database Creating independent DataMart and provide to different user for reporting according to their business requirement
  • Expertise in all phases of Software Development Life Cycle (SDLC). Very good insight of Waterfall / Agile project management methodology
  • Provided 24 hour pager/on - call support to production operations working at home on remote VPN.
  • Contributed to the new join repository by creating new process documents and instructions.
  • Experience in creating Adhoc-reporting ready universes using SAP Business Objects xi4.1 Universe Designer.
  • Experienced with mentoring Teradata Development teams, data modeling, program code development, test plan development, datasets creation, testing and result documentation, analyzing defects, bug fixing.
  • Data Warehousing ETL experience of using Teradata utilities (TPT, BTEQ, MLOAD, FAST LOAD and FAST EXPORT)

TECHNOLOGIES:

Databases: Teradata V2R5, V2R6, V2R13, V215, DB2, Oracle 10g, 11g.

SQL Tools: Teradata SQL Assistance 15.10, TOAD 12.8, SQL Developer, SQL*Loader.

Languages: SQL, PL/SQL, Java Script, Perl.

Reporting Tools: SAP Business Objects BI 4.2/ XI 3.1 R1/R2,6.5, Erwin r9.7, MS Visio, SAP Business Objects Dashboards/Xcelsius 2008

DBA /ETL Tools: Teradata Administrator, TASM, BTEQ, FastLoad, MultiLoad, Fast Export, Tpump, Teradata Statistics Wizard and Priority Scheduler, OEM, Teradata Utilities 15. Teradata viewpoint, Teradata Visual Explain, Teradata System Emulation Tool, Teradata SQL Assistant, Teradata Manager, PMON,SAP Power builder12.6, Erwin

Operating Systems: Windows XP/NT/2000/98/95, UNIX, Linux

Configuration Tools: IBM Rational Team Concert6.02,VSS 6.0, Clear case, Zillow.

PROFESSIONAL EXPERIENCE:

Confidential - Lansing, MI

Database/Utilities: Teradata V15, Teradata SQL Assistant, Teradata Utilities-TPTBTEQ, MLOAD, FAST LOAD and FAST EXPORT, Oracle 10g, 11g, Linux,WinSCP3, Toad 12.8.4, BMC Remedy IT Tools, and IBM Rational Team Concert.

Technical Lead/Developer

Responsibilities:

  • Performance tuned and optimized various complex SQL queries.
  • Designed Complex Universes both in UDT and IDT
  • Managed Folder/Category structures for Report level and Universe Level within Business Objects.
  • Migrated reports from Business Objects 6.5 to Business Objects XI 3.1, BI 4.0/4.1/4.2.
  • Migrated from Universe design tool (UDT) to Information design tool (IDT).
  • Worked extensively to ensure proper scheduling times for all reports, including but not limited to reports sent to user inbox, and emails.
  • Worked with Admin Team Publication of Universe and Webi Reports to Production Environment.
  • Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
  • Worked extensively with (@select, @aggregate aware, @where, and @prompt) to overcome the problems with database when integrating with Business Objects
  • Create Executive Level Financial dashboards using Xcelsius2008, Sap Business Objects Dashboards
  • Created Static and dynamic Dashboards using SAP Business Objects Dashboards, QAAWS and live office.
  • Involved in Testing SAP BI 4.0/4.2 Upgrade, Designer and Dashboard.
  • Domain expertise to provide best and optimized solution to customer
  • Strong Understanding of Databases, VLDB Settings, SQL optimization techniques
  • Strong experience in designing and developing large scale and optimized Data Warehouses using Teradata
  • Designed and implemented stored procedures for automating tasks through Linux batch job.
  • Customized and developed Database Stored Procedures, database mapping, Views Involved in database design/preparing to support the larger databases.
  • Creating day to day independent DataMart and provide to different user for reporting according to their business requirement
  • Expertise in creating databases, users, tables, triggers, macros, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database. Participated in JAD (Joint Application Development) Meetings, gathered requirements and supporting Analysts.
  • We process data from 23 different source systems using Teradata utilities (TPT, BTEQ, MLOAD, FAST LOAD and FAST EXPORT). Further data are used for SAP BO reporting and Ad-hoc reporting etc.
  • Designed and modeled many Data Marts as per business requirements. Developed ETL maps and shell scripts to clean and load data into Data mart
  • Developing and Supervised 5+ Programmers and Quality Analysts on Development task, overseeing all aspects of coding and testing.
  • Analyze source and target databases in DW environment, tables and create transformation rules to migrate the data from source to target system.
  • Writing complex Teradata SQL queries, Advance feature of Teradata 15, Dynamic SQL, Analytical functions, performance tuning of SQL queries and different scripts. Reduce turnaround time of different application from 24-36 hours to 10-15 minutes. Increased performance by 70-80% in some situations.
  • Coordinate discussions between leads, business analysts and ETL developers and help facilitate design and development to ensure requirements are fully coded, tested and implemented.
  • Successfully completed Data Modeling to upgrade existing system and created new scripts, table column mapping and ETL.
  • Use of all database administration tools to analyze system status/performance.
  • Daily stand up meeting for 15 minutes for status update.
  • Prepared FDD, TDD and UTP according to change control /request document.
  • Manage continuous improvement - Standard templates, Standard Coding guide lines for repeatable work, reusable queries/stored procedure and package, efficiency improvement ideas

Confidential - Richmond, VA

Technical Lead/Developer

Database/Utilities: Teradata V15, Teradata SQL Assistant, Teradata Utilities -TPT, BTEQ, MLOAD, FAST LOAD and FAST EXPORT, Oracle 10g, 11g, UNIX.ETL Process TPT and Linux environment,WinSCP3, Toad 12.8.4, BMC Remedy IT Tools, and Oracle 10g, SQL, PL/SQL, Oracle 10g

Responsibilities:

  • Direct interaction with Magellan global business customers, receiving feedback from users.
  • Created User Prompts, Conditions and Filters to improve the quality SQL tuning for performance improvement. Extensive Tuning of SQL Statements and PL/SQL Packages, Triggers, Functions Procedures using various optimization techniques.
  • Writing Complex SQL Queries, Dynamic SQL queries, Analytical function, Oracle Object etc.
  • Load data from different source systems using Teradata 13 utilities (TPT, BTEQ, MLOAD, FAST LOAD and FAST EXPORT).
  • Designed Complex Universes both in UDT and IDT
  • Managed Folder/Category structures for Report level and Universe Level within Business Objects.
  • Migrated reports from Business Objects 6.5 to Business Objects XI 3.1, BI 4.0/4.1/4.2.
  • Migrated from Universe design tool (UDT) to Information design tool (IDT).
  • Worked extensively to ensure proper scheduling times for all reports, including but not limited to reports sent to user inbox, and emails.
  • Worked with Admin Team Publication of Universe and Webi Reports to Production Environment.
  • Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
  • Worked extensively with (@select, @aggregate aware, @where, and @prompt) to overcome the problems with database when integrating with Business Objects
  • Migrated users, categories, groups, reports, folders, Universes, security models from SAP Business Objects XIR3 version to SAP Business Objects 4.X and fixed the issues during the migration and after migration.
  • Analyze source and target databases, tables and create transformation rules to migrate the data from source to target system.
  • Writing complex Teradata SQL queries, Advance analytical feature of Teradata 15, Analytical functions, performance tuning of SQL queries and different scripts.
  • Coordinate discussions between product leads, business analysts and ETL developers and help facilitate design and development to ensure requirements are fully coded, tested and implemented.
  • Successfully completed Data Modeling to upgrade existing system and created new scripts, table column mapping and ETL.
  • Data Load from Various sources like Main Frame, Flat File, Excel file usingExternal Table, SQL tuning for performance improvement. Extensive Tuning SQL Statements and PL/SQL Packages, Triggers, Functions and Procedures using various optimization techniques.
  • Writing Complex SQL Queries, Dynamic SQL queries, Analytical function, Oracle Object etc.

Confidential, Fremont CA

Technical Lead/Developer

Database, Tools &Utilities: Teradata V2R5, V2R6, V13Teradata SQL Assistant, Oracle 10g, UNIX, SSH secure shell, Teradata utilities-BTEQ, MLOAD, FASTLOAD and FAST EXPORT. Clear case, TWS, BO xi, Primavera P6, Microsoft Project2010. SAP Business objects XIR3.1,Deski,SAP Business objects Xcelsius, Universe Designer,SQL,PL/SQL,Oracle10g,11g,TOAD9.0

Responsibilities:

  • Direct interaction with Confidential ’s global business customers, receiving feedback and assign to appropriate team member. Allocate tasks to respective team members.
  • Ensure timesheets entry and completion of invoicing process on or before deadline.
  • Manage multiple project lifecycles from beginning to end Simultaneous. work in a lead role as a subject matter expert, within a team environment to meet aggressive goals and pre-defined measurement criteria
  • Creating SAP Business Objects Universe with number of Classes, many objects, Derived Tables using inner/outer and equiv. joins as per requirement.
  • Code Analysis and Optimization of SQL, PL/SQL code, SQL Tuning.
  • Analyze source and target databases, tables and create transformation rules to migrate the data from source to target system.
  • Created the SAP Business Objects 4.1 Web Intelligence Report and used Events for Daily/Weekly /Monthly Scheduling of the reports.
  • Developed testing scripts and test cases. Extensively tested SAP Business Objects reports, dashboards and other SAP Business Objects Applications in new environment.
  • Involved in performance testing of all the reports, which helped in analyzing its performance before moving into production.
  • Create mapping and migration analysis documents. For data migration writing and Unit testing the following scripts: Teradata Parallel Transporter- TPT, BTEQ, MLOAD, FAST LOAD and FAST EXPORT.
  • Load data from several flat files sources using Teradata utilities -TPT, BTEQ, MLOAD, FAST LOAD and FAST EXPORT.
  • Design and develop ETL jobs for running all the developed scripts.
  • Perform Unit Testing and promote scripts and the jobs to production.

Confidential

Technical Lead/Developer

Database and Tools: Oracle 10g, SQL, PL/SQL, Ad-hoc Query, SAP Business Objects 4x/6.5.1,UNIX, DWH,Abinitio1.15, Clear case3.0, PPM, Primavera P6 Analytics, Oracle Designer10g.Teradata V2R5, V2R6, V13Teradata SQL Assistant, Teradata utilities-BTEQ, MLOAD, FAST LOAD and FAST EXPORT.

Responsibilities:

  • Leading and managing team and monitor day to activity.
  • Direct interaction with IBM- Confidential global business customers, receiving feedback and assign to appropriate team member. Allocate tasks to respective team members.
  • Test Documents, SQL Coding, SQL Tuning, Extract the data from different source file excel CSV format and text loaded the required data in oracle data base, applying the complex business logic and excel formulae.
  • Design and Development of SAP Business Objects Universe's using Information Design Tool to drive Static and ad-hoc reports.
  • Implemented Event Based, Pdf Bookmark scheduling of Crystal, SAP Business Objects Web intelligence reports to a SharePoint location.
  • Created SAP Business Objects reports using IDT from more than one data source.
  • Migrated users, categories, groups, SAP Business Objects reports, folders, Universes, security models from SAP Business Objects XIR3version to Business Objects 4.0 and fixed the issues during the migration and after migration.
  • Extensive experience in developing static and dynamic dashboards using Xcelsius 2008 via the web service connectors like QAAWS, Live Office, XML.
  • Strong experience in T-SQL, Stored Procedures, Triggers.
  • Installed and configured all the three environments (DEV/QA/PROD) with Business Objects XIR2/XIR3.2with Apache and Tomcat as web and app servers on windows and UNIX servers.
  • Expertise in working with all the modules of SAP Business Objects (All Versions including XIR3) like Supervisor.
  • Create mapping and migration analysis documents. For data migration writing and Unit testing the following scripts: Teradata Parallel Transporter- TPT, BTEQ, MLOAD, FAST LOAD and FAST EXPORT.
  • Load data from several flat files sources using Teradata utilities (TPT, BTEQ, MLOAD, FAST LOAD and FAST EXPORT).
  • Reduction of revenue leakage from under billing of usage and usage analysis.
  • Reduction in churn through provision of churn analysis and predictive modeling.
  • Development of basic campaign list generation functionality.
  • Basic Profitability Analysis to identify customers who are profitable to based on their usage behavior.
  • Identify the target audience for a proposed tariff plan based on usage behavior of Subscriber.
  • Identify the Impact of a Tariff Plan based on change in usage behavior after the Tariff plan introduction.
  • Identify Target market of subscribers from analysis of the incoming.
  • CDR Reconciliation across Interconnect, Mediation and Billing.

Confidential

Technical Lead/Developer

Tools: SQL, PL/SQL, Oracle 10g, TOAD 9.0, MS EXCEL, Oraxcel, UNIX, BO xi.

Responsibilities:

  • Leading and managing team and monitor day to activity.
  • Direct interaction with Confidential customers. Getting Customer feedback and passing to appropriate team.
  • Test Documents, SQL Coding, Extract the data from different source file excel CSV format and text loaded the required data in oracle data base, applying the complex business logic and excel formulae.
  • Writing Queries as per business requirements Tune the query and help the users in rectifying the errors in the query, looking into users queries.
  • Ad-hoc query execution and generating different types Trending/MIS reports Guide the business users to understand the logic behind the SQL scripts, helping the users and make them understand their requirement, Running BO Reports as per user data requirements.
  • Analysis of the specifications provided by the clients, Design and Development, High Level and Detail Design document, delivering the deliverable as per project plan.
  • Preparation and reviewing of technical documents like RDD, MTP, DTP, Traceability Matrix and Test Summary report, Providing the technical assistance to team members.
  • Scheduling for team members.

Hire Now