SUMMARY

Dynamic result oriented Database Developer with extensive experience of Software Development Life Cycle SDLC , Business Analytics and Database concepts. Proven track record in providing Data, Systems and Business solutions. Good Interpersonal, organizational and communication skills. Ability to multi task across departments with all levels of management.

TECHNICAL SKILLS

• Programming: Coldfusion, PL/SQL, SQL, JavaScript, HTML,.NET,Visual Basic,XML
• Databases: Oracle 10G/11G, MySQL, SQL Server 2012, MS Access,LDAP ,Teradata.
• BI Tools: Tableau8.2,Cognos 10.2, Micro Strategies, Dashboards, SSAS, SSRS,OBIEE
• ETL: Informatica PowerCenter 9.2, Erwin, SSIS,Netezza
• Operating Systems: WINDOWS XP, WINDOWS 8, VM Ware, Unix, Linux
• Other: Aqua Data Studio,Toad, Sharepoint, Visual Studio, Microsoft Office Suit, Navicat, MySQL Workbench, SQL Server Management Studio, AutoSys,DOORS,SQL Loader, Visio, Dreamweaver, ClearQuest.

PROFESSIONAL EXPERIENCE

Confidential

Systems Administrator

Involved in all phases of the from analysis, design, development, testing, implementation and maintenance. Extensively supported in making fact-based business decisions by developing Business Intelligence such as Dashboards, historic trends, network performance analysis, finance and budget forecast analysis.

• Collaborated with Project Managers, IT and users to determine requirements.
• Developed Business Intelligence using SSRS.
• Created Packages in SSIS and performed Import/Export.
• Revised and modified data models in changing business environment.
• Developed advanced, interactive Dashboards and data visuals using Tableau.
• Developed dimensional modeling using Star schema and Snowflake models.
• Extensively used Informatica PowerCenter to developed ETL programs for data extraction, transformations and loading.
• Created data mapping and performance tuning for sources and targets.
• Reviewed, validated requirements to translate into workable functional requirements.
• Developed multidimensional cubes to support ad-hoc report analysis.

Systems Administrator

As a member of Confidential Involved in design, development and testing of customer web portals. Developed web reports and analysis tools. Facilitated new customer provisioning by administering account creation process.

• Performed all levels of support for ColdFusion server.
• Scheduled recurring jobs on ColdFusion server.
• Export, Import and Migrate data between different Systems.
• Implemented security features to comply with Federal Government requirements.
• Developed PL/SQL procedures for ETL process.
• Added administrative features to enhance Redesign portal.
• Implemented billing functionality and data import features for Redesign portal.
• Ran automated comparison reports to ensure data consistency in various systems.
• Provided support on various web applications by troubleshooting day-to-day issues.
• Implemented ColdFusion graph features to show trending analysis.
• Created models in Cognos Frame Work Manager.
• Managed on-call responsibilities.

Network Engineer

Took an Initiative to automate technician Scorecards for Managed Data and Managed Voice departments. Developed Data Warehouse to integrate various data sources, which produced value added analysis on technician performance. Developed MNS 101 quizzes to evaluate technician skill levels at different geographic locations.

• Worked long hours with off-shore developers in China for value-added results.
• Updated MicroStrategy Dashboards to meet business requirements.
• Developed online quiz and survey tools using an external software, Articulate.
• Performed data mining to discover business trends.
• As a project owner analyzed, validated and defined requirements.
• Generated statistics for ACD Automated Call Distributor system.
• Created Macros in Excel to delete duplicates, search comments and for various other data manipulations.
• Developed SSRS reports by creating data snapshots.
• Developed data mappings using Informatica.
• Designed and developed database objects in Oracle and MySQL.
• Analyzed quiz results to identify skill levels.
• Developed and updated technical and end user documents.

Senior Analyst Technology

Confidential in determining reports/metric needs. Developed numerous reports that are instrumental in analyzing NOC Network Operation Center operations, Business trends and customer expectations.

• Designed and created relational databases to support automation of the reports.
• Generated numerous KPI reports to support operational stability.
• Automated recurring stats such as dailies, weeklies, monthlies.
• Coached teammates on generating reports using GUI tools.
• Developed Visual Basic forms to support tech administration process.
• Worked on logic changes to reflect database changes.
• Performed MYSQL database administration.
• Generated Ad-hoc reports using Micro Strategies, Crystal Reports.
• Developed user interface to manage technicians.
• Administrated document repository server WISDOM .

Technical Consultant

As a technical consultant obtained necessary knowledge on Managed Network systems and designed road map for manual reports automation. Automated reports include KPM Key Performance Measurements , Engineer and Tier stats.

• Researched the solutions for database caveats.
• Designed and developed user friendly reports.
• Wrote SQL and PL/SQL scripts to retrieve data for periodic and ad-hoc reports.
• Worked with users to understand the requirements, layout, and look and feel of the application to be developed.
• Setup development environment by installing required software.
• Wrote required documentation.

Confidential

Software Programmer

• Supported ETS Enhancement Tracking System applications by writing, updating and executing stored Procedures, Packages and Triggers. Developed TIMS Telco Inventory Management System , NAR National Activity Report and customer churn reports using Oracle Developer 2000 Suite Forms 5, Reports.3 . Created Indexes, Clusters to performance tune SQL transactions.