SUMMARY

• Data Analyst with 7 years of experience in Business and Data Analysis, and Geospatial Data Modeling
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, MSSQL ESRI ArcGIS 9.3.1, ArcView, ArcEditor, ArcInfo, SDE, SQL Server 2008
• Good Knowledge on ESRI extensions: Spatial Analyst, Advanced ArcView using Avenue, Network Analyst, Image Analyst, and Advanced ArcInfo using VBasic
• Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities
• Software Development Life Cycle (SDLC) experience including Requirements, Specifications Analysis/Design and Testing as per the Software Development Life Cycle
• Training &Technical Documentation, FTC - Created and compiled User Manual document for training all Users across Reliance Circle on important Business Requirement Application
• Provide desktop profiles, user training, and other special projects as required by Analyzing performance, enhancing effectiveness and efficiency of the department to achieve the results within the set parameters
• Good hands on experience in Aerial Triangulation, DEM,DTM creation& 3D Visualisation using Leica Photogrammetry Suit & ERDAS Imagine
• Experience in understanding Stored Procedures, Stored Functions, Database Triggers, and Packages using PL/SQL.
• Expertise in Data Warehousing concepts including Meta data and Data Marts
• Collection of GPS locations and way finding; conversion of GPS data into GIS format
• Experience in conducting Joint Application Development (JAD) sessions with end-users, Subject Matter Experts (SME’s), Development and QA teams.
• CMMI process awareness and adeherance for projects delivery using IBM Rational clearcase & clearquest
• Team lead skills encompassing user interviews, coordination with Tech Lead, DBA’s, Developers, QA/QC Analysts during the design phase.
• Interviewing Subject Matter Experts, asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business and technical people.

TECHNICAL SKILLS

Programming Skills: PHP/MySQL, CSS, HTML, JavaScript, jQuery, AJAX, XSLT, XML, json, jQuery, PL/SQL

Database: Oracle, MSSQL, MySQL, PostgreSQL, Mongo DB

Operating Systems and tools: UNIX, Linux, Windows, JIRA, Adobe Acrobat, SVN

Packages and OS: MS-Office, MS-DOS, Windows 9x/2000/XP, Powerpoint,Ms word,excel

Databases: Oracle 9i, PL/SOL SERVER,SQL SERVER,Python Scripting

GIS: ArcGIS 9.x/10.x (ArcInfo version; ArcMap, ArcCatalog, ArcToolbox; Model Builder; Spatial Analyst, 3D Analyst, Network Analyst, ArcInfo Workstation), ArcView 3.2a,ILWIS 3.0,ESRI Softwares including ArcGIS 9.1, ERDAS Imagine,AUTOCAD2012LPS8.7,Microstationv8,NetworkEngineer, Telcordia 4, VB MapOBJECTS, ArcSDE

Other Software: Clearcase and Clear Quest, UML,CMMI PROCESSES,ETLInformatica,CRYSTAL REPORTS

Imageries: QUICKBIRD & IKONOS,BING MAPS, Google Maps

PROFESSIONAL EXPERIENCE

Confidential, MD

Data Analyst

Responsibilities:

• Gathered requirements, analyzed and wrote the design documents.
• Providing End-user Training and documentation for customer reporting services.
• Attended JAD sessions and created reports for Budgeting, Finance and Project Management departments of arlington County.
• Participated in the Analysis, Design and Development Phases of report development, performance tuning and production rollout for every report of Information Technology Department.
• Coordinate system and datum transformations; data conversion including converting CAD data to GIS and vice versa
• Geodatabase creation from spatial and non-spatial data (such as legal documents) and spatial and attribute editing, heads-up digitizing; georeferencing; geocoding, cartographic design and map making for a variety of print and electronic formats, .kml creation for use with Google Earth
• Queried the databases, wrote test validation scripts and performed the System testing in PL/SQL .
• Worked with the developers during coding and while doing the remediation of the software.
• Worked with the users to do the User Acceptance Testing (UAT).
• Followed Agile Model to document all data mapping and transformation processes in the Functional Design documents based on the business requirements
• Analysis of the same using Network Analyst in ArcGIS -X
• Data upload to server after QC
• Designed and implemented report layouts according to reporting standards of the department.
• Owned the assigned reports, worked on them and updated the Report Development Scheduler for status on each report.
• Worked on exporting reports in multiple formats including MSSQL, MS Word, Excel, CSV and PDF.
• Worked with Technical Experts to Improve Report Performance and performed System testing.

Confidential, MD

Data Analyst

Responsibilities:

• Analyzed the historical documentation, supporting documentation, screen prints, e-mail conversations, presented business and wrote the business requirements document and got it electronically signed off from the stake holder
• Wrote the test cases and technical requirements and got them electronically signed off.
• Created accurate, visually appealing maps in electronic and print formats for presentations Crystal reports.
• Topology Creation, attribution, Data Mapping & Plotting of Layer Data, Versioning ArcGIS 9.3 Windows XP on HP PCs for the capture, maintenance, and analysis.
• Conversion and processing of analog land Elemantry school data into a digital environment utilizing ArcGIS 9.3
• Conducted GAP analysis so as to analyze the variance between the system capabilities and business requirements.
• Involved in defining the source to target data mappings, business rules, business and data definitions
• Created Report-Models for ad-hoc reporting and analysis.
• Document various Data Quality mapping document.
• Perform small enhancements (data cleansing/data quality).
• Worked on daily basis with the main frame team and lead data warehouse developers to evaluate impact on current implementation.
• Communicated with the third party vendor to do the programming.
• Upgraded the present application by adding new functionalities and adding new reports.
• Wrote regression test cases, did smoke testing with users.
• Coordinated (with business users, data base administrator, mainframe team and testing team) in mirror to production testing.
• Conducted User Acceptance testing (UAT) and worked with users and vendor who build the system.

Confidential

Data Analyst/Project Lead

Responsibilities:

• Business and Data Analysis, Data Profiling, Data Migration and provide these analysed data for application in form of Pie-charts,bar charts and maps.
• Partner with designers and developers to collaboratively enhance existing applications and build new solutions
• Actively involved in the user requirement study and prepared program specifications
• Developed front-end views, models and process controller in forms of maps using ArcGIS Suit (ArcMap, ArcCatalog, ArcToolbox; Model Builder; Spatial Analyst, 3D Analyst, Network Analyst)
• Wrote complex SQL queries to communicate with the Oracle database to retrieve data for dynamic web page content and update sales database records.
• Integrated GPS design, capture, post processing, and mapping of Fiber Connectivity for better sales.
• Collected GIS data (i.e. Building, Road, POIs, and Pin Boundary) through Juno ST Handheld (GPS).
• ETL development written in PL/SQL, Web page design and interface with SQL server 2008
• Sent requests (customer record lookup, customer record update, sales transaction, ACH reports, reprinting) in XML format through socket to hosts. The requests were processed and the response strings were sent back in socket.
• Routinely created .kml and .kmz files for staff to use with Google Earth and incorporated in PDA devices using intranet.
• Created Model Builder tools to automate routine tasks and Created map templates for monthly reports and worked with GIS Analyst to show the reports in PDA device to track Sales order .
• Conducted technical investigation of product issues raised by customers or other internal groups like QA or Support
• Worked on product enhancement requests to enhance product functionality

Network Engineer

Confidential

Responsibilities:

• Followed Waterfall Model to established formats and procedures, created new formats, as well as researched, created, edited technical and business data documents.
• Extensively used Network Engineer 4, TOAD & SQL queries for accessing and manipulating database systems
• Upgrading queries from SQL server .
• Analyzed Requirements and created Use Cases, Use Case Diagrams, Sequence Diagrams using Rose.
• Used Rational RequisitePro for Managing and Configuring the Requirement Analysis effort.
• Codification of Equipment INSIDE PLANT using Telcordia Network Engineer 4x
• Modeling of OSP (OutSide Plant) and ISP (InSide Plant) items up to port level.
• Configuration of Network Engineer 4x.
• In-side Plant engineering - Capturing site specific ISP data in NE for entire Reliance Telecom network.
• Outside Plant engineering- Capturing Backbone as well as city Access Optical Fiber Cable network data (including connectivity) for entire Reliance Telecom network.
• Used AUTOCAD 2012 for coversion of CAD file to GIS version
• Filter out required features from geo-Spatial Database through selection tool, join, relate, overlay tools using ESRI Suit
• Used sessions, workforce for running and loading the data from source to target data warehouse.
• Worked closely with QA and Developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs.
• Effectively implemented defect management process using IBM Rational ClearQuest.
• Involved in writing Manual Test Cases and Test Scripts for checking the application.
• Use Model Builder to create models for Outside Plant Items (OSP) such as Structures, Spans, Transmedia, Splice Closures and other associated items, and we can also create models for Inside Plant Items (ISP) items such as Equipment, Chassis, Plug-in (Cards), Port, etc. and can also create various configuration of Equipment.
• Developed Functional Specifications and Testing Requirements using Test Director to conform to user needs.
• Prepared User Training Manuals and successfully conducted user training sessions.

Confidential

Responsibilities:

• Planned and defined system requirements to Use Cases, Use Case Scenarios and Use Case Narratives using the UML methodologies.
• Created Use Case Diagrams, Activity Diagrams, and Sequence Diagrams using MS Visio.
• Topology and, MXD file creation using AcrGIS 9.3
• GIS map creation, digitizing, attributing spatial and tabular data, Creation of PGDB using Arc Catalog ArcToolbox
• Geometric Network creation using Geometric Network function and Analysis of the same using Network Analyst in ArcGIS 9.3
• Conducted a comprehensive use case analysis to determine key Fiber Optic abstractions such as loan underwriting,, borrowers-info from Fiber Duct, mortgage-payments etc, and their mapping for standard analysis.
• Identify different types of users (brokers, borrowers and loan officers such as ST& T,Bharati) .
• .kml creation for use with Google Earth; metadata creation and maintenance; spatial analysis including raster calculation and analysis using Google Maps, BING Maps, IKONOS & QuickBird Images analyze several important human engineering factors and guidelines and incorporated them into a design of a user interface using MS Visio
• Managed and coordinated the QA team to create the test approach and determine test needs, test environment, test data, resources and limitations.
• Provide 24 x 7 problem management support to the development team.
• Create various Data Mapping Repository documents as part of Metadata services (EMR)
• Downloaded and used external GIS data as well as in-house ArcSDE feature classes to create maps for use internally and with partners.
• Provide inputs to development team in performing extraction, transformation and load for data marts and data warehouses.
• Provide support in developing and maintaining ETL Informatica processes that extract data from multiple SOR’s residing on various technology platforms then transport the data to various delivery points such as data marts or data warehouses.
• Performed manual and automated tested related to the graphical user interface, functionality testing, security testing, and testing related to data sources.
• Tracked the progress of system testing, and provided a daily status report to the Test Manager.
• Used Test Director to house all test documentation and report/track all issues and defects.

Confidential

Business Analyst/Data Analyst

Responsibilities:

• Involved in the meeting with Business process owners, SME (subject matter experts) and Marketing Team for Requirements gathering in Definition Stage.
• Facilitated the Customer in defining the high-level Functional Requirements and needs.
• Gathered the Requirements, Develop Process Model and detailed Business Policies and modified the business requirement document.
• Utilized RUP to create use cases, activity, class diagrams and workflow process diagrams.
• Prepared the Prototype and mockup screens.
• Involved in the Data Movement between Systems and validated the Business Requirements.
• Wrote test cases based on test strategies.
• Involved in Functionality testing during the various phases of the development
• Verified the correlation between the UML diagrams and developed detailed diagrams
• Validated the system End-to-End Testing to meet the Approved Functional Requirements.
• Blueprinted technical and operational training manuals and led Power Point/Visio presentations for the development of financial and technical applications for the departmental user base and for audit purpose.
• Responsible for providing fiscal and economic solutions through financial modeling and cost basis analysis
• Lead an entire QA Team comprising of 5 senior QA testers. Managed their activities through daily and weekly status reports
• Hands-on QA Analyst, responsible for coordinating and performing functional testing.
• Analyzed team performance with the QA manager and implemented the changes if any w.r.t. raising the efficiency of the entire team.
• Conducted the Final Customer Acceptance Testing (UAT).
• Increased process efficiencies and reduced development cycle time across department by spearheading the implementation of the full lifecycle software development methodology.