Post Job Free

Resume

Sign in

Data Sql Server

Location:
Allen, TX
Posted:
August 16, 2016

Contact this candidate

Resume:

Ram Sayana

Database Developer/Admin /Solution Architect/Data Architect

Cell: 817-***-**** email acv7be@r.postjobfree.com

SUMMARY:

12+ years overall IT experience in software architecting, leading and development. In-depth knowledge to Microsoft Products like. NET Framework versions 1.1, 2.0 to 3.5. VB.NET, C#. Net, ASP.NET, SOA, Sharepoint, BizTalk, Visual Basic, Visual C++ 6.0, MS SQL Server 7.0, 2000, 05, 08 and 2012( Denali). SSRS, SSIS, Data DB2, Data Stage, Oracle, PL SQL, ERWIN, Sybase.

Good Knowledge of Data Marts, Data warehousing, Operational Data Source(ODS), OLAP, OLTP, Data Modeling like Multi-Dimensional Data Modeling, Star Schema, Snow Flake Modeling, Slowly Changing Dimensions (SCD), FACT and Dimension Tables using Analysis Services.

Strengths include Data Architecture, database administration, production support, Performance Monitoring and Tuning.

Experienced in software architecting, leading and development. In-depth knowledge to SAP Products like SAP HANA, BO/ BI, BODS, Xcelsius dashboards, Web Intelligence, Dashboard Designer, Crystal Reports, SLT, SAP BW (BEX), ECC, SAP Design Studio, Data modeling, Tableau, VISIO, Oracle.

8+ years of proven DB2 DBA experience expertise in leveraging DB2 database platform for enterprise wide solutions. Work experience includes DB2 Application Programmer/ DB2 Database Administrator.

Exposed to all phases of software development life cycle (SDLC) including in-depth knowledge of agile methodology, enterprise reporting life cycle, SQL server migrations, change control rules, problem management and escalation procedures.

Involved in design, enhancement, and development of applications for OLTP, OLAP, and DSS using dimension modelling with Teradata and Oracle

Expertise in installing, Configuring and maintenance of SQL Server 2000 / 2005, 2008, 2010 on Standalone, Microsoft Clustered servers and Applying latest Service Packs, Hot fixes and security patches in Windows 2003 Enterprise Server in high availability environment.

Area of technical expertise also includes ADO.NET, ODBC, Web Services, and XML & XSLT.

Extensive experience in implementing Middleware technologies as COM, DCOM and Internet Technologies such as Active Server Pages, ASP.NET and Web Services.

Highly proficient in ETL, Data transformations, reporting tools.

Experience in various extracting, transforming and loading (ETL) data flows using SSIS with complex integration of SQL with oracle, flat file sources and IBM mainframe DB2

Advanced extensible reporting skills using Crystal Reports and SQL server reporting services (SSRS). Created & formatted cross-tab, conditional, drill-down, top n, summary, form, OLAP, sub reports, Adhoc reports, parameterized reports, interactive reports & custom reports

Microsoft Certified Professional.

Developed reports in Geneva for financial reporting.

Version controls: VSS, CVS, TFS.

Excellent in Migration of SQL Server 2000 to SQL Server 2005 & SQL Server 2005 to SQL Server 2008.

Vast exposure to the full software life cycle phases (system analysis, design, coding, testing and maintenance.

Perseverant, meticulous and a committed team player.

Residential Legal Status: US Citizen.

TECHNICAL SKILLS:

Languages: .NET 1.1/2.0/3.0/3.5, C#.NET, VB.NET, C, C++, JAVA

GUI: Sharepoint, MOSS 2007, WSS 3.0,.NET, (Crystal Reports,

Active X, ADO.NET),

Visual Basic 6.0, Visual C++ 6.0, Siebel, PowerBuilder, NUnit

RDBMS: MS SQL Server 2000, 05, 08 and 2012(Denali). SSRS, SSIS, Oracle.

DBMS: MS Access, AS 400.

Middleware Technologies: COM, COM+, DCOM, ATL, LDAP, Active Directory, MSMQ

Internet Technologies: IIS 6.0, 7.0, HTML, DHTML, Active Server Pages, ASP.NET 3.5, WCF, WPF, Sileverlight, IIS, MTS, VS 2008, Personal web server, XML, Web sphere, MS Site Server 3.0, MS Commerce Server 2000

Tools: ERWIN, Rational Tools, FTP, EDI. Photo Shop, Visio, Remedy, iSeries, SQL Reporting Services, SQL Navigator, Rapid SQL and TOAD,

PVCS and Visual Source Safe

Operating Systems: WINDOWS NT 4.0 / 95 / 98 / 2000, MS DOS, UNIX, XP

Back Office Products: MS Word, LOTUS, and Power Point,

EDUCATION / TRAINING / CERTIFICATIONS:

Master’s degree from Nagarjuna University, India

Bachelor’s degree from Nagarjuna University, India

CERTIFICATIONS:

Microsoft Certified Programmer

Certified Solution Architect in TOGAF 8 Certified by The Open Group.

PROFESSIONAL EXPERIENCE:

American Airlines, Inc., TX Jan 2016 – Present

Principal Data Architect,

Tach Opps / AMPS

Aircraft Maintenance Planning System (AMPS) implementation for American Airlines. As a result of the merger between AA and US, TechOps workload planning department requested a new integrated planning tool named AMPS that will combine the functionality available in the legacy US LAMPS system with new AA line and base planning functionality. The intent of the newly integrated AMPS product is to provide a unified interface for both LAA and LUS line and base planning groups to perform workload planning. The tool will allow planners to save workload packages/BOW to respective legacy systems in the back end.

Responsibilities:

Reviewed all LAPS and MAPS Capabilities and provided consolidated solution to build AMPS.

Expertise in building Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Multidimensional Model (Kimball and Inmon), Star and Snowflake schema design.

Designed and developed ETL processes using DataStage designer to load data from Oracle, MS SQL, Flat Files (Fixed Width) and XML files to staging database and from staging to the target Data Warehouse database.

Provided architectural artifacts context view data flow view and Data architecture view.

Documented all the current state and target state environments and provided blue print.

Setup meetings with business, technology, infrastructure and database and gave demos about our solution.

Designed and developed ETL process for migrating LAMPS database to new AMPS database using SSIS and

Led on building Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Multidimensional Involved as primary on-site ETL Developer during the analysis, planning, design, development, and implementation stages of projects using IBM Web Sphere software (Quality Stage v8.1, Web Service, Information Analyzer, Profile Stage, WISD of IIS 8.0.1). Models (Kimball and Inmon), Star and Snowflake schema design.

Efficiently in incorporated various data sources such as Oracle, MS SQL Server, and DB2, Sybase, XML and Flat files into the staging area.

Worked on Governance process and attend AAC meetings for approval.

Worked with development team and providing technical specifications.

Attended agile calls and answering the questions and providing solution for performance issues for current state applications.

Environment: VS 2005, 2008 and 2012. .NET Framework 4.5, C#. NET, Java, DB2, Big Data, Hadoop, Microsoft SQL Server 2008 and 2012, DB2, Python, IBM Infosphere Datastage 8.5/8.1, Teradata12, MySQL, SSAS, SSIS, SSRS, BIDS, Crystal Reports.

Citi Group, TX June 2015 – Dec 2015

Lead Data Architect/ Big Data Engineer,

Fraud Services

Responsibilities:

Gathering business requirement and Analyze and design and develop this FRD First data project.

Developed testing environment for FDR data migration. Researched all the database object for this effort and Created snapshots from source and tested with local schema.

Converted all the SSIS packages into stored procedures as per business need.

Worked on Designing, Developing, Documenting, Testing of ETL jobs and mappings in Server and Parallel jobs using Data Stage to populate tables in Data Warehouse and Data marts.

Prepared testing scripts for FDR data from source to target. Worked with other team members and coordinated the development.

Installed and configured Apache Hadoop, Hive and Pig environment on the prototype server. Configured SQL database to store Hive metadata and Loaded unstructured data into Hadoop File System (HDFS)

Fixed issues in SAS data analytical and advanced analytical reports and turn the SQL to run faster.

Managed database instances for Consolidated Online trading system in DB2 UDB in version 8.x and 9.x on AIX 5.3 and Linux servers

Used OLAP and OLTP and Star schema to design data marts and data warehouse.

Worked on SQL Server Administration tasks using various backup strategies, database maintenance plan, user (NT/SQL) security authorizations, database creation, Tables, indexes.

Provided SQL Server database related technical insight on this project for migrating data warehouse.

Analyze differences between old and new system change requirements, create logical and physical database design based on required changes, create/update technical design documents and production support system operations and maintenance guide responsible for estimation of work effort for project

Overall Solution Design that includes end-to-end Process Flow, Web Services definitions/message formats/security. Provided ER diagrams and logical data models by using VISIO.

Migrated some Cognos reports into PowerBI reports and integrated into iPod and tablets.

Identified and optimized SQL statements in stored procedures/reports, which were pain points. There was a 35% improvement in the critical path stored procedures and 53% improvements in the reports.

Reviewed and optimized SSIS packages, SSRS reports and, NET application. Provided document with list of improvements and implemented successfully on Production.

Build cubes using SSAS and integrated to SharePoint. Users can user filters to generate reports.

Redesigned entire database and introduced table partition to keep the historical data.

Worked with other associate to setup new development, Testing, Staging and Production environments.

I have used PowerShell script, commands for SharePoint site administration

Worked on Terra data scripts. Fixing issues and updating scripts and running querys.

Managed and monitor integration database and system performance. That includes optimization and tuning of data loads, extractions, and the recommendation of appropriate changes to ensure and improve system performance and reliability.

Converted some Cognos reports into Geneva reports for financial analysis. We customized to show different categories and different formats. We scheduled to send an email to appropriate folks.

Upgraded .NET Application from 2005 to 4.1. Tested and deployed on production.

Partitioned key tables for performance improvement.

Worked on SAS reports. Updated as per business request and deployed on production.

Troubleshoot the daily database issues and how we can improve the current state environment.

Provided Blue print document about Current state and Target state with how this is will be beneficial for business.

Environment: VS 2005, 2008 and 2012. .NET Framework 4.5, SAS, Big Data, Hadoop, DB2, EmpowerMX, Microsoft SQL Server 2008 and 2012, PowerBI, Python, IBM Infosphere Datastage 8.5/8.1, Teradata12, MySQL, QlikView, SSAS, SSIS, SSRS, BIDS, Crystal Reports, Business Objects XI, Report Portal 3.0.

Citi Group, TX Sept 2014 – June 2015

Lead Solution Architect,

CTI Business Intelligence

Responsibilities:

Gathering business requirement and Analyze and design and develop this huge project.

Provided SQL Server database related technical insight on this project for migrating data warehouse.

Analyze differences between old and new system change requirements, create logical and physical database design based on required changes, create/update technical design documents and production support system operations and maintenance guide responsible for estimation of work effort for project

Overall Solution Design that includes end-to-end Process Flow, Web Services definitions/message formats/security. Provided ER diagrams and logical data models by using VISIO.

Provided solution for logical data diagrams and strategies to bring the data from Source to Target by designing the ETL process by using work flows, data flows, quality transforms, filter the data as per requirements and loading the data in target.

Provided architecture artifacts for Big data solutions and integration with other systems. Presented Blue print about Current state and Target state solution.

Provided solution to load data from different sources to target staging server and design data model using VISIO and providing logical and physical database diagrams and loading data using SSIS ETL process.

Responsible for implementation and ongoing administration of Hadoop infrastructure.

Deploy new hardware and software environments required for Hadoop and to expand memory and disks on nodes in existing environments

Converted huge Cogon’s reports in to Business Objects and deployed in to production.

Created Hive Tables, loaded retail transactional data from Teradata using Scoop.

Loaded home mortgage data from the existing DWH tables (SQL Server) to EDW using Scoop.

Wrote Hive Queries to have a consolidated view of the mortgage and retail data.

Installed UNIX and setup ODBC, DSN. Install third party drive SIMBA Hive and created remote data source to Hadoop to get data real time for reporting.

Designed cubes using dimensional Start schema’s and published on SharePoint.

Leading onshore and offshore teams in India and providing all the functional requirements and technical design documents and co-ordination the development.

Work on proof of concept and prototyping activities to assess whether the proposed architecture and database components meet the non-functional requirements like reliability, scalability, performance and maintainability.

Leading the team and providing solution to design and working on agile environment to keep track of the development and providing communication to business and management.

Teradata V2R12.x systems and used utilities like MultiLoad, FastLoad, FastExport, TPump, Teradata SQL.

Automated BizTalk application deployment from TFS using build templates that trigger Powershell scripts.

Wrote Python scripts to schedule jobs and data migration.

Integrated Business Objects dashboards with SharePoint. Imported all the reports data into our reporting database.

Created new repository’s for new requirements and maintain the repository’s and work on role based authentication to provide access to users.

Designed SSIS ETL tool to migrate data from multiple sources to Reporting database for reporting.

Designed and developed Reporting system using .net, C#.net, WCF, WPF.

Designed and developed a modular accounting application using WPF, Unity, Prism and MVVM. Also built a custom installer to mimic click-once behavior.

Some of the longer-running database processes. In some cases yielding a greater than 90% performance improvement.

Environment: VS 2005, 2008 and 2012. .NET Framework 4.5, Cognos,,, Hadoop, Microsoft SQL Server 2008 and 2012, PowerBI, UNIX, IBM Infosphere Datastage 8.5/8.1, Teradata12, MySQL, QlikView, SSAS, SSIS, SSRS, BIDS, Crystal Reports, Business Objects XI, Report Portal 4.0.

Dell Inc, Austin, TX Jan 2014 – Aug 2014

Lead DB developer/ BI Solution Architect,

SnP & LTG Integration:

The overall vision is to migration LTG and set of regional process, applications to under one common (global) portal eDell (SLM).

The SnP/LTG Migration to Digital Fulfillment is the execution of a multi-year strategy to deliver consolidation and standardization of disparate business process, technologies and customer impacting Portals and Service tools. Impacted products include SnP 3rd party software offerings, Cirrus (cloud fulfilled but tied to box), Media Reduction (early DF capability which removes packaging requirements in factories) and Consumer Subscription capabilities (Office 365 Consumer…among others).

Responsibilities:

Understood the multiple systems in short ramp up time.

Reviewed BRD documents and provide suggestions and feedback.

Worked on Solution Architecture document for DELL Digital Download Migration from LTG Infrastructure.

All the systems were developed in .NET, ASP.NET, AJAX, Web service, BizTalk, Oracle and MS SQL Server.

Used to travel and providing solutions and demos about the system process and solutions.

Transferred technical knowledge to two administrative personnel through providing onsite training, detailed best-practice documentation, architecture, and procedures for DB2 systems.

Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2000/2005/2008 R2 and 2012.

Designed and developed functional specifications, technical specifications for BOBJ reporting on top of SAP HANA Models.

Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).

Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.

Updated and wrote Python scripts for jobs and data back up and re-covey.

Created multidimensional star schemas. Define fact tables and dimensional.

Worked on Governance process and administration.

Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.

Planned and developed account migration process for a multi-domain e-mail migration from internal and external AD domains running Exchange 2003/2010 to Google Apps Mail. Migration scripts developed with Powershell.

Excellent in High Level Design of ETL SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.

Developing reports on SSRS on SQL Server (2000/2005/2008). Sound Experience and understanding of SSAS, OLAP cube and Architecture.

Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.

Review current state of Database’s on LTG. Providing solution how to migrate this date in to DF and Product Group. Mapping current state database schema with target state schema and providing solution for data migration.

We build new reporting tool using Geneva reporting tool for on demand reports.

Set up new WCF service and sending data though Oracle enterprise bus. Getting response back to the client.

Provided solution for communicating multiple systems with Web services and WCF services.

Provided demo’s about current state and Target state systems and providing PAD and SAD documents to technical team.

Environment: VS 2005, 2008 and 2012. .NET Framework 4.0, C#. NET, Microsoft SQL Server 2008 and DB2, UNIX, SAP HANA 1.0, Business Objects, MySQL, Geneva reports, SSAS, SSIS, SSRS, BIDS, CVS, VSS, Crystal Reports, Business Objects XI, Report Portal 3.0.

Bank Of America, Dallas, TX Jan 2011 –Dec 2013

Database developer/ DBA,

MCCA Speech IVR system:

We designed Speech IVR system and entire database for this project. This is based on .NET 4.O application.

We used Gang four patterns and TOGAF patterns to design this system.

Responsibilities:

Deigned entire system for Income call log in information into Database.

Analyzing business requirements and designs/architects new IVR/Speech solutions

Involved as primary on-site ETL Developer during the analysis, planning, design, development, and implementation stages of projects using IBM Web Sphere software (Quality Stage v8.1, Web Service, Information Analyzer, Profile Stage, WISD of IIS 8.0.1).

Created Business, application, database and infrastructure diagrams using Visio.

Installation of Sql Server 2008 Standard edition and enabling SSIS/SSRS/SSAS on Analytical Development server.

Developed multiple Webi reports for Predictive metrical availability using BI Launchpad. Created universe’s in IDT for all these new reports by using Design Studio. Wrote scripts to customize the some special columns.

Leading about 25 developers onshore and offshore teams from India and USA. Used to provide design solutions and keep track the development. We also follow life cycle process deploying on Dev to Prod and communicate to both business and management.

Setup CIT and UAT database environments. I also backup and restore the databases on these environments and setup the security for database.

Worked with developers closely and support on database issues and provide the information about database access.

Analyzed the requirements and worked on Data modeling based on business requirements, designed all master and child tables and relations using VISIO. Also created physical database tables as per Visio diagram.

End to End HANA POC technical activities including loading data into HANA tables from Flat Files using Data Services, Modeling in HANA (Analytic and Calculated Views), creating Universes on top of HANA Views in IDT, Reports in WebI and Dashboards in Dashboard Designer.

Advanced scripting and ETL, data modeling (star schema); worked with large data sets.

Used complex QlikView functions and developing most optimal scripts for a given solution.

Good experience on SQL, relational databases and Dimensional Modeling, Optimization of data model for performance.

Backup and restore the data to new tables and also imported from flat files to new tables.

Set up SSRS and SSIS environments and Created many different types of reports and deployed on CIT and UAT. Supported business, how to use this reports.

Setup nightly running jobs for data replication from Production to UAT and CIT.

Tuning and troubleshoot the database issue and support team 24/7.

Created many complex SSIS packages for data import from other sources to our database’s. We also setup the email notification upon successfully execution of the job. I used to trouble shoot the data issues and support business.

Designed and developed SSRS Reports using visual studio. Wrote complex queries, stored procedures and functions to fetch the data from database.

Developed and supported SSRS reports system like Chart reports, Master detail, Drill down, drill through reports.

Designed and developed functional specifications, technical specifications for BOBJ reporting on top of SAP HANA Models.

Designed the database by analyzing the data requirements and created the entire relational database for this project.

Designed and developed reports in Cognos. Tuning the reports and queries for better performance.

Worked with tabular reports, matrix reports, gauges & chart reports, parameterized reports, sub reports, ad-hoc reports, drill down reports as well as interactive reports according to business requirements in time restricted environment using Crystal Reports and SQL server reporting services (SSRS).

Created ad hoc reports as requested and conduct ad hoc research using Crystal Report XI

Designed, developed, analyzed Crystal reports from the Business Objects Universe.

Migrated data from old environments to LLE. Backup and restore and setting up security to different groups and support from MS SQL Server 2005 to 2008.

Wrote SSIS packages to push data from production to LLE every single night.

Worked on Data purging, cleaning up the data which is older than 13 months. Archive the data and deleting data using SSIS packages.

Created packages in SSIS with error handling as well as created complex SSIS packages using various data transformations like conditional split, fuzzy look up, for each loop, multi cast, column conversion, fuzzy grouping, and script components.

Provided technical direction to a team of contact center engineering professionals

Create work flows in .net 4.0 and provided to developers for coding using Gag four patterns.

Designed Web services for this third party to get data and insert into our database.

Setup security for this application, by following corporation requirements.

Environment: VS 2005, 2008 and 2012. .NET Framework 2.0 and 3.5, C#. NET, Business Objects, Cognos, Microsoft SQL Server 2008 Python, Datastage, Oracle 10g,Teradata, SQL, PL/SQL, Perl, SSAS, SSIS, SSRS, BIDS, Crystal Reports, Business Objects XI, Internet Information Server (IIS), CVS, MS Excel 2007, Report Portal 3.0.

American Express Cards, Phoenix, AZ Aug 2009 –Jan 2011

Lead Database Architect/DBA.

Data Center Migration Project:

ECCO (Extraordinary Customer Care Online)

The American Express Learning Network (AELN) has initiated the ECCO (Extraordinary Customer Care Online)

Program which will aid in the replacement of the current performance support tool, PORT (Point of Reference Tool)/JARIS (Job Aid Reference Information Systems). The objective of the program is to procure and implement an ECCO tool that will align with the overall strategy of providing robust authoring functionality, intuitive search capabilities for on-the-job information and reduce overall technology maintenance costs on the tool.

The DC2015 program is comprised of 3 primary work streams:

•Governance (PMO, financials, communication)

•Technology (remediation and migration)

•Facilities (IPC runway and new data center)

Critical to the overall migration strategy, is the management of our midrange applications, both in the near and far timelines. In the near term, we are moving forward with a new infrastructure design and pre-position E3 environment in the IPC, starting Q2 2010, to host applications that are currently meeting standards for their remediation work and RA upgrades.

We are planning on moving the majority of the midrange applications in 2012 and 2013 with four windows scheduled for 2013 to complement the Mainframe moves. These applications will be clustered into move groups based on application platform, business capability similarities, and other parameters to minimize the overall risk of migration and business downtime.

Responsibilities:

Worked with project lead, analyst and business users to understand business processes, document project requirements and translate them into functional and non-functional specifications for BI reports and applications

Designed entire database as per business requirements using Visio. Provided the demo of the data Model and build new database as per Visio.

Developed SSRS reports like Chart reports, Master detail, Drill down, drill through reports.

Worked on data center migration from one data center to other data center. We have migrated huge Active reports project to Crystal reports.

Used Business Objects Crystal Xcelsius and Query as a Web Services (QAAWS) for data access.

We integrated Remedy system with Crystal reports. We automate this report system flexible to users. So users can enter parameters and generate the reports.

Designed and developed complicated reports using Crystal Reports.

Formulated and documented the physical ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, expressions.

Involved in creating specifications for ETL processes, finalized requirements and prepared specification document.

Used Business Objects Data Services to extract data from various sources including flat files of fixed format, Excel, XML, CSVs and databases like Oracle 10g/11g, MySQL and SQL Server.

Involved in deploying SSIS packages for various environments.

Created packages in SSIS with error handling as well as created complex SSIS packages using various data transformations like conditional split, fuzzy look up, for each loop, multi cast, column conversion, fuzzy grouping, and script components.

Designed and developed reports with running value, interactive sorting as well as conditional formatting.

Providing solution for design, technical, infrastructure, integration with other external systems like Cognos.

Reports, matrix reports, gauges & chart reports, parameterized reports, sub reports, ad-hoc reports, drill down reports as well as interactive reports according to business requirements in time restricted environment using SQL server reporting services (SSRS) and Crystal Reports.

Designed and developed report with running value, interactive sorting as well as conditional formatting

Experience on created reports using stored procedure. Involved in scheduling, creating snapshot and subscription for the reports and triggers to facilitate consistent data entry into the database.

Created projected income statements and other financial reports. Developed yearly, quarterly, monthly sales Reports, bench marking reports and commission reports

Created SSRS report model projects in bi studio and created, modified and managed various report models with multiple model objects, source fields and expressions.

Created sub-reports to present more detailed information about the summary in Crystal Reports.

Created ad-hoc queries and reports for unit team lead as requested and provide on-going analytical support for these requests.

Designed OLAP cubes with star schema and multiple partitions using SSAS

Providing info about timelines, budget, and technology to team and helping team in technical issues. Code review and deployments and presenting demo to management and team.

Environment: VS 2005, 2008, .NET Framework, C#. NET, Business Objects, Cognos, Crystal Reports, Microsoft SQL Server 2008/2005 Python, Navision, SSAS, SSIS, SSRS, BIDS, Data Stage 7.5.1 Enterprise Edition, Oracle 10g, Remedy 7.5, IIS, DTS, Data Modeling, ETL, MS Visio, UML, Web Services.

HD Vest / Wells Fargo PCS, Dallas, TX July 2008 – June 2009

Lead. Software Developer / Architect

.Net, FileNet, CSL, UMT, Rep Track, OFAC, MIS and Client Center

H.D. Vest provides it’s



Contact this candidate