SUMMARY:

• Over 14 years plus years’ experience in all stages of software development lifecycle (SDLC) requirement discussion, systems analysis, design, development, test and implementation of application software.
• Experienced in producing design documentation Confidential functional high and detailed low level for the entire integrated application environment.
• Experience of 10 yrs + in database design of relational database (tables/ views/ indexes etc.).
• Experience of 10 yrs + in optimization, performance tuning of back - end procedures, SQL’s/queries.
• MCP in “Implementing a Data Warehouse with Microsoft SQL Server 463)” (ETL/SSIS)
• MCP in Querying Microsoft SQL Server 461)
• Expertise in designing of database (process flow, ER Diagram, tables) through tools also such as Designer Release 2.0/ Visio.
• Database such as SQL Server, 2012 / Oracle 10g / 9i/8i/8.0.
• Development in TSQL, SQL. SQL, PL/SQL (8.1.6, 8.1.7) using tools such as Toad and PL/SQL Developer.
• Development in TSQL/SQL, tool SQL server Management Studio.
• SQL Server 2016 Analysis Service (Tabular), with Visual Studio 2015/ 2017 as a tool for cube development, DAX Studio, Vertipaq Analyzer for cube storage analysis, SQL Server 2012 Analysis Service (SSAS) SQL Server 2012 Integration Service(SSIS), SQL Server 2012 Reporting Service(SSRS)/ MS BI stack and Power BI, Excel, DAX, Power Pivot/Power View - 2015 till current.
• Developer 2000 (Forms 5.0/4.5, Reports 3.0/2.5)/ Developer 6i (Forms6i/Reports6i),
• Experience with version control using VSS and PVCS.

TECHNICAL SKILLS:

Systems: Windows NT 4.0, Windows 95, Windows 3.1, Windows XP, Windows 2000

Languages: SQL

Databases: SQL Server 2017, 2016, 2012 , Oracle 7.3, & Oracle 8.0.5, Oracle 8i lite, Oracle 8.1.7, Oracle 9i, Oracle 10g,

Back-end: TSQL, SQL , PL/SQL( 8.1.7) SQL*Plus (8.1.7),

Other tools: Visual Studio 2015/2017, SQL server for Data Tools 2015/2017, SQL Server Management Studio, PL/SQL Developer 5.0.1 / Toad, Forms API Master

Skills: Requirements Analysis and Design, TSQL, SQL, PL/SQL coding, (standard Java coding)), Code reviews, Testing.Coding (Forms 6.0, Reports 6.0) (Forms 4.5 & Reports 3)BI Tools: MS BI - Sql Server Analysis Services (SSAS), Sql Server Integration Services (SSIS), Sql Server Reporting Services (SSRS), PowerPivot / Power View

Front-end: Developer 2000 (Forms 5.0/4.5, Reports 3.0/2.5)/ Developer 6 (Forms6/Reports6)/Developer 6i(Forms 6i)/Reports 6i

CASE Tool: Designer 2000/ Designer Release 2.0 / Visio (for Data modeling and database designing)

PROFESSIONAL EXPERIENCE:

Business Intelligence Developer

Confidential

Responsibilities:

• Learned Business intelligence (BI) and Data Warehousing.
• Databases like: SQL Server 2012, Multi-dimensional databases, ETL, Confidential -SQL, MDX scripts and cubes.
• SQL Server 2012 via Sql Server Management Studio, creation of database objects like stored procedures, functions, views, triggers. Created multi-step jobs in Sql server Management Studio - defined actions on success/failure
• BI Reporting Solutions using SSRS / PowerPivot / Power View, charts, maps, interactive displays. Interacted with Power View Controls including slicers. Implemented dashboard visualization, DAX commands.
• Business Intelligence/OLAP tools like SQL Server Integration Services (SSIS) with DFT, containers, transformations, event handling, logging, configurations.
• SSISDB catalog for projects and implemented them with differing environments/ variables.
• Reporting Services (SSRS) - Parametrized reports, drill down, drill through, interactive sorting reports, report manager, report builder.
• Analysis Services (SSAS) - Developed dsv’s, dimensions, facts, cubes, perspectives, partitioning, hierarchies, KPI’s, roles, aggregations, MDX scripts.

Confidential, Redmond, WA

Program Analyst/Tech Lead

Responsibilities:

• BI stack development.
• Platform - SSAS Tabular Modelling on VS containing DAX measures, SQL Server for coding of stored procedures/ functions/tables/indexes/views etc. DAX studio, Vertipaq Analyzer. Building of visualizations on Power BI/ Excel. Optimization of stored procs etc.
• Built and maintained a cube to support Analytics for Office 365 products. This was done by designing a new data warehouse with relational constructs which had a SSAS Tabular model built on top of it and by phasing out an older tabular design.
• On a regular basis gathering of business requirements for new requests and for enhancements to existing requirements. Ensured ETL from upstream before changes to model.
• Migrated visualizations (Power BI) based on older tabular model to the new model. Made sure numbers tallied before cutting over.
• Partitioning of cube data for better management of daily processing.
• Setting/monitoring/maintenance of jobs which populate data warehouse in sql server agent. Setting up of jobs for processing cube.
• Tabular cube processing of partitions on a daily basis containing about a week’s data. Ensuring cube processing of historical partitions scheduled on a lesser interval.
• Tabular cube code deployments. Backups and restoration of analysis cube if required after deployment.
• Reviews of code with Dax guru and implementation of recommendations.
• Monitoring of cube’s sometimes during peak times/slow performance and aborting sessions on a need basis.
• Occasionally monitoring of daily Azure ADF pipelines.
• Co-ordination with offshore for their development.

Confidential, Bellevue, Wa

Responsibilities:

• Environment - SQL Server 2012 (Sql Server Management Studio), SQL Server Data Tools (Visual studio) - SSIS, SSAS, SSRS.
• Designing a data mart from the Washington Organics OLTP database for reporting and OLAP cubes.
• Developing ETL solution in SSIS to transform and populate data mart from OLTP database and from excel files received from online store.
• Developing, OLAP cubes on the data mart to facilitate analysis by Confidential .
• Designing SSRS reports based on data mart.
• Designing and developing stored procedures and basing some SSRS reports on these stored procedures.
• Configuring SSIS package to run in different environments in SSISDB catalog.
• Created some multi-step jobs in Sql server Management Studio - defined actions on success/failure.
• Functional specifications and low-level detailed design for the same.

Confidential, Bothell, WA

Program analyst

Responsibilities:

• Discussion of system/application design within team and with other team members and communication of same with offshore team members.
• Platform used - Oracle 10g, Oracle PL/SQL Developer (Stored procedures, functions, triggers, indexes) SQL, Developer 6i, (Forms 6i & Reports 6i), Toad, Unix shell scripting(ksh)
• Gather system requirements from business analysts and end user.
• Co-ordinate design with offshore team by passing requirements.

Confidential, Seattle, WA

Program analyst

Responsibilities:

• Retail Management system’s(RMS).
• Screens for Allocation of Inventory to Retail Stores process/ Purchase order screens from Oracle Forms.
• Webmarkdown reports containing Markdown items for the last 3 months based on Stored procedures. Optimization of same.
• Built ksh script for utilizing Syncsort tool.
• Plan and submit job threads for production for review/ implementation by Control - M team. Plan for optimal job flow.
• Platform used -Oracle 10g, Oracle PL/SQL Developer, Developer 6i, (Forms 6i & Reports 6i), Toad, Unix shell scripting(ksh). (Development of Oracle packages, Stored procedures, functions, triggers, indexes etc.)
• Gather system requirements for business analysts and end user.
• Review design internally/with architects and dba’s if required.
• Review job flows with control-m team.
• Deploy code with control-management team during test and move to production.
• Development on Oracle procedures, functions, packages, forms/reports, ksh scripts/syncsort functions. Optimization of procedures, packages, sql’s/queries - multithreading through ksh scripts. Fixes to back-end packages/procedures using toad and oracle pl/sql developer.
• Trouble shooting production problems and fixing Oracle backend/front end sources if required.

Confidential, Seattle, WA

Developer

Responsibilities:

• Development in Oracle 10g, Oracle PL/SQL Developer, Developer 6i, (Forms 6i & Reports 6i), Toad
• Bug fixes/Enhancements to screens.
• Bug fixes/Enhancements to reports and forms using Oracle Forms and reports.
• Also fixes to back-send packages/procedures using toad and oracle pl/sql developer.
• Code review, test and deployment.
• Discussion of enhancements/bug fixes with domain expert.

Confidential, Seattle, WA

Developer

Platform used: Oracle 9i, Oracle PL/SQL Developer, Forms API Master, Developer 6i, (Forms 6i & Reports 6i)

Responsibilities:

• Built screens for Container inventory management, Gate operations.
• Built statistical reporting on Oracle reports/ Stored procedure.
• The system empowers terminal operations with complete visibility and control of cargo Confidential the gate, yard, vessels and rail cars. The result is faster and more efficient cargo processing.
• Discussion of specifications for new programs with BA’s or with the user sometimes - document their low level design, followed by their development in either -
• Oracle Forms and Reports according to Confidential standards.
• Time critical trouble-shooting for problems in production as and when needed.
• Optimization of slow-running reports.
• Optimization of slow-running back-end packages/procedures and functions.
• Resolution of problems such as mutating triggers/sequences out of order etc.
• Peer level review of others development specifications.
• Peer level code review of new programs.
• Used Scrum methodology to track bugs and other tasks.

Confidential

Systems Analyst

Responsibilities:

• Built Confidential for state of Montana for issuance of Licenses, Certifications to its customers throughout the state of Montana, through POS devices (Point of Sale devices).
• Did the business requirement discussion with the client, supported by complete documentation, its exchange and review by user.
• After analysis finalization with user, did the overall as well as detailed database & application design in Designer 2000 / Visio & Word.
• Was the internal design reviewer for all the Phase 2 modules.
• Design presentations to clients of the modules developed for Phases 1, 2 & 3.
• Platform for all three phases - Designer 2000, Developer (Forms 6.0 & Reports 6.0), Oracle 8.0, Oracle 8i lite, Oracle 9i.
• During the course of the project, helped in streamlining the system, by identifying programs that needed optimization. Helped in getting them optimized functionally (by discussion with user, removing redundant functions / data if any) and technically (sqls, bind variables, temporary tables, relegating procedures to back end etc.).