Manager Sql Server

Nooshin Nosrati

*** ******** ****** *********, ***** 1608, Toronto ON, M2N 0C2

*******.*******@*****.***, Tel: +1-416-***-****, Fax: +1-647-***-****

Bussiness Intelligence/Data Warhouse/ETL DEVELOPER

An energetic, multi-faceted, and talented Information Technology professional with over 10 years of experience in analysis, design, development, implementation and testing the enterprise solutions, business applications and custom software. Exceptional understanding of SDLC and diverse technical expertise of cutting-edge development technologies and tools. Area of expertise includes Business Intelligence, Data Warehousing, Data Modeling (Star Vs Snowflake), ETL, OLAP Cubes, Data architecture, Business Objects, Business Analysis, Project Management. Extensive project experience with Telecommunication, Banking and Financial systems. Results-oriented, resourceful and creative thinker, adept at nurturing team synergy and innovative solutions to complex challenges. Astute communicator with excellent problem-solving and organizational skills.

Summary of technical SKILLS

Languages: SQLServer/T-SQL, PL/SQL, Oracle/SQL, XML, COBOL OS390/COBOL II/CICS, JCL, C

Databases: MS SQL Server 2005/2008, Oracle 7.3/8i/9i/ 10g, DB2, IMS/DB, IMS/DC

BI/DW/ETL: Microsoft Visual Studio 2005/2008 (SSIS, SSAS, SSRS), Cognos 8.3 (Query Studio, Report studio, Analysis Studio, Cognos Connection, Framework Manager, Transformer, Powerplay), Crystal Report, Data Stage ETL, Informatica ETL, Business Objects, SAP BWBI, Oracle (Developer/2000)

Tools: TOAD, MS Excel, MS Word, MS Visio, MS Project, TSO/ISPF, SPUFI, File-AID, Change Man, XMIT, MQ Series, XPEDITER, BMS, DB2/OS390 Utility, OMEGAMON, RACF, CRAMER, CCC/Harvest, Remedy, CASE Tools

OS: Ms Windows, UNIX, MVS/ESA (IBM Mainframe), OS/2

Methodologies: Object Oriented Design/ Data Modeling with UML, Rational Rose and Erwin, CGI CONCERT, SSADM

professional experience

Client Information Analyst/Cognos Framework Mgr, Report studio Developer, Mosaic Sales Solutions/CIM (Consumer Impact Marketing), Toronto 06/2011- PresentProficient in design business models to meet the complex reporting requirements using Cognos Framework Manager, Report Studio and Query Studio.Created various SQL scripts to be used in Framework Manager and also for the verification of the data.Developed Framework Manager model against Star, Snowflake and Fact Constellation data models. Created Framework Manager packages and publishing the same for various clients.Created Powerplay Cubes based on the Cognos 8 Packages and Reports.Created Various Dashboard Reports for different business areas based on Powerplay Cubes Worked on dimensional Framework, transformation models.Generated various List Reports, Grouped Reports, Cross tab Reports, Chart Reports and Drill-Through Reports. Created calculations, filters, prompts and session parameters.Distributed reports through E-mail.Scheduled reports to run on a monthly, weekly and daily basis using Cognos Scheduler.Created new stored procedures, analyzed and manipulated the data using SQL Server 2008

MS SQL Server 2008, Excel 2010, Cognos 8, Cognos Connection, Report Studio, Query Studio, Transformer, Powerplay, Framework Manager)

BI/ DW/ ETL ANALYST and DEVELOPER, Micro Object Solutions, Toronto 2/2009- 06/2011

ETL DeveloperWorked with business analysts and users to understand the requirements.Cooperated with ETL team to identify business processes and dimensions, built initial data warehouse bus matrix, and prioritized the processes.Defined facts and dimensions according to bus matrix, further defined surrogate keys, slow changing dimensions, star schema, snowflake schema, hierarchy and aggregates. Built staging database to extract data from transactional system. Created SSIS Packages using different control flows, such as FTP Task and File System Task to transfer files and perform file system operations like copy, move, delete files or folders; For Each Loop Task, For Loop Task, Sequence Container Task to execute a set of tasks multiple times and group together several tasks; Execute SQL Task to execute SQL statement against SQL server. Created SSIS package connection manager to import data from Excel Spreadsheets, Text file, MS Access and CSV files to SQL server 2005.Filtered bad data from legacy system using Conditional split, Data Conversion, Derived column, Fuzzy Lookups, Lookups transformations. Split large volume of data into different set for comparison using Multicast, Fuzzy Lookups, and Lookups transformations. Combined same structured data into one set using Merge, Merge Join, Sort, Union All transformation.Considered the slow changing dimension property by using SCD transformations.Used audit table created by database trigger to make delta load to data warehouse.Scheduled SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to main data warehouse servers.

BI DeveloperCreated and maintained Analysis Service objects such as Cube, Dimensions, MDX queries, and KPI’s.Aggregated cube with 40% performance for better performance.Generated reports using SQL Server Reporting Services 2005 from OLTP and OLAP data sources.Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.Created tabular, matrix, chart, drilldown reports, parametric, cascaded reports and dashboards and scorecards reports according to business requirement.Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.Created report models and deployed on report server.

COGNOS DeveloperPlanned and created professional reports in Report Studio and ad hoc reports in Query Studio. Generated various List Reports, Grouped Reports, Cross tab Reports, Chart Reports and Drill-Through Reports. Generated explorer/reporter report in Powerplay. Created calculations, filters, prompts and session parameters used by report authors.Distributed reports through Bursting, E-mail and uploading to folders.Scheduled reports to run on a monthly, weekly and daily basis using Cognos Scheduler.

MS SQL Server 2005/2008, Excel 2003/2007, Visual Studio 2005(SSIS,SSAS,SSRS), Oracle, Cognos 8, Cognos Connection, Report Studio, Query Studio, Transformer, Powerplay, Framework Manager)

SENIOR DEVELOPER / ARCHITECT/ ETL/ DW/ CONSULTANT, CGI (www.cgi.com), Toronto 7/2002-12/2008

Analyzed, designed and implemented various telecommunication related solutions for Bell Canada.

ETL/ Data Warehouse ArchitectDesigned, developed and tested the Data Stage jobs and Oracle data bases for XDSL/4146 project to transfer Mainframe data to Oracle data bases for CRAMER based applications. Data was later consumed by the CRAMER objects such as Locations, Clouds and Equipments. Defined the complete data warehouse architecture (ETL process, Data Marts, )Defined data and technical architecture and technical requirements, meta data standards for the DWDesigned and developed the ETL process involving data quality and testing

(Data Stage tool, Oracle, SQL, PL/SQL, Toad)

Senior Developer/ Architect Managed, assessed, analyzed, designed, developed and tested the applications of ONMP and NRMS (Bell Canada’s Optical Network Management Planning and Network Resource Management System) using a central network inventory repository (known as CRAMER), provided a solution to Bell Canada’s Transport Network Operations Groups with for managing physical and logical Optical network inventory and services.

(CRAMER-Wizard/Task Engine/Delivery Engine/Resource Manager, Oracle, PL/SQL, SQL, Toad)Managed, assessed, analyzed, designed, developed and tested Mainframe project of Express Service to enhance the client installation delivery intervals by offering next day express service for a fee (based on defined business rules and client’s complex requirements) and to accommodate the particularities of the Express Service requests on work orders to make the field personnel aware of such special requests to apply required workflow procedures. Assessed, analyzed, designed, developed and tested the Mainframe application of CVME (Consumer Voice Messaging Enhancements) to enhance the Call-Answer Service, which enables wire line customers to use Web Voicemail, Voicemail-to-Email, and Jazzy Greetings with their existing wire line services. Analyzed, designed, developed the other Mainframe projects including ADSL Unbundled Loops/PRS extract, Outside Plant Interface/Digital Subscriber Loop, eCENTREX, NGDLC DSL Class of Service, Single Number Reach Extract, EMAAK Opt1, MQ/XML (re-route reports to an EMAAK server and other LTERMs).

(COBOL, IMS, DB2, CICS, JCL, MQ series)

SENIOR DEVELOPER / TEAM LEAD / ARCHITECT, ISC Corporation. 3/1997-6/2002

ISC is leading software development and consulting firm with over 2000 employees, specialized in software and hardware development for banking, financial, telecommunication, government projects and VSAT (satellite services), ATM, POS, IVR. Designed and implemented various Banking related solutions for National Bank, Agriculture Bank, Saderat Bank and Karafarinan Bank. Led and mentored a team of 10 programmer/analysts working with mainframe and PC technologies, taking responsibility of the whole team - constantly insisted on team work.Proposed, analyzed, designed (software architecture and database structure), implemented several different projects and acted as the hands-on team lead (full development life cycles). Projects were including the online print using batch programs in CICS environment, Re-engineering existing applications by integrating parametric features (such as new account types/subtypes), conversion of all existing account types from manual systems to full computerized systems, developing online applications such as Standing Order, Sweep account, Overdraft and certified cheques. Designed and implemented Batch cycle programs for end of day/year such as backup, account process, interest calculation, salary, General Ledger process, reporting, archiving in VTAM print application.

Conversion programs (data from ATM transactions to mainframe DBs and creation of interfaces for other banking terminals such as ATM and POS). Y2K Conversion project. Designed and implemented Online applications such as Branch definition, account rules, currency rates, charges, calendar, customer information and application security (authorization levels). Teller monetary/non monetary online transactions.

(CICS/COBOL, IMS, DB2, JCL, TSO/ISPF, BMS, QSAM, MVS, VSAM and SSADM methodologies/Case Tools)

DEVELOPER, Registration Organization 7/1996-3/1997Designed, developed and tested the application of National Identification Card and related integrated information systems using FoxPro on Win 95 and COBOL/ORACLE, SQL on UNIX.

DEVELOPER, Ministry of Culture and Heritage 2/1996-7/1996Developed, tested the Directory of Historical Buildings application (a comprehensive interactive system defining and maintaining historical information of all monuments in the country) using FoxPro.

EDUCATION AND PROFESSIONAL DEVELOPMENT

EDUCATION B.Eng. in Computer Software Engineering (Grade A+ in thesis), Tehran Azad University, 1995

ETRAINING/CERTIFICATIONSBusiness Intelligence/Data warehousing Post Grad Diploma (COGNOS Report, SQL Server 2005/Oracle10g, SQL Server SSIS, SSAS, SSRS, Informtica ETL, Oracle 10g Administration), Toronto College of Technology, 2009Project Management Program, CGI Co., 2007Business Analysis Program, MC Master University, 2005CRAMER complete development certification, CRAMER, 2004CGI CONCERT Methodology, Consulting Skills, Data Stage, XML training courses, CGI Co., 2002- 2004ISPF/PDF, COBOL, MVS OS, UNIX essential/admin, CICS, DB2, BMS, JCL, Utilities, IMS/ESA DB, IBM, 1997

Contact this candidate